Sandip's Programming Zen

An attempt to share tech/coding experiences

Archive for October 2008

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.

Written by Sandip

October 25, 2008 at 1:01 pm

Posted in MS SQL

Tagged with