I have created a site locally using the SQL CE 4 engine on Umbraco 4.7 under the advice that the hosting company would support this 100%. Having got to the point where I need to upload the site the hosting company have found some issues with their SQL CE4 support and removed it. They do however have support for a single SQL 2008 database and so my question is:-
How do I convert a populated Umbraco SQL CE4 SDF file to a proper SQL server database? Ive tried WebMatrix but that throws an exception.
I know that the engines are vastly different but the tables/columns must be somewhat similar.
Has anyone done this? Are there any tools out there to help?
SQL CE4 to SQL 2008 conversion
HI All,
I have created a site locally using the SQL CE 4 engine on Umbraco 4.7 under the advice that the hosting company would support this 100%. Having got to the point where I need to upload the site the hosting company have found some issues with their SQL CE4 support and removed it. They do however have support for a single SQL 2008 database and so my question is:-
How do I convert a populated Umbraco SQL CE4 SDF file to a proper SQL server database? Ive tried WebMatrix but that throws an exception.
I know that the engines are vastly different but the tables/columns must be somewhat similar.
Has anyone done this? Are there any tools out there to help?
Thanks
Andy
Hi Andy,
Might be worth to try the suggestions in this thread on StackOverlow.
Cheers,
Richard
is working on a reply...