Import SQL2000 data to sql7

Converting 2000 to 7.0 will lose some unsupported attributes. It is best to use the following method:

1.
Sql200 Enterprise Manager -- Right-click the database to be exported to 7.0 -- all tasks -- generate SQL script -- select generate all object scripts in general -- set format, choose "include extended attributes" and "write scripts only for 7.0 compatibility" -- option, select all content in "Write database script" and "Table script options" -- keep all other options by default -- then confirm and save it as one. SQL File

2.
Connect to sql7.0 in the query analyzer and execute the script generated above to create a new database (Note: The generated script may need to change the database path)

3.
Sql200 Enterprise Manager -- Right-click the database to export 7.0 -- all tasks -- export data -- target database, select sql7.0 server on the server, select the database generated above -- select "Copy Data and object between two SQL databases" -- cancel the selection of "create target object" -- Final Completion

Or:

In the 2000 environment, the database structure is exported as an SQL script, data is converted to access through DTS, and then the database is regenerated using the SQL script, then, convert access to SQL Server 7.0 through DTs.