Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • wolulcmit 357 posts 693 karma points
    Oct 19, 2010 @ 14:57
    wolulcmit
    0

    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

     

  • jaygreasley 416 posts 403 karma points
    Oct 19, 2010 @ 16:42
    jaygreasley
    1

    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

  • Rich Green 2246 posts 4008 karma points
    Oct 19, 2010 @ 16:48
    Rich Green
    1

    Hey Tim,

    Maybe you could script your SQL CE database and data and then create a clean SQL 2008 db with the script?

    Rich

     

  • wolulcmit 357 posts 693 karma points
    Oct 19, 2010 @ 18:46
    wolulcmit
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft