Exporting SQL 2008 to earlier version

Posted: 25th January 2010 in SQL

To allow an earlier version of SQL Server to recognise the data from 2008 it is necessary set the database compatibility level to the correct version.

Transact-SQL Method
ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 }

eg. to use in 2005 run

ALTER DATABASE my_db SET COMPATIBILITY_LEVEL = 90

The versions are as follows:

80 : 2000
90 : 2005
100: 2008

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