question

srinandan avatar image
srinandan asked

Synchronising number of disconnected databases to a central DB

Synchronizing number of disconnected databases to a central DB. here is real scenario: There are number of laptops installed a window application connected with local database and all these machines works in remote area where no internet connectivity is there. we have another web application connected to a central db.the Idea to synchronize database is that every machines export there data at the end of day and save the exported file in removable disk and place all the exported file to a specific location using FTP. My requirement is to import all the exported files into central database and vice-versa. there are around 15 table out of 100 on which need to keep the synchronization. Please suggest.
export-datadatabase-filesdata-exportfile locationimport-export-wizard
4 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Sounds fairly straight forward and simple. Which part are you having a problem with?
0 Likes 0 ·
I am new to database synchronization.Please suggest a framework/architecture using C# to manage syncing of 15 out of 100 tables for multiple database to central database
0 Likes 0 ·
What are the database models/versions on the laptops and for the central database? SQL Server has a few options I believe would work (bcp and SSIS, for example), but knowing the database versions/editions would help determine an appropriate answer.
0 Likes 0 ·
I'm sorry, but this is sounding like another one of those: "I don't know what I'm doing, so can those of you who get paid to do this, please tell me for free what to do." I have already reached my quota for this week. I don't mind helping those that can demonstrate that they have taken the time to research possible solutions and have questions about specific items.
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.