Migrate database to a lower version

It is not supported to downgrade a Microsoft SQL Server by using the detach/attach or backup methods. However, it it possible to script data from the upgraded database and then import it into a new database in the lower version of SQL Server. A good description of this can be found on the following page:
http://www.mssqltips.com/sqlservertip/2810/how-to-migrate-a-sql-server-database-to-a-lower-version/

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s