Connecting to an SQL CE Umbraco Database with Server management studio
I'm in the situation where I may need to go back to using a full blown sql 2008 database for a project I'm working on, trouble is I've already started and am knee deep half way with SQL CE.
I thought no problem I'll just connect to my Umbraco.sdf instance through Server management studio, take a backup and then restore to a new non SQL CE database (don't know if this is even possible but thought I'd give it a try)
trouble is, I can connect to SQL CE databases that I've created through Server management studio, but when I try to connect to the one that Umbraco Generated I get the following error: "This is not a valid SQL Server Compact Database file or this file version is not supported by current SQL Server Compact Engine" am using SQL Server2008 R2
installed the standalone version and was able to export to an sql file and then ran the query on my new database and it seems to have worked without a hitch. Hope this helps someone else in my situation!
Connecting to an SQL CE Umbraco Database with Server management studio
I'm in the situation where I may need to go back to using a full blown sql 2008 database for a project I'm working on, trouble is I've already started and am knee deep half way with SQL CE.
I thought no problem I'll just connect to my Umbraco.sdf instance through Server management studio, take a backup and then restore to a new non SQL CE database (don't know if this is even possible but thought I'd give it a try)
trouble is, I can connect to SQL CE databases that I've created through Server management studio, but when I try to connect to the one that Umbraco Generated I get the following error:
"This is not a valid SQL Server Compact Database file or this file version is not supported by current SQL Server Compact Engine"
am using SQL Server2008 R2
any ideas?
- Tim
Hey,
This is a bit old but may be useful.
It looks like VS will be able to access a CE file and there will be tools to help you upgrade to full SQL Server.
http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx
more as I find it
Jay
Hey Tim,
Maybe you could script your SQL CE database and data and then create a clean SQL 2008 db with the script?
Rich
Thanks for your help guys.
I did a bit of digging and found this tool http://sqlcetoolbox.codeplex.com/releases/view/50225
installed the standalone version and was able to export to an sql file and then ran the query on my new database and it seems to have worked without a hitch.
Hope this helps someone else in my situation!
- Tim
is working on a reply...