Take the 2-minute tour ×
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.

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
add comment

closed as off-topic by Mark Storey-Smith, bluefeet, RolandoMySQLDBA, Max Vernon, Michael - sqlbot Oct 23 '13 at 11:55

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Mark Storey-Smith, bluefeet, RolandoMySQLDBA, Max Vernon, Michael - sqlbot
If this question can be reworded to fit the rules in the help center, please edit the question.

3 Answers

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
2  
@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 '13 at 22:14
add comment

I can say that Ispirer's product SQLWays not so basic as you say. The tool automatically migrates both data and stored procedures. If you have any doubts, you can try it out by yourself: http://www.ispirer.com/download/download-demo.

share|improve this answer
add comment

Have a look at SQLines SQL Converter at http://www.sqlines.com/db2-to-sql-server, it supports DDL and stored procedure conversion from DB2 to SQL Server.

share|improve this answer
add comment

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