Sandip's Programming Zen

An attempt to share tech/coding experiences

Moving DB From SQL Server 2008 to SQL Server 2005

with 2 comments

I have upgraded by SQL Server Express addition from 2005 to 2008, no problem everything runs smoothly.

Now I have to copy the database on user’s machine who uses SQL server 2005, Oops it does not work, gives following error.

The database ‘C:\DOCUMENTS AND SETTINGS\ADMINISTRATOR\MY DOCUMENTS\####\#########\############\DATA\######.MDF’ cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.

I have anticipated some problem and thus changed the compatibility of the database to SQL Server 2005 so hoped it will work fine, but No it does not. 

So far I have not found any solution to this problem so I just generated SQL Script for all the objects and ran it on the target server as well as data imported using ms excel.

Advertisements

Written by Sandip

October 25, 2008 at 1:01 pm

Posted in MS SQL

Tagged with

2 Responses

Subscribe to comments with RSS.

  1. I have the same problem, no answer found.

    Alex

    December 15, 2009 at 3:53 pm

  2. You can script out the schema fairly easily using the built in generate scripts functionality.

    You can also then script the content, and run this on other versions of sql server to migrate data. There’s a tool here for doing just that:

    http://sqlharvester.codeplex.com

    Mike

    May 18, 2010 at 7:28 pm


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: