1. Generate a database script for version 2000
Open Object Explorer (2005 Manger Studio, no press F8), connect to your instance
Right-click the library to go to 2000
Task
Generate script
In the Script wizard, in select a database, make sure that you select the library to go to 2000
Tick "Scripting all objects in the selected database"
In the next select script options, locate the script for Server version entry and select SQL Server 2000
Other options set as needed
Finally, save the script to a. SQL script file
2. Create the target database in 2000
In Query Analyzer (or 2005, Manger Studio opens the script file), connect to SQL Server 2000 and execute the script generated above. To create a new database
3. Data from 2005 to 2000
Open Object Explorer (2005 Manger Studio, no press F8), connect to your instance
Right-click the library to go to 2000
Task
Exporting data
In the Select data source step of the SQL Server Import and Export Wizard, determine which database you are selecting to export
In the Select target step, connect to 2000, and select the library that you created in step 2
In Select source table and Source view, select all tables
Final completion
SQLServer2005 Database Data Conversion SQLServer2000 method steps
