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.

Advertisements

Written by Sandip

October 25, 2008 at 1:01 pm

Posted in MS SQL

Tagged with