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?
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/112943-migrating-sqlite-to-sql-server