Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Possibility : MSSQL to SQLite Bi-directional Sync

Author  Topic 

vijay1234
Starting Member

48 Posts

Posted - 2014-10-01 : 02:10:02
Hello All,

Good day

We have a new requirement to set up an Environment as per below.

Source level : DB Server with MSSQL installed.

Target levels: 1,2,3,4,.......n studios planning to install SQLite for cache Memory.


Here the requirement is to have a B-directional Sync between Source & Target Systems.

For Example: If the Source system has something to insert into Target System 1 then it should opt for only Target System 1.

Similarly for other target systems. All operations should be independent & should be Bi-directional.


So just wanted to check with the Possibility to achieve the requirement with MSSQLServer & SQLite(Planned) on Target systems.

Thanks,
Vijay

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-10-01 : 10:52:05
MS SQl has excellent tools for syncing data. Not sure about SQL Lite, but I tend to doubt it. You can write something or script it out I suppose. e.g. use a SSIS job to push data to the client sites as CSV, then write a script to run on the client side to read the CSV file and update the SQLLite tables. Same idea in reverse. However, you won't get ACID compliance or automated retries or anything sophisticated unless you write it yourself.
Go to Top of Page
   

- Advertisement -