June 27, 2010 at 3:14 pm
Hi All,
I am being told to use log shipping to replicate data from DB2 to SQL Server (any version 2000/2005/2008)
Plz help if any one has find some solution or has used some tool to do the same.
June 27, 2010 at 6:29 pm
Forgive me if I am incorrect, but I believe that log shipping can only be done between MS SQL servers. You may be better looking something like scheduled SSIS jobs.
Joie Andrew
"Since 1982"
June 29, 2010 at 3:32 pm
No I am specifically looking for a tool that provides log shipping between cross database platforms
June 29, 2010 at 3:41 pm
Better come up with a different plan.
I've never heard of such a tool, and I really, really, really doubt it exists.
June 29, 2010 at 3:43 pm
There is no way you are going to be able to restore a non-SQL database into a SQL database.
You will have to use logical data transfers rather than physical, hence SSIS as suggested earlier.
---------------------------------------------------------------------
June 29, 2010 at 6:09 pm
No I am specifically looking for a tool that provides log shipping between cross database platforms
Is this hard requirement targeting a specific tool that your management/organization already is looking into purchasing? Otherwise I would say you are out of luck unless they are flexible in how they want to to get their data from server A to server B.
Joie Andrew
"Since 1982"
June 29, 2010 at 8:26 pm
Firstly the database is quite big as it is an ERP database.
Secondly there are many cases where the updated data is not dependent on the last modified date, for example the status of any order gets changed without affecting/changing the last modified date. In such scenarios I will not be able to capture what all DML (especially in case of deletion of any lines) are performed through incremental logic in SSIS package.
The only option left is then to pull the complete data from the production server on a daily basis, which is logically incorrect.
That's why I am searching a third party tool which can provide the functionality of log shipping between DB2 and SQL Server
June 30, 2010 at 1:31 am
The only option left is then to pull the complete data from the production server on a daily basis, which is logically incorrect.
That's not your only option left. Have you looked at replication between heterogeneous servers?
Integrating Heterogeneous Data
Joie Andrew
"Since 1982"
July 8, 2010 at 11:24 pm
Hi All,
There is a tool known as Data Replication Tool – Daffodil Replicator.
It does a replication between DB2 and SQL Server.
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply