Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paulnamroud
Starting Member
26 Posts |
 Posted - 2013-03-07 : 14:51:46
|
| Hello,I'm working with 2 different databases on 2 different server.On the first server we have installed MS SQL Server 2008 and on the second server we have DB2 already installed,So, we would to synchronize Data between SQL Server & DB2 and vice versa on a daily basis.So i'm wondering if there's a way to do it. If yes, how to proceed ?Or, if there's a tool that we can buy and install it that will do the job.ThanksPaul |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-07 : 15:01:58
|
| One method is to design ssis packages for data sync between the databases. these can be called from sql agent job for automating the execution.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-03-09 : 05:20:03
|
| Is the DB2 on Linix or Windows?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
How to Synchronize SQL Server and DB2