Move SQL Server 2008 R2 back to SQL Server 2005 – Generate Scripts then Import Data

Start with SQL 2005 server > Create database >
SQL 2008 server > Generate Scripts > Choose Advanced options > Script to SQL 2005 > Options of Script Schema and Data, Schema, Data > Generate
Go to SQL 2005 database > Import Data > Import from 2008 database

A useful function to consider is

SQl Server 2005 SP3 will go upto  611 where as you are retiring a SQL 2008 db which is version 655.
Do your self a favour before migrating DBs’ between different versions do a [select * from sysdatabases] and check the column VERSION. Most of us believe CMPTLEVEL if 90 will go good for version 9.0 but its the database internal version that matters.

Advertisements

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: