Copied to clipboard

Flag this post as spam?

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


  • Ryan Farghil 9 posts 29 karma points
    May 28, 2011 @ 02:05
    Ryan Farghil
    0

    How can we migrate the Umbraco database to production?

    We have Umbraco 4.x running on localhost, using SQL Server CE (SDF files).  This is recommended by the installer.  But now we wish to test out the deployment to a shared hosting environment, and are faced with the problem of copying (or migrating) the SQL Server CE database up to a SQL Server 2008 database.

    To broaden this problem a bit: how do we create a blank, schema-correct, ready-to-use instance of a complete Umbraco database in SQL Server 2008 in a shared hosting environment?

    WebMatrix is great at publishing the application, but is only able to copy the SDF file (from SQL Server CE) up to the destination web folder, which unfortunately is not much use as shared hosting environments (eg WinHost) do not run CE.  Nor should they.

    Umbraco looks like a great product but we are having a terrifically hard time tripping over quite basic issues like this one.  Anybody got any insight?  All advice appreciated, cheers,

    -Ryan

  • Lesley 284 posts 143 karma points
    May 28, 2011 @ 23:36
    Lesley
    0

    Hi Ryan,

    You should be able to use Web Matrix to migrate the database to SQL Server. Instructions: http://www.microsoft.com/web/post/migrate-a-database-to-sql-server

    It seems like you need SQL Server [or Express] installed on the same machine as Web Matrix/SQLCE to do the migration. Then you can do a backup from SQL Server, copy that file to your hosting environment and restore the database there.

    A few painful steps (especially if you don't already have SQL Server installed), so let us know how you get on :-)

    Lesley

  • Ryan Farghil 9 posts 29 karma points
    May 31, 2011 @ 20:01
    Ryan Farghil
    0

    Thank you Lesley for your advice.  We got it running, thanks to you.  I wish the installer didn't "recommend" using SQL CE for beginners, that is what threw us off.

    Cheers,
    -R

Please Sign in or register to post replies

Write your reply to:

Draft