take the complete backup of database, creat a new database on the new system with same name, and select restore database ,select the backup file for restoring. you will have to take care for the paths of the mdf and ldf file (will need to change it manually for the current backup file path). also check the "force restore" check box. I think its the right name for the check box as I don't have sql server on my system now.
your database will be moved fully and in very quick time.
Usman
|||Thank You for the quick repsonse but i do have some more questions.
1. Will the stored procedures move correctly? especially going from 7 to 2000?
2. Also, when the DB is restored will it upgrade the DB and the stored Procedures
3. Is there an issue with the files being on differnt drives/directories?
|||2000 should detect that the mdf and ldf belong to older version of MSSQL and will ask if you want to convert to newer version code.
BEAWARE******But there are chances that you might see some change in functionality******
No comments:
Post a Comment