Is it ok to run sql server express 2012 with visual studio 2010? I downloaded an open source web app but the db is newer. The message indicates version 655 so I assume 2012 will open it. Does sql server express 2012 have an export to earlier version
function?
I installed sql server express 2012 and I installed MS server management studio 2012. I cannot attach to the file. I get the error mycalendar.mdf cannot be opened because it is version 655. This server supports version 612. Why would management studio
2012 version 11.0.2100.60 give me this error?
I was able to install express 2012. There are 2 choices on the installion center menu, New stand-alone or Upgrade Server. Since I kept using Upgrade server, a newer express was not happening.
True or false, it is ok for me to open any db using Man Stud 2012 on a 2005 server without upgrading the db? The only time a db will be upgraded is if I open a local db with express 2012?
miltonsnider
Member
228 Points
457 Posts
sql server 2012 express
Apr 02, 2012 04:34 PM|LINK
Is it ok to run sql server express 2012 with visual studio 2010? I downloaded an open source web app but the db is newer. The message indicates version 655 so I assume 2012 will open it. Does sql server express 2012 have an export to earlier version function?
regards
Milton
Milton
Ken Tucker
All-Star
16797 Points
2608 Posts
MVP
Re: sql server 2012 express
Apr 02, 2012 04:37 PM|LINK
Yes
It should
No but you can use Visual Studio's data base publishing wizard to create a script which can recreate the database with data.
http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx
Space Coast .Net User Group
miltonsnider
Member
228 Points
457 Posts
Re: sql server 2012 express
Apr 02, 2012 05:33 PM|LINK
I installed sql server express 2012 and I installed MS server management studio 2012. I cannot attach to the file. I get the error mycalendar.mdf cannot be opened because it is version 655. This server supports version 612. Why would management studio 2012 version 11.0.2100.60 give me this error?
Milton
Mandeep Joon
Participant
1570 Points
382 Posts
Re: sql server 2012 express
Apr 03, 2012 06:43 AM|LINK
Hi
Maybe it solves your problem.
http://stackoverflow.com/questions/5193752/db-cannot-be-opened-because-it-is-version-655-this-server-supports-version-612
Mandeep Joon
Blog:- Hightechnology.
miltonsnider
Member
228 Points
457 Posts
Re: sql server 2012 express
Apr 03, 2012 01:09 PM|LINK
I was able to install express 2012. There are 2 choices on the installion center menu, New stand-alone or Upgrade Server. Since I kept using Upgrade server, a newer express was not happening.
True or false, it is ok for me to open any db using Man Stud 2012 on a 2005 server without upgrading the db? The only time a db will be upgraded is if I open a local db with express 2012?
regards
Milton
Milton