RSS

How to convert database from SQL Server 2008 R2 to an earlier version ??

01 Aug

If you are trying to restore database backup of SQL Server 2008 R2 to SQL Server 2008 or 2005, you are bound to fail. Database backup of SQL Server 2008 R2 is not compatible backward, you cannot restore it to SQL Server 2008. The following is a solution to convert databases of SQL Server 2008 R2 to 2008.

 

(2) Click ‘Next’.

(3) Choose objects that you want to script, then click ‘Next’.

(4) Click ‘Advanced’ and set the (Script for Server Version) property to the version that you want as it shown in figure number 5. Then click ‘Next’ to get the script

(5) Set options.

Now you got a complete database creation script with data. It can be executed on target database server.

 
Leave a comment

Posted by on August 1, 2012 in MS SQL Server

 

Tags: , , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: