home bbs files messages ]

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