What update i need to install for version 655 in vs studio 2010 for the sql server. SQL server version 655. Cannot restore backup on SQL Server Express.

• Sql Express Version 661

I have SQL Server 2008 and VS2008 installed on my computer and I am trying to run a web application I've created on a computer which has SQL Server 2008 and VS2008 and VS2010 beta 2 with its SQL Server Express. I am getting an error with the database version that is '.aspnetdb.mdf' cannot be opened because it is version 655. This server supports version 612 and earlier.' Configuring the database in Visual Studio -Tools - Options - Design-Time Validation Database is not working since I don't have the SQL Server version comes with VS 2010.

EDITED: I also edited aspnetdb and inserted a few more tables so I need the same aspnetdb Is there any solution to convert this db? Also, after fixing this, I am looking forward to upload it on my hosting which has SQL Server 2005 DB and configure it in PLESK. The SQL Server databases have a version specific format. Each SQL Server runtime version (SQL 2008 SP1, SQL 2008 RTM, SQL 2005 SP2, SQL 2005 SP1, SQL 2005 RTM etc) knows how to upgrade to its own verison. Unfortunately, once upgraded the database cannot be downgraded. So if your MDF was upgraded to version 655, it cannot be downgraded to any prior version.

If you know you're going to deploy on SQL Server 2005, you must develop on SQL Server 2005 too. Not only that, but the actual build number of your development has to match the build number of the deployment (or at least be lower than that): the SP level and CU level must match.

You can a attach the 2008 version MDF you created to a SQL Server 2008, script out the database content, then import the script into a SQL Server 2005 database of the proper version.

Sql Express Version 661

Hi i have a error like ' dbFileName cannot be opened because it is version 655. This server supports version 612 and earlier. ' what should i do? Some friend of mine done a project but i guess he done it with sql 2008 and i have sql 2005 is that the reason why i got this error? Can i fix it?

If i setup a newer version of sql does it will solve the problem? Www.microsoft.com/express/Database/default.aspx#InstallationOptions here sql server 2008 R2 express is available can it be the solution? By the way i found a link of an update is this a solution to my problem? The VS update in the link is not a solution to your problem. You'll need that update though if you want to use VS to work with a SQL Server 2008 project.

And you will have to work with SQL Server 2008 if you want to use your friend's database. To solve your problem you'll need to upgrade to SQL Server 2008. Express edition is fine, as long as the database is less than 4Gb in size.

Note that if you continue to work on this database, you won't be bale to deploy your solution to a hosting that is based on SQL 2005, since they won't be able to use your database. But the real problem you face here is the fact that you treat MDF files as source.

You should develop exclusively using T-SQL scripts to deploy your database, and then you won't have any of these problems. You can use a, or you can use a Visual Studio Database Edition project and deploy using vsdbcmd.exe and.dbschema files. Any of this solutions will be way ahead of actually checking in MDF files, exchanging MDFs between team members or copying MDFs at deployment time.