Hello all! I just built my first Umbraco site on v12. I'm wanting to deploy to IIS and local SQL server 2019. the problem I'm having is as I was building locally, I used SQLite and I'm not sure how to migrate the SQLite DB to SQL server.
I've tried using SQLite3 using the .dump method to generate a SQL file, but I get tons of syntax errors. I've also tried ESF DB Migrator and I'm running into the same issues.
Does anyone have any experience with this or have any pointers?
I would recommend using uSync to export your database settings. You will be able to export your Document Type, Data Type etc settings as well as content and then import this into an empty Umbraco database running on SQL Server.
Migrating SQLite to SQL server
Hello all! I just built my first Umbraco site on v12. I'm wanting to deploy to IIS and local SQL server 2019. the problem I'm having is as I was building locally, I used SQLite and I'm not sure how to migrate the SQLite DB to SQL server.
I've tried using SQLite3 using the
.dump
method to generate a SQL file, but I get tons of syntax errors. I've also tried ESF DB Migrator and I'm running into the same issues.Does anyone have any experience with this or have any pointers?
Hi Philip,
I would recommend using uSync to export your database settings. You will be able to export your Document Type, Data Type etc settings as well as content and then import this into an empty Umbraco database running on SQL Server.
Cheers,
Marc
Terrific, thank you!
is working on a reply...