Wednesday, March 28, 2012

Migrating data from DB2 to SQL Server

Hello,

I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.

Sincerely,

Eldhose Cyriaccontact1981 wrote:

Quote:

Originally Posted by

Hello,
>
I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.


Yes, of course.
To you push data regularly or is this a once of.
If you have to do it often you could consider Websphere Information
Integegrator. It allows you to push/pull data through normal SQL from
and to DB2.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/on...iness/conf2006/|||Hi

There is migration information at
http://www.microsoft.com/sql/prodin...bm/default.mspx, migration
tools exist for Oracle, Access and Sybase but there does not seem to be a
released version for DB2
http://www.microsoft.com/sql/soluti...on/default.mspx I suggest you
contact the SQL Server Migration team at the email address under the related
links on that page.

John

"contact1981" <contact1981@.gmail.comwrote in message
news:1154637593.696660.274720@.p79g2000cwp.googlegr oups.com...

Quote:

Originally Posted by

Hello,
>
I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.
>
>
Sincerely,
>
Eldhose Cyriac
>

No comments:

Post a Comment