migrating to ms sql from db2

currently running db2 database on IBM AS/400, looking to down size. We want to convert the db2 database to MS SQL and run it on windows 2003.
Is this a latteral move or do we have to change anything within DB2 or MS SQL(naming conventions, file types or sizes, schemas, etc) is there any tools out there for this type of migration?
Thank you for your help.You can reverse engineer your DB2 with ERwin and forward generate the model
to SQL to get your schema accross. But that is not necessarily a 1-button
push type operation. I imagine there will be subtle difference in how chars
and such are handled and they may manifest them selves as truncation bugs
and such when you run you stored procedures and such later.
Ata R
Parvan Consulting Inc
NO_SPAMar_alias001@.NO_SPAMparvan.net
"dossman10" <anonymous@.discussions.microsoft.com> wrote in message
news:F0CF5A34-6196-44D1-9FA7-4C086AD70BCF@.microsoft.com...
> currently running db2 database on IBM AS/400, looking to down size. We
want to convert the db2 database to MS SQL and run it on windows 2003.
> Is this a latteral move or do we have to change anything within DB2 or MS
SQL(naming conventions, file types or sizes, schemas, etc) is there any
tools out there for this type of migration?
> Thank you for your help.

migrating to ms sql

we are wanting convert to MS SQL and windows 2003 running on an Intel platfrom, converting from IBM DB2 AS/400. Is it possible and what would it take to convert
Thank you.Sure it's possible.
It will take time, money and resources. Resources should
include people knowledgeable of both DB2 and Sql Server.
Your question wasn't very specific, so it's hard to give
you a very good answer.
>--Original Message--
>we are wanting convert to MS SQL and windows 2003
running on an Intel platfrom, converting from IBM DB2
AS/400. Is it possible and what would it take to convert?
>Thank you.
>.
>|||"dossman10" <anonymous@.discussions.microsoft.com> wrote in message
news:D1D753CE-78FC-4553-A36E-14FE075CC5BA@.microsoft.com...
> we are wanting convert to MS SQL and windows 2003 running on an Intel
platfrom, converting from IBM DB2 AS/400. Is it possible and what would it
take to convert?
> Thank you.|||Hi,
If it is only tables, We can do the data transfer using DTS.
But to connect from Win2003 server to AS/400 machine you should install
DB2CONNECT for AS400 provided
by IBM.
Thanks
Hari
MCDBA
"dossman10" <anonymous@.discussions.microsoft.com> wrote in message
news:D1D753CE-78FC-4553-A36E-14FE075CC5BA@.microsoft.com...
> we are wanting convert to MS SQL and windows 2003 running on an Intel
platfrom, converting from IBM DB2 AS/400. Is it possible and what would it
take to convert?
> Thank you.