Umbraco Utility Package to convert SQL CE to SQL Server Express?
That would be super useful for me. Typcially I develop on my local machine then copy up to the live server.
Right now I use SQL Express 2008 on my local machine then backup the database, RDP to the server, create and restore, etc...
What would be awesome is if there was a dashboard that would let use SQL CE in locally, then after uploading, convert to SQL Server 2008 from the Umbraco backend, not have to go through the whole backup/restore thing.
When you think about it, you could then continue to work on your master pages, scripts, stylesheets etc. in Visual Studio and push those changes to the live install where Umbraco would automatically update the (SQL 2008) database as it currently does.
Hi. You can publish your local web site with the Web Deploy tools that include options to migrate a SQL CE database to SQL Express. There's comprehensive documentation to the Web Deploy e.g. on the iis.net site: http://learn.iis.net/page.aspx/346/web-deploy/
Umbraco Utility Package to convert SQL CE to SQL Server Express?
That would be super useful for me. Typcially I develop on my local machine then copy up to the live server.
Right now I use SQL Express 2008 on my local machine then backup the database, RDP to the server, create and restore, etc...
What would be awesome is if there was a dashboard that would let use SQL CE in locally, then after uploading, convert to SQL Server 2008 from the Umbraco backend, not have to go through the whole backup/restore thing.
When you think about it, you could then continue to work on your master pages, scripts, stylesheets etc. in Visual Studio and push those changes to the live install where Umbraco would automatically update the (SQL 2008) database as it currently does.
Hi. You can publish your local web site with the Web Deploy tools that include options to migrate a SQL CE database to SQL Express. There's comprehensive documentation to the Web Deploy e.g. on the iis.net site: http://learn.iis.net/page.aspx/346/web-deploy/
is working on a reply...