Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Iphelion 3 posts 23 karma points
    Jul 12, 2011 @ 18:03
    Iphelion
    0

    SQL CE4 to SQL 2008 conversion

    HI All,

    I have created a site locally using the SQL CE 4 engine on Umbraco 4.7 under the advice that the hosting company would support this 100%.   Having got to the point where I need to upload the site the hosting company have found some issues with their SQL CE4 support and removed it.   They do however have support for a single SQL 2008 database and so my question is:-

    How do I convert a populated Umbraco  SQL CE4 SDF file to a proper SQL server database?   Ive tried WebMatrix but that throws an exception.  

    I know that the engines are vastly different but the tables/columns must be somewhat similar.  

    Has anyone done this?  Are there any tools out there to help?

    Thanks
    Andy

     

    Copy Link
  • Richard Soeteman 4049 posts 12922 karma points MVP 2x
    Jul 12, 2011 @ 22:20
    Richard Soeteman
    0

    Hi Andy,

    Might be worth to try the suggestions in this thread on StackOverlow.

    Cheers,

    Richard

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft