Tuesday, March 27, 2012

Export database from SQL server 2005 to 2000

Hi

I need to transfer schema and data from SQL server 2005 to SQL server 2000. Backup had been perfect, but a backupfile made by SQL server 2005 can't be read in SQL server 2000. I seach for a solution but I did not found any.

Is there someone that have a solution?

Hi,

either make an import from the 2k server or an export from the 2k5 server via DTS Assistent. Another but more complicated way would be to create scripts of your database objects and data and execute them on the 2k system. But prior to that you have to make sure that they are compatible with the 2k system.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
sql

No comments:

Post a Comment