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,
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 :-)
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.
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
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
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
is working on a reply...