Friday, March 9, 2012

Migration Tool

Can somebody suggest me migration tool for DB2 to SQL Server?
Thanks
PrashantPrashant,
1. Create a linkedserver for DB2 - small quick migration
or
2. Use DTS (Data Transformation Services) - many tables
or
3. BCP (IN) - larger migration
or
4. Replication - depending on the needs
or
5. Third-party tool i.e.,
http://www.starquest.com/Productfolder/infoSQDR.html or
http://www.google.com/search?hl=en&lr=&q=migrate+db2+to+sql+server+&btnG=Search
HTH
Jerry
"Prashant Bharti" <prashantb@.aditi.com> wrote in message
news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
> Can somebody suggest me migration tool for DB2 to SQL Server?
> Thanks
> Prashant
>|||Microsoft has plenty of information for migration from Oracle to MS SQL, but there
is nothing out there for DB2. What is the reason behind this, and will we soon see
a SSAM for DB2, as it already exists for Oracle ?
best regards
andreas
On Tue, 25 Oct 2005 08:26:56 -0700, "Jerry Spivey" <jspivey@.vestas-awt.com> wrote:
>Prashant,
>1. Create a linkedserver for DB2 - small quick migration
>or
>2. Use DTS (Data Transformation Services) - many tables
>or
>3. BCP (IN) - larger migration
>or
>4. Replication - depending on the needs
>or
>5. Third-party tool i.e.,
>http://www.starquest.com/Productfolder/infoSQDR.html or
>http://www.google.com/search?hl=en&lr=&q=migrate+db2+to+sql+server+&btnG=Search
>HTH
>Jerry
>"Prashant Bharti" <prashantb@.aditi.com> wrote in message
>news:uCaugHV2FHA.2472@.TK2MSFTNGP12.phx.gbl...
>> Can somebody suggest me migration tool for DB2 to SQL Server?
>> Thanks
>> Prashant
>

No comments:

Post a Comment