I know(think) it is fairly easy to upsize a SQLCE database to a sql one. I made an uninformed decision when I set up my website. I really like the idea of being able to copy and deploy my website and to copy it down for backup, especially with better support for SQLCE now. Is there a way to downsize a sql DB to CE?
On another note I suppose it would not be all the bad to start over...I don't have much(read any) content really in there yet. Just the few bug fixes needed for the business template.
There's nothing wrong with running live websites of SQL CE4, in many instances it can be a good option. The only concern I have about it is scaleability. High traffic websites are not going to scale out as well on CE4 as they would on a full SQL implementation (also running multi-headed webserves with an embedded databases provides a challenge!)
I'm not sure if there's any automated tools for moving from one DB type to the other. You can generate SQL scripts from SQL Server which you can then run against a CE4 database (using Visual Studio 2010 SP1, not sure about WebMatrix though).
Hi, not sure if there is a tool for migrating either but the best option if you are starting again would be to package up your existing templates, document types etc and import into a new project.
Well I'd be happy if I had to worry about scalability. I don't think I'll have high traffic. I already have it on sql, so I'll probably leave it there. I can create backups or difference scripts.
I've build a website using SQL CE, now I need to upgrade to MSSQL, is there any easy way to do this, webmatrix has a migrate button under the database section to migrate it, but it requires a username and password, No database username and password is required when setting up a SQLCE, It is now asking for a username and password but I don't have one. it is not the same as the one setup specifically for umbraco.
MSSQL server to SQLCE4 ?
I know(think) it is fairly easy to upsize a SQLCE database to a sql one. I made an uninformed decision when I set up my website. I really like the idea of being able to copy and deploy my website and to copy it down for backup, especially with better support for SQLCE now. Is there a way to downsize a sql DB to CE?
On another note I suppose it would not be all the bad to start over...I don't have much(read any) content really in there yet. Just the few bug fixes needed for the business template.
There's nothing wrong with running live websites of SQL CE4, in many instances it can be a good option. The only concern I have about it is scaleability. High traffic websites are not going to scale out as well on CE4 as they would on a full SQL implementation (also running multi-headed webserves with an embedded databases provides a challenge!)
I'm not sure if there's any automated tools for moving from one DB type to the other. You can generate SQL scripts from SQL Server which you can then run against a CE4 database (using Visual Studio 2010 SP1, not sure about WebMatrix though).
Hi, not sure if there is a tool for migrating either but the best option if you are starting again would be to package up your existing templates, document types etc and import into a new project.
Well I'd be happy if I had to worry about scalability. I don't think I'll have high traffic. I already have it on sql, so I'll probably leave it there. I can create backups or difference scripts.
Paul good call on the packagfe. Thanks.
Hi Guys
I hope someone can help.
I've build a website using SQL CE, now I need to upgrade to MSSQL, is there any easy way to do this, webmatrix has a migrate button under the database section to migrate it, but it requires a username and password, No database username and password is required when setting up a SQLCE, It is now asking for a username and password but I don't have one. it is not the same as the one setup specifically for umbraco.
Please can someone help
Thanks
Brendan
is working on a reply...