Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I'm looking for a tools that allows migration of DB2/UDB databases to SQL Server. It's quite easy migrate schema and data using linked server or import export with SISS.

But what about stored procedures? We have a lot complex stored procedures. There are some tools like the ispirer one -- which is too expensive and not so mature -- other one the swissql one is no more maintained.

What about other tools? Anyone have experience about? My focus is on stored procedure migration.

share|improve this question

2 Answers

up vote 1 down vote

This is not an easy task to translate from one flavor of SQL to another. That's either (kind of) expensive or difficult to do for yourself.

No database language flavor is really easy to digest and translate into another, because all have lots of system procedures, data types, functions and others that are really system specific.

Each SQL flavor implements a subset of the SQL 92, 99 or 2003 Standard, and then goes further with local features.

share|improve this answer
1  
@user1299153 - I'd agree with Marian. As painful as it may be, you might be best off migrating the stored procedures manually to make sure they run appropriately. – Chris Aldrich Feb 8 at 22:14
up vote 0 down vote

IBM published a Redbook back in June 2005 called Microsoft SQL Server to IBM DB2 UDB Conversion Guide. Obviously a lot has changed since then. It does mention a Migration Toolkit (MTK) from IBM which is or was free. It was at least updated to v2.0 in April 2007, but I do not see what happened to it after that.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.