Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,991 of 19,505    |
|    rja.carnegie@gmail.com to Erland Sommarskog    |
|    Re: I get errror message when trying to     |
|    09 Feb 14 06:42:50    |
      On Sunday, 9 February 2014 14:21:14 UTC, Erland Sommarskog wrote:       > Tony Johansson (johansson.andersson@telia.com) writes:       > > The database       > > 'C:\USERS\TONY\PROGRAMMERING\ENTITYFRAMEWORKTEST\ENTITYFRAMEWORKTEST\ENTI       > > TYFRAMEWORKTEST\APP_DATA\PERSONDB.MDF' cannot be opened because it is       > > version 661. This server supports version 655 and earlier. A downgrade       > > path is not supported. Could not open new database       >       > The database file is from SQL 2008 R2. You have SQL 2008. You would need       > to install a newer version of SQL Server to use the datbase file.              However, if the objects in the database don't require the       features of SQL Server 2008 R2, then someone could produce       scripts to create the same objects in an earlier version       database.              Tools such as "SQL Compare" and "SQL Data Compare" can copy       objects between two servers - although they're pretty expensive,       and in my unsophisticated experience with them, copying all       the objects in a database isn't straightforward - they are       really designed for finding and reconciling small differences,       and they may sometimes get the dependencies, the order of       creating objects and loading data wrong.              And you can do it without them, but it takes longer. In any       case, it would need to be done with access to a 2008 R2 server       or later. But the output can be in the form of scripts, too,       to use on /your/ system. But unfortunately I can't offer to       do it. (Unless there is really good stuff in this database.)              I think Microsoft documentation says somewhere that restoring       or mounting a database that you got from a stranger can be       quite a bad idea; it could have all sorts of bad things in it -       viruses, malware. Depending on version, SQL Server apparently       invests a lot of trust in any database on the server.              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca