• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

How to automate the data transfer across a distributed environment?

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
DBADS
Asked:
DBADS
1 Solution
 
infolurkCommented:
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
 
DBADSAuthor Commented:
Haven't decided yet on the tool, but any tool that would support automation through distributed env is acceptable...
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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