asked on

SQL database synchronisation / live synchronisation

Hi there

We are looking into getting a new in office recruitment sql database. The company has told us the best way forward if we open two offices would be for the second office to remote in via terminal services or rww. However in the past I have worked for companies that have several offices and they sync their databases overnight or use live synchronisation.

We have a normal broadband line, 0.2mb upload / 1mb download which we cannot alter as it is in a serviced office. I wanted to know if it was possible and what would be involved or needed. Is it costly?

Many thanks for your help

arnold

I think you mean replicated. and your bandwidth ( upload), you would likely have to configure the remote as a pull replication.
http://www.databasejournal.com/features/mssql/article.php/1438231/Setting-Up-Merge-Replication-A-Step-by-step-Guide.htm
http://www.codeproject.com/KB/database/sql2005-replication.aspx
http://www.informit.com/articles/article.aspx?p=659523

antalp71

ASKER

Thanks for the quick reply. I actually have to merge two office based databases on a daily basis and from your links I see this is possible via the internet. Is it possible for this to be programmed to carry out automatically?

ASKER CERTIFIED SOLUTION

arnold

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

antalp71

ASKER

Thank you for your help and the links.