Downgrade mdf file from 661 to 655

c#-4.0 entity-framework sql-server-2008

Question

I created and database in sql server 2008. I took the mdf and ldf files to Visual Studio 2010 project and tried to connect to that db with entity-framework. and got the following message:

enter image description here

I cannot reinstall or upgrade the software on the specific computer. So is there any way to downgrade the version of the mdf and ldf files?

1
2
8/4/2012 5:07:03 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

No, you cannot downgrade, you will need to move the schema and data another way if you can't install the right version. This recent question is essentially the same:

Failure attaching SQL Server 2008 database to SQL Server 2005

Essentially you can use the Generate Scripts tool or the Export Data wizard to get your destination database to look like the source. You will not be able attach your MDF file.

And this blog post shows some 3rd party tools that can help with this:

http://bertrandaaron.wordpress.com/2012/04/20/re-blog-the-cost-of-reinventing-the-wheel/

2
5/23/2017 12:01:18 PM

Popular Answer

No, you need to install the same or newer version of SqlServer.
There is no known way to downgrade an MDF file.

Links

http://blog.sqlauthority.com/2008/10/16/sql-server-downgrade-database-to-previous-version/

Perhaps, if you have access to the SqlServer 2008, you could use the command "Tasks" -> "Create Scripts" to start the wizard to create a script with schema and data.
On the options page there is the button 'Advanced' where you can select the syntax version of SqlServer

Steve

Related Questions

Multiple edmx files vs a single huge edmx file?

I'm going to go against the grain here. I've built 2 large applications with EF now, one with a single edmx and one with several. There are pros and cons but generally I found life to be much easier with one edmx. The reason is that there is almost never a real separation of domains within an app, even if there appears to be from the start. New req...
ado.net-entity-data-model entity-framework
asked by Mindstorm Interactive

Delete .mdf file from app_data causes exception cannot attach the file as database

That what fixed it for me, From Package Manager Console run these commands:... sqllocaldb.exe stop v11.0 sqllocaldb.exe delete v11.0 ...And then:... Update-Database
asp.net-mvc ef-code-first entity-framework
asked by Gleb Esman

Cannot attach the file *.mdf as database

I think that for SQL Server Local Db you shouldn't use the ...Initial Catalog... property. I suggest to use:...<add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\OdeToFoodDb.mdf" providerName="System.Data.SqlClient" /> ...I think that local db doesn't sup...
.net asp.net-mvc asp.net-mvc-4 database entity-framework
asked by Davide Icardi

How to downgrade Entity framework from 6 to 5?

Entity Framework also moves the ...__MigrationHistory... table from System Tables to user tables. When I tried to run my application after rollback it wouldn't work, so I had to move the ...__MigrationHistory... back to the system tables with:...EXEC sys.sp_MS_marksystemobject __MigrationHistory; ...When I did upgrade to EntityFramework 6 I had to ...
.net entity-framework
asked by Default

Could not load file or assembly 'EntityFramework' after downgrading from 4.5 to 4.0 with EF5

Use Nuget to uninstall EF then add it again, Clean and rebuild your project.
.net asp.net entity-framework
asked by Juano

.mdf" failed with the operating system error 2(The system cannot find the file specified.)

Your application is missing the ...App_Data... folder. Right click on your project, select ...Add..., then ...Add ASP.Net Folder... and choose the ...App_Data... folder....This ensures the correct folder exists for your application.
asp.net c# database entity-framework sql
asked by DavidG

Entity Framework on .mdf file

When your doing code first development in EF, you can force EF to only ever consider one connection string name....One of the constructors (of which there are quite a few overloads) on the EF Data Context parent classes, takes a simple string....This string is given to be the name of a connection string in the App or Web config to use....You make t...
c# entity-framework sql-server
asked by shawty

Cannot find .mdf file in App_data

Just if someone is still facing the problem, Run visual studio in ...debug... mode and register a user and the mdf will be created in App_data.
asp.net-mvc asp.net-mvc-5 c# entity-framework-6
asked by mtareq

Prevent update of MDF file when attaching to newer version of LocalDb

No - you ...CANNOT... prevent or exclude the ....mdf... from being upgraded to the current internal database version when attaching to a newer server instance....You need to ...either... use the same version of SQL Server (Express / LocalDB) on all machines involved in the development - or you need to upgrade your existing database structure (and p...
c# entity-framework-6 localdb sql-server winforms
asked by marc_s

Can't access sql mdf file during google sync

You don't want to access the MDF (or the log) files while the database is attached to a running SQL server instance. You should make a real SQL server backup to another folder, which you can sync to google drive. That way you can also use backup compression, which most likely will mean you have to transfer less data over the internet.
ado.net c# entity-framework-6 sql-server
asked by Cedersved

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow