I'm trying to build a desktop application using electron, which will be online first app, where the data needs to be synced from the live server to the local database.
I want to use SQL Server Express as the local offline database. Previously I tried to connect SQLite with Electron. I was able to successfully create a connection and work without any problem, but it is a file-based database, but in the case of SQL Server Express, I don't think it is file based system like SQLite.
I did some research about it, it's saying that SQL Server Express can be changed to file-based DB, but it must be used only in dev environment, I want to create the SQL Server Express database in the client system locally and create the same table structures as online server, when the user installs my electron application.
This system will online first, after installing and logging, I want to sync the online data into the offline database.