emi_sastra
asked on
Data sync between server site at distance.
We have a head office and a warehouse far away from the head office.
WHat we are going to do are:
1. Put a server at head office.
2. A client desktop that have application and database that similar to the database at server at head office.
3. Using ADSL as a communication.
4. We use desktop application, not web application.
5. We don't want to directly access data to the server from the warehouse.
6. We want to have a local data on the warehouse and local application.
7. We want to update the transaction data to head office server after each transaction is saved to the warehouse database.
8. We want to update the transaction data to warehouse server after each transaction is saved to the server database.
What should we do to achieve it ?
We use visual basic 6 or vb 2005 and sql server.
Thank you.
WHat we are going to do are:
1. Put a server at head office.
2. A client desktop that have application and database that similar to the database at server at head office.
3. Using ADSL as a communication.
4. We use desktop application, not web application.
5. We don't want to directly access data to the server from the warehouse.
6. We want to have a local data on the warehouse and local application.
7. We want to update the transaction data to head office server after each transaction is saved to the warehouse database.
8. We want to update the transaction data to warehouse server after each transaction is saved to the server database.
What should we do to achieve it ?
We use visual basic 6 or vb 2005 and sql server.
Thank you.
ASKER
How to do it ?
1. Transaction replication.
2. Merge replication.
Using programming or using SQL Server facilities ?
Thank you.
1. Transaction replication.
2. Merge replication.
Using programming or using SQL Server facilities ?
Thank you.
it should be done using sql server facilities
Setting up Replication(step by step)
======================
http://www.sqlservercentral.com/columnists/crego/2690.asp
Setting up Replication(step by step)
======================
http://www.sqlservercentral.com/columnists/crego/2690.asp
ASKER
Our consideration is the communication line.
My question are:
1. Could we do it by coding in program ?
2. If we do point 1, what is the disadvantage and disadvantage compared to replication or merging?
Thank you
My question are:
1. Could we do it by coding in program ?
2. If we do point 1, what is the disadvantage and disadvantage compared to replication or merging?
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you have two choices
1. Transaction replication.
2. Merge replication.