General rule I follow is SQL CE is not suitable for production Umbraco sites. Useful for a quick spin up of an Umbraco instance to test something but use SQL Express / Full SQL for production - this means it's usually easier just to start a new project off with SQL Express.
If you've already started dev in CE it's possible to migrate - some google searching will bring up the solution.
If there's anyone out there that does use CE for production I'd be happy to be proved wrong!
SQLCE is a lot slower (but luckily, that only shows in the backoffice), and somehow prone to errors by corruption. I wouldn't use it for anything bigger than "your moms website".
SDF and SQL installation of umbraco
what is difference between sdf and SQL installation of umbraco. what are benefit and limitations of installation umbraco using sdf database.
is any problem in future to proceed with SDF database installation of umbraco.
any help appreciated?
Hi Himasnhu,
General rule I follow is SQL CE is not suitable for production Umbraco sites. Useful for a quick spin up of an Umbraco instance to test something but use SQL Express / Full SQL for production - this means it's usually easier just to start a new project off with SQL Express.
If you've already started dev in CE it's possible to migrate - some google searching will bring up the solution.
If there's anyone out there that does use CE for production I'd be happy to be proved wrong!
Steve
Thanks for Reply Steve , but we are also waiting for another opinions and response from another users and support Staff.
Also can you let me know if we are using small website with lots of media items should it suitable for us?
SQLCE is a lot slower (but luckily, that only shows in the backoffice), and somehow prone to errors by corruption. I wouldn't use it for anything bigger than "your moms website".
Thanks Kottal ...
So, should we consider that SQL Express /Server Installation of umbraco is best for website design?
Yes, no doubt about that :)
is working on a reply...