Copying Databases from Earlier Versions

It is not possible to restore a database backup created using Microsoft® SQL Server™ version 6.5 or earlier. Database backups created using SQL Server 6.5 or earlier are in a format incompatible with SQL Server 7.0. To convert a database created using SQL Server 6.5 or earlier to SQL Server 7.0, you can:

• Upgrade SQL Server to 7.0.

  Any databases are upgraded automatically. New backups from the upgraded computer running SQL Server can now be restored into another computer running SQL Server 7.0.

• Use the Data Transformation Services Import and Export wizards to copy data from one computer running SQL Server directly to another.
• Use the bcp utility to copy data from a computer running SQL Server 6.5 or earlier to a data file, and then copy the data from the data file into a computer running SQL Server 7.0.

See Also