Mutual import of SQL Server 2005 and SQL Server 2000 data

1 SQL Server 2000 data import SQL Server 2005

In SQL Server 2000, backup the data, right-click in the database, select "Backup Database" under "All Tasks", pop up a dialog box, then click the "Add" button and enter the corresponding database backup name, you can back up the data. Then in SQL Server 2005, right-click in the database, click "Restore Database", in the pop-up dialog box, "General" tab, "target Database", after the name of the database, in the specified backup set for the restore of the source and location, select "Source Device", In the following folder button, click to select the database that we backed up in SQL Server 2000, and then select the previous selection box to modify the corresponding path in the Options tab so that the corresponding data can be recovered in SQL Server 2005. In this kind of data import process, actually does not consider the SQL Server version the question, it and each version data's mutual import does not have the difference, is the interface display difference.

2 SQL Server 2005 data import in SQL Server 2000

In SQL Server 2005, right-click in the corresponding database and select "Generate Script" under the "Task" menu, click Two consecutive "Next", then in the pop-up dialog box, in the box below "options" to find "script for server version", put the following SQL Server2005 modified to SQL Server 2000, then click Next to select the table, if there is a stored procedure, you also need to select the stored procedure, then click Next, select the stored procedure or table, and then click "Next", and then click "Finish", All the SQL statements are then generated in the newly created Query window, which we copy and then execute in the Query Analyzer of the corresponding database in SQL Server 2000, generating the corresponding table structure and stored procedures. Then we'll use SQL Server 2000 to right-click in the database, import data for all tasks, enter the name or IP address of the server in SQL Server 2005, and then enter SQL Server 2000 the name or IP address of the server, then the default choice to go to "next", select all the tables, and then click on two "Next", the data can lead in.