I'm trying to migrate a production DNN installation running on a shared server (with central MS-SQL 2005 database), to a virtual private server, running MSDE and I'm being driven completely and utterly mad by it.

I can copy all the content to the new server, and have it working fine provided I point it back at the shared database, but all attempts at migrating from the 2005 database to MSDE have failed.  I've tried using the backup file (BAK and TRN) but these are incompatible with MSDE 2000. 

I've tried a remote export and local import, but this seems to generate enough errors that the 'final' version just shows as 'unavailable'.  The SQL files generated were huge and I had to break them down into smaller files to allow the import to work without memory issues, but even then, there are PK problems and other assorted errors which are breaking it.

I've tried one of the 'third party' modules designed for backing up and restoring a non-native database, but it created about 300,000 files and the restore wouldn't work.  The processor/memory usage also caused the host of the shared server to threaten me with eviction.  I also tried the same module running on the new server, but with the same result.

All of this I've been trying to do without disrupting a live site (non-commercial).  The database is only round 140Mb in size, so I would hate to imagine the effort involved with some of the multi-gigabyte databases I've seen.

Any ideas/recommendations/solutions or even suggestions of DNN gurus who offer these kind of services would be greatly received, before I lose what little sanity I have remaining.

Ben www.qpr.org