Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hi All,
I am using vs2010,vb.net 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 .........
 
Regards
Mukesh
Posted 10-May-13 21:37pm

1 solution

Rate this: bad
good
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!
  Permalink  
Comments
Zoltán Zörgő at 11-May-13 5:39am
   
Using a virtual machine for such a one-time task might be a good solution.
OriginalGriff at 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
0 Marcin Kozub 330
1 OriginalGriff 256
2 Sergey Alexandrovich Kryukov 215
3 Praneet Nadkar 197
4 Richard MacCutchan 182
0 OriginalGriff 8,048
1 Sergey Alexandrovich Kryukov 7,287
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,910


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 11 May 2013
Copyright © CodeProject, 1999-2014
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