Can somebody tell me, it is possible to convert a database developed in sql2005 back to sql2000?
I am desperatly trying to do so, but...
please help...
Create a blank database in 2000 use 2000 DTS to get your tables and objects from 2005. Hope this helps.
|||Here is a solution, please follow these steps.
1. Create a blank database in SQL Server 2000.
2. In SQL 2005 Management Console Studio , from Database -> tasks -> Generate Script -> select Database ->Script for Server Version -> Change it from SQL Server 2005 to SQL Server 2000
3. Do the process as per wizard.
4. We can run that Script into SQL Query Analyzer 2000 for that selected database where you want to move it.
You should be able to get whole database table creation and whole relationship which was made into SQL Server 2005.
If you have data, use bcp utilities to export and import.
Please check this thread for detail.
No comments:
Post a Comment