Click here to Skip to main content
13,148,427 members (60,433 online)
Rate this:
Please Sign up or sign in to vote.
Hi All,
I am using vs2010, and sql server 2008 R2 with window form application.

i have generated db from sql server 2005 script in our sql server 2008 R2 db.

i have created setup and attachdbfile in our bebug path. my setup is working successfully
in local pc. setup isn't woking in other pc.

after installed setup, i am getting this type of error that's mention below.

the database .mdf cannot be opened because it is verison 655. this server support version 612 and earlier. A downgrade path is not supported.
A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

how to run setup successfully in other pc.

help will be appreciated .........

Posted 10-May-13 20:37pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

It's quite simple to explain, but you may have more problems fixing it...
Version 655 files are created by SQL server 2008, but the server supports only up to version 612, which is SQL 2005.

You cannot open SQL 2008 (or SQL 2008 R2) files in earlier versions of SQL server. You must develop your software using the same or earlier version of SQL that you intend to deploy to.

In practice, they best thing you can probably do is install a separate SQL 2005 Express edition for development and copy the data between the 2008 and 2005 versions using software. I would STRONGLY recommend that this is not installed on your development PC - I have have had Visual Studio installations completely bolloxed by SQL server installations, particularly downgrades. Use a different, spare machine or backup the whole PC first!
Zoltán Zörgő 11-May-13 5:39am
Using a virtual machine for such a one-time task might be a good solution.
OriginalGriff 11-May-13 5:44am
Yes - good idea. (I'm just old fashioned and like reformatting windows...:laugh: )

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170924.2 | Last Updated 11 May 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100