Solved

How to automate the data transfer across a distributed environment?

Posted on 2010-08-24
3
315 Views
Last Modified: 2013-11-30
We have a distributed environment across different georaphical areas (connected together through VPN only).
I assume that ETL tools can't deal with such a situation. Am I right?

So how to automate the data transfer from one site to the main site?
Target is SQL Server...
0
Comment
Question by:DBADS
3 Comments
 
LVL 8

Expert Comment

by:infolurk
ID: 33508424
I wouldnt assume the ETL tool cant work across a network through a VPN. Have you contacted the vendor? Which tool are you using?
0
 

Author Comment

by:DBADS
ID: 33508755
Haven't decided yet on the tool, but any tool that would support automation through distributed env is acceptable...
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 250 total points
ID: 33513212
What should condition the choice of the tool you are to be using are the two factors below:

> Data size to be synchronized: for important sizes of data to be synchronized, choose GoldenGate.  For smaller sizes, SQL Server native replication should be sufficient
> Network bandwidth: based on how much bandwidth, you may consider tools that are more or less network tolerant.  SQL Server native replication is usually sufficient.  You may also consider database mirroriing.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now