CODEWITHSUNDEEP
.netsql-serversql-server-2005sql-server-2008
Nirmal
Nirmal

Reputation: 4829

Restore Database from SQL Server 2008 to SQL Server 2005

I have created a set of tables (around 20) in SQL Server 2008 and entered around 1000 records to appropriate tables.

But the issue is that I want that same tables with all the entered data into SQL Server 2005 (SQLEXPRESS).

Obviously it won't work by taking a backup and restore it into SQL Server 2005 as it won't support backward compatibility.

Any suggestion would be appreciated....

Upvotes: 2

Views: 352

Answers (1)

Dan Diplo
Dan Diplo

Reputation: 25339

If you've got Management Studio (including Express version) then you can export data from it (and target an SQL Server version). Try this:

  1. Right-click the database you wish to export and select Tasks > Generate Scripts

  2. Follow the wizard prompts and tick 'Export all objects'

  3. In the 'Script Options' dialogue look through all the options and change 'Script for Server Version' to 'SQL Server 2005' and also change 'Script Data' option to 'True' (this exports the DB content as well as the schema).

You can then save the export as an SQL script in a text-file that can then be run against the database you wish to import it into.

Upvotes: 2

Related Questions