CODEWITHSUNDEEP
sql-serversql-server-2008
Zakir Hossain
Zakir Hossain

Reputation: 444

How to restore a SQL Server 7.0 .bak file to SQL Server 2008 Express?

I have a .bak file from SQL Server 7.0 and I want to restore this old .bak file to SQL Server 2008 Express. So what should I do?

Upvotes: 2

Views: 488

Answers (1)

Andrea
Andrea

Reputation: 12375

According to Technet (see full article here) you have three options:

  1. Upgrade your SQL Server 7.0 database by attaching/restoring the database to an instance running SQL Server 2000 or SQL Server 2005, backup your database in SQL Server 2000 or 2005 format and then restore it in SQL Server 2008.
  2. Use the SQL Server Import and Export Wizard to copy data between multiple instances of SQL Server.
  3. Migrate data from a database that was created in SQL Server 7.0 using bcp utility (version 7.0 of bcp to export from SQL Server 7.0 and version 10.50 of bcp to import in SQL Serevr 2008).

The first option is probably the easiest and safest.

Upvotes: 1

Related Questions