Q
Problem solve Get help with specific problems with your technologies, process and projects.

SQL Server 7.0 database creation using DTS or BCP

How to create a SQL Server 7.0 database using DTS or BCP is discussed by expert Greg Robidoux discusses converting .BAK files.

I currently use SQL Server 2000 but my client uses SQL Server 7.0. We need to give them a database that SQL Server 7 can restore onto its system. Can we do this? Is there any way we can convert the .BAK file?
You can not restore a SQL 2000 database back to a SQL 7.0 format.

The only way to create a SQL 7.0 database would be to recreate all of the database objects on a SQL 7.0 server and then import all of the data. This can be done using DTS or BCP.


Do you have comments on this Ask the Expert Q&A? Let us know.

Dig Deeper on SQL Server Backup and Recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close