Restore a SQL 2005 database into a SQL 2000

[yordangs]

How can i restore a database build in sql 2005 into a Sql 2000 the problem is i can´t do it using the wizard or a DTS in mysql exists a command DUMP tha you can restore a data base between a new version and an older version exists something similar in SQl 2005 ?

 

[mrdenny]

You can't restore a SQL 2005 backup to a SQL 2000 server.

You would have to script out the objects (Tables, procedures, etc) and create them on the SQL 2000 server. Then use DTS/SSIS/BCP to export the data and import it into the SQL 2000 server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog