Migration from SQL 2005 to 2000

I am looking to export an SQL Server 2005 database to an SQL generate script (ie CREATE TABLE [xxx]; INSERT INTO [xxx]; etc.) instead of the binary backups.

Reason is I need to go from a 2005 sql server to 2000 sql server, an I have a good feeling you can't use a backup from 2005 in 2000.

The 'Generate Scripts' tool in SQL Server Management Studio Express will generate the create table statements, but I need the INSERT statements aswell.

If you could show me how to do this, it would be greatly appreciated.



Thanks,
Matthew

 

You can export directly to your SQL 2000 server.

In SQL Management Studio, right click on your database >> Tasks >> Export Data

Set your SQL 2005 database as the source and your SQL 2000 database as the destination. Then select the objects you wish to export.

Aristotle

DiscountASP.NET
www.DiscountASP.NET