Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1660

Re: I get errror message when trying to use mdf database downloaded from the net

Show all headers | View raw

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.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

I get errror message when trying to use mdf database downloaded from the net "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-09 13:33 +0100
  Re: I get errror message when trying to use mdf database downloaded from the net Erland Sommarskog <esquel@sommarskog.se> - 2014-02-09 15:21 +0100
    Re: I get errror message when trying to use mdf database downloaded from the net rja.carnegie@gmail.com - 2014-02-09 06:42 -0800
    Re: I get errror message when trying to use mdf database downloaded from the net "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-09 15:54 +0100
      Re: I get errror message when trying to use mdf database downloaded from the net Erland Sommarskog <esquel@sommarskog.se> - 2014-02-09 18:31 +0100
        Re: I get errror message when trying to use mdf database downloaded from the net "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-10 23:18 +0100
          Re: I get errror message when trying to use mdf database downloaded from the net Erland Sommarskog <esquel@sommarskog.se> - 2014-02-10 23:38 +0100
    Re: I get errror message when trying to use mdf database downloaded from the net "Tony Johansson" <johansson.andersson@telia.com> - 2014-02-09 16:42 +0100

csiph-web