Tweet
Hi,
We're trying to develop a support application in AMS which stores data in a local database, and then updates a remote database - possibly days later if the app is on a laptop that cannot always access the remote DB.
On Timer checks if the remote DB is present. If so, it selects data from the local DB, stores in variables and creates an insert for the remote DB. However, the SQL scripts are getting quite complicated, particularly with updates from the local DB to the remote DB. We've been using SQLite3 as the local DB and MariaDB/MySQL as the remote DB.
Is there a simpler/easier way of doing this either with these DBMS or others? Merge Replication using SQL Server appears possible, but we'd be looking to use the Express edition for the local DB which only supports subscribers, whereas in this case the local DB would be the main publisher as it is collecting the data and then sending it to the central DB.
Any thoughts would be welcome!
Thanks,
A1IT
We're trying to develop a support application in AMS which stores data in a local database, and then updates a remote database - possibly days later if the app is on a laptop that cannot always access the remote DB.
On Timer checks if the remote DB is present. If so, it selects data from the local DB, stores in variables and creates an insert for the remote DB. However, the SQL scripts are getting quite complicated, particularly with updates from the local DB to the remote DB. We've been using SQLite3 as the local DB and MariaDB/MySQL as the remote DB.
Is there a simpler/easier way of doing this either with these DBMS or others? Merge Replication using SQL Server appears possible, but we'd be looking to use the Express edition for the local DB which only supports subscribers, whereas in this case the local DB would be the main publisher as it is collecting the data and then sending it to the central DB.
Any thoughts would be welcome!
Thanks,
A1IT
Comment