Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2007-04-11 : 12:00:19
|
| I am not sure there are any tools to do a DB2 to SQL Migration.If there is, I could not find any.The one that came closest was the one which exported only the stored procedures.RegardsParesh MotiwalaBoston, USA |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-04-11 : 13:34:20
|
| SSIS will do it quite nicely. I used to use DTS for SQL 2000. What platform is DB2 on? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-11 : 13:46:39
|
| DTS/SSIS can move data between DB2 and SQL Server. You just need an ODBC driver for DB2.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-04-11 : 14:17:20
|
| if DB2 is on AS/400... i had big problems with odbc. used client access oledb provider with no problems. |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-04-20 : 08:46:42
|
| Thank you folks, I turned down that position and won't have to go through that again...(hopefully)RegardsParesh MotiwalaBoston, USA |
|
|
|
|
|
|
DB2 to SQL