lilyyan
asked on
How to convert a DB2 database to MS SQL server database ?
Hello,
I have some DB2 tables and I want to migrate the table to MS SQL server? Is there an easy to do this?
Thanks so much for your suggestion,
Regards,
lilyyan
I have some DB2 tables and I want to migrate the table to MS SQL server? Is there an easy to do this?
Thanks so much for your suggestion,
Regards,
lilyyan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what version of sql server do you run ?
you can try to do it using DTS (in sql 2000) or SSIS (in sql 2005)
these tools should make the movement of data rather simple,
i believe you will also be able to create the destination tables in sql server using these tools and you won't have to spend time on converting db2's syntax to sql server's
you can try to do it using DTS (in sql 2000) or SSIS (in sql 2005)
these tools should make the movement of data rather simple,
i believe you will also be able to create the destination tables in sql server using these tools and you won't have to spend time on converting db2's syntax to sql server's
ASKER
HI Momi,
Thanks for your reply. I'm using sql 2000. could you explain a little more about DTS ? How to use it?
lilyyan
Thanks for your reply. I'm using sql 2000. could you explain a little more about DTS ? How to use it?
lilyyan
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, thanks for the replies. I want the table and the data to be moved to MS sql server. I do find the DTS tool in ms sql Entreprise Managar. not sure how to ue it yet. any suggestion? Thanks very much!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, thanks much for your reply.
how to map the source db2 tables to sources using odbc driver? did mean register a db2 server.?
(my pc has db2 management and development tools installed)
how to map the source db2 tables to sources using odbc driver? did mean register a db2 server.?
(my pc has db2 management and development tools installed)
inside your sql server client, you should create a new dts package
and follow the wizards
you don't use db2 tools here
and follow the wizards
you don't use db2 tools here
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your reply. so the basic steps for the data migration is to: use DB2LOOK to generate SQL statment, then generate a CSV file and trnsfer to MS SQL server?
lilyyan