2005_to.doc

2005_to_2000Step 1: Generating Scripts for the Database Elements and Structures Go to SQL2005 Server Open SQL Server Management Studio Tasks>Generate Scripts>Next Select DB> Script all objects in the selected database>Next Script Collation , set to TRUE Script Database Create, set to TRUE Script of SQL Version, set to SQL SERVER 2000 Script foreign keys, set to FALSE Script Triggers, set to FALSE Then Hit the Next button Script to file>Browse>Input file name>Next Finish ess>Close Go to SQL2000 Server>Open QA>connect to 2000 db instance Open the sql file just generated>Edit the db data and log file path>execute using master db pletely running it,a db will be created Step 2: Moving the data from 2005 to 2000 Go back SQL2005 Server>Tasks>Export Data Select Source DB (2005server)>Next Select Destination DB (2000server) >Next Copy Data from one or more tables or views>Next Select All tables but not select all views>Next Execute immediately>Next Finish ess>Close