sqlserver2000 Exporting scripts and exporting data

1. Click Show All in the general, tick edit all objects script

2. Set the format in addition to the penultimate (7.0 compatible) third-to-last (descriptive title) two options all check out

3. Options in the Security Script option is unchecked, the table script options are all checked, the file format is internationalized text, generate files for each object to create a file

The generated text files are managed with a repository, which enables simple management of the database structure, but does nothing to the data.

1. Select the database, right-click All Tasks, export the data, select the destination database by selecting the new database named Db_test,

2. Select to copy objects and data between SQL Server databases in the specified table copy or query

3. Include extended attributes in the selection of objects to be copied

4. Click "Next" to complete the data copy work

sqlserver2000 Exporting scripts and exporting data