Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

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.
0
emi_sastra
Asked:
emi_sastra
  • 3
  • 2
1 Solution
 
imran_fastCommented:
on the database level Implement replication.

you have two choices
1. Transaction replication.
2. Merge replication.
0
 
emi_sastraAuthor Commented:
How to do it ?

1. Transaction replication.
2. Merge replication.

Using programming or using SQL Server facilities ?

Thank you.
0
 
imran_fastCommented:
it should be done using sql server facilities

Setting up Replication(step by step)
======================
http://www.sqlservercentral.com/columnists/crego/2690.asp
0
 
emi_sastraAuthor Commented:
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


0
 
imran_fastCommented:
>> COULD we do it by coding in program.
Yes you can but it will be slow. and it will be like reinventing the wheel. and requied lot of coding.

there are different type of replication for example if you choose to have immediate transactional replication what will happen is as soon as you make changes it will go to the source.

Then you have queued transactional replication in which all the changes will be logged and as soon as there is connection witht the source server or the available link you the data willbe synch. Also you can shcedule the synch to take place during off peak time.

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now