Coping SQL Database to MSDE

[ishfady]

Hi

I am new to SQL and MSDE database knowledge.

I have build my test database in SQL server 2000.
It is working fine. It is running on Window XP Pro.

Now I want to copy this database to another pc, which is running MSDE. This ps is also running Window XP Pro.

Please could you help me , how do I go about.


Many thank

 

[hmckillop]

You can backup on one database and then script the restore on the MSDE version.

i.e. on 1st db

BACKUP DATABASE [MyDatabase] TO  DISK = N'X:\MyDatabase_backup.bak' WITH  INIT ,  NOUNLOAD ,  NAME = N'MyDatabase backup',  NOSKIP ,  STATS = 10,  NOFORMAT

On MSDE DB copy over backup file to your drive on MSDE machine and then execute something similiar to :

RESTORE DATABASE [MyDatabase] FROM  DISK = N'X:\MyDatabase_backup.bak' WITH  FILE = 1,  NOUNLOAD ,  STATS = 10,  RECOVERY

You will need to amend some options but it should point you in the right direction

"I'm living so far beyond my income that we may almost be said to be living apart