Can anyone please suggest a method to convert a database from SQLLite to SQL Server, particularly an Umbraco database, in such a way that I will have little to no trouble connecting to it?
Not sure about straight conversion however you could look at using uSync to export all of your Umbraco settings and content and then import into a new SQL Server database with a clean version of the Umbraco tables installed.
Convert SQLite database to SQL Server
Hi,
I recently installed the latest version of Umbraco and started using it for a while.
It turns out that it used an SQLLite database (.db) and I would like to convert it to a SQL Server database (.mdf),
I've search around but I'm not really confortable using some of the methods I have found:
Can anyone please suggest a method to convert a database from SQLLite to SQL Server, particularly an Umbraco database, in such a way that I will have little to no trouble connecting to it?
Thank you.
Hi Tiago,
Not sure about straight conversion however you could look at using uSync to export all of your Umbraco settings and content and then import into a new SQL Server database with a clean version of the Umbraco tables installed.
Cheers,
Marc
is working on a reply...