Mutual import of SQL Server 2005 and SQL Server 2000 data

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.