Six data mobile methods for SQL Server 7.0 databases are transferred from: Century Easy Network March 3, 2003 20:6
My work is the database administrator, to maintain the database in multiple servers, often move a database in a server to another server, some experience of the data, I hope to communicate with you. 1. Import or export the designer of the tool DTS to import or export the DTS designer function, support multitasking, is also a visual interface, easy to operate, but knowing people generally, if only the part of the SQL Server database, It is best to use this method, of course, can also be moved. In SQL Server Enterprise Manager, expand the on the left side of the server, select the database, right click, select All Tasks / Import Data ... (or all tasks / export data ...), enter the wizard mode, follow the prompt step by step It is very convenient to replicate data between different data sources, it is very convenient. Moreover, it can be other than DTS packets, and if there is the same copy task in the future, the DTS package is run directly, saving time and effort. You can also open the DTS designer directly, the method is to expand the Data Transformation Services below the server name, select Local Packages, right click on the window, select New Package, open the DTS designer. It is worth noting that if the source database is to be copied, the order of movement, pay attention to the order of movement, sometimes moving batch, otherwise the key key key, the index may be lost, the prompt next to the option is very clear, or once Sexual copying to the target database, re-establish the foreign key, primary key, index. When it is actually established a database, the files that have been established, the primary key, and the index should be separated from the construction form file, and the data files are also separated and placed on different drives, which facilitates the optimization of the database. 2. Using BCP Tools Although not recommended in SQL Server7 versions, many database administrators still like to use it, especially those who have used SQL Server. BCP has limitations. First, its interface is not graphical, followed by copying between SQL Server's table (view) and text files, but its advantages are good performance, small overhead, less memory, less memory, speed fast . Interested friends can check the reference manual. 3. Use backup and recovery to complete the source database, back up to a device (Device), then copy the backup file to the destination server (fast speed), perform the recovery operation of the database, in the recovered database name The name of the origin database (the name must be the same), select Mandatory Recovery (option to overwrite the previous database option), select the backup file when selecting the recovery from the device. This method can completely restore the database, including foreign keys, primary keys, indexes.