Sandip's Programming Zen

An attempt to share tech/coding experiences

Posts Tagged ‘SQL Server

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

Interesting SQL Server stuff

leave a comment »

1. This article explains how to track SQL Server 2005 deadlocks using Profiler tool.

2. An open source project at coldeplex to compare two SQL Server 2005 databases.

Written by Sandip

June 30, 2008 at 5:41 am

Posted in MS SQL

Tagged with