• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Near real time replication for SQL*Server

mace

More time posting than coding
Joined
Sep 27, 2007
Messages
330
Likes received
0
Thanks received
0
Hi all,

I'm aware of DataMirror which will capture subscribed table data from the Oracle or DB2 transaction logs. Is there something similar in SQL*Server or does DataMirror work for this? I need to replicate data from various source databases to a SQL*Server operational data store in near realtime. Does SSIS have near real time replication functionality, perhaps?
 
Check out Goldengate. I have a little of experience of it (not hands on) and by all accounts it's a good product (but not cheap). The company has just been acquired by Oracle. Datasheet says,

GoldenGate supports a wide range of database versions from Oracle, Microsoft SQL Server, IBM DB2 OS/390 and UDB, Sybase, Enscribe, SQL/MP, SQL/MX, and Teradata running on UNIX, Windows, and HP Nonstop platforms.

www.goldengate.com
 

Advertisers

Back
Top