Tuesday, March 27, 2012

DB2 to MSSQL

Hi Frenz,
Cud anybody pls tell me the way to convert DB2 to MSSQL database.
Initially, I'm attempting to transfer database, using DTS from one SQL
Server to another one.
But never succeeded. So, dont have guts to do the same with DB2
database.
Pls suggest me a good way.
Thanks,
Dutt.You have a tool called as import export data which will help you in migratio
n
process see BOl for further options.also be careful for the datatypes,to
overcome this issue first create a script (using denerate script
option),analyse is then apply.
"Dutt" wrote:

> Hi Frenz,
> Cud anybody pls tell me the way to convert DB2 to MSSQL database.
> Initially, I'm attempting to transfer database, using DTS from one SQL
> Server to another one.
> But never succeeded. So, dont have guts to do the same with DB2
> database.
> Pls suggest me a good way.
> Thanks,
> Dutt.
>|||Hi Arshad,
Its OK. I'm aware of it.
My intention is to transform DB2 database to MS SQL database.
Cud u help me in that direction'
Thanks,
Dutt...|||If you are using SQL Server 2005, you can use the Microsoft OLEDB Provider
for DB2 (Feature Pack for Microsoft SQL Server 2005 - November 2005,
http://www.microsoft.com/downloads/...&displaylang=en).
It will help you with the data type conversion, as far as handling it for
you, which could be equally covenient or problematic.
I would script the tables, create them in SQL Server, and then import the
data. Once the data has been imported, I would apply the contraints (PK, FK,
etc.)
I hope it helps...
"Dutt" wrote:

> Hi Arshad,
> Its OK. I'm aware of it.
> My intention is to transform DB2 database to MS SQL database.
> Cud u help me in that direction'
> Thanks,
> Dutt...
>|||The biggest task you face is that DB2 implements all of ANS SQL 99 and much
of ANS SQL 2003, whereas MS SQL implements only a smallish subset of ANS SQL
99, and almost completely ignores the standard for functions and stored
procedures. This can make converting the SQL very difficult.
Transforming the data is feasible when you don't need DATE, TIME or other
unsupported types. Edgar gave you the link.
In any case, you should plan on a major reengineering task, and you will
need to allocated adequate resources to the job.
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1171630315.708507.16460@.l53g2000cwa.googlegroups.com...
> Hi Arshad,
> Its OK. I'm aware of it.
> My intention is to transform DB2 database to MS SQL database.
> Cud u help me in that direction'
> Thanks,
> Dutt...
>|||On 16 Feb 2007 00:27:13 -0800, "Dutt" <Mr.Dutt@.gmail.com> wrote:

>Hi Frenz,
>Cud anybody pls tell me the way to convert DB2 to MSSQL database.
>Initially, I'm attempting to transfer database, using DTS from one SQL
>Server to another one.
>But never succeeded. So, dont have guts to do the same with DB2
>database.
>Pls suggest me a good way.
At my present gig, we loaded the DB2 client for windows stuff with a
new driver, and DTS works with it quite nicely, to bring over flat
tables. You can do that, manually redefine indexes and whatnot, and
away you go!
Josh

No comments:

Post a Comment