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.
| Author |
Topic |
|
vijay1234
Starting Member
48 Posts |
 Posted - 2014-10-01 : 02:10:02
|
| Hello All,Good dayWe 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. |
 |
|
|
|
|
|
Possibility : MSSQL to SQLite Bi-directional Sync