Wanted to post to share this.
I am exploring an architecture where I mostly use an embedded sqlite database inside the app - and transfer that entire database to the server.
I haven’t touched sqlite in a long time. Didn’t really want to bother writing scripts to build up the initial database. But, if you use SQL Server for any other purposes, and you use Sql Server Management studio, this add-in allows you to easily manage sqlite databases from a nice interface.: https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolboxforSSMS#overview