There really is no wizard or documented procedure from Microsoft regarding this issue. Also, there isn't a simple way of backing up in SQL 2005 and restoring in SQL 2000. Actually, you can't; because there is no backward compatibility between the two versions. You can backup in SQL 2000 and restore in SQL 2005 but not the other way around.
Is this a case of Microsoft forcing you to upgrade or are the two DB versions structurely too different and complex to have backward compatibility? You can decide for yourself.
In the meantime, someone posted the procedure here on a Microsoft forum.
Basically, there are 3 simple steps:
Step 1 - Generate Scripts for the Database Elements and Structures (excluding FK and triggers)
Step 2 - Move the data from 2005 to 2000 using the export wizard in 2005
Step 3 - Generate Scripts for the Database Foreign Keys and Triggers
This works fine if you have a small database on the same network. But if your database is bigger and you have to export across your network, then having a backup file to restore from would be a much easier task. Those steps would be:
1. Backup your database
2. Compress the db file
3. FTP to your target server
4. Restore on target server
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment