This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 95%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Hello All,
Requesting information regarding SSMA.
We are migrating our existing DB2 to Azure SQL. With regard to this we are trying to understand SSMA application which helps us in migration.
We referred various documentation with regard to this.
We want to understand if there are any feature specific to SSMA for Oracle. ? which is not present in DB2. We want to check this to confirm we are using the SSMA for DB2 with correct version.
We noticed SSMA for Oracle has many other feature like Tester (helps in Create test cases, Monitor the migration activities) which is missing in SSMA for DB2. Also The explicit FIX ADVISOR is also something missing in SSMA for DB2.
Do we get these features in SSMA for DB2?
We also did a complete installation for DB2 as well.
Any information to this regard will be of a great help.
SSMA for Oracle feature option: Image Ref:
SSMA for DB2:
feature specific to SSMA for Oracle. ? which is not present in DB2.
What's that for a question? Oracle and IBM DB2 are very different RDBMS and so SSMS will respect the differences and will work so a bit different.
Thanks for the response.
I do understand IBM DB2 and Oracle are a very different RDBMS and migration process, operation through SSMA work differently.
But here I am trying to understand if the functionality like Fix Advisor(Explicit fix suggestions) , Tester (Not sure what exactly this does, want to understand more about that) which are present in SSMA for Oracle and are missing in SSMA for DB2 Tool. Are these options/feature/Functionality vary across SSMA versions?
My basic understanding is SSMA as an application provides these options irrespective of any Database. Since these options are not Database specific rather these are SSMA tool specific
Please Correct me if my understanding is wrong..
I am trying to get a comparison of SSMA for Oracle and SSMA for IBM DB2 as an tool perspective.
Hi, @AKSHAY RANGA Thanks for posting your question in the Microsoft Q&A forum.
The features listed are not available in DB2 however this is in our pipeline. Can you share more info on the advisor and tester scenarios and how it will help in DB2 . Also, which flavor of Db2 do you need this support?
Regards
Geetha
Thanks for the update.
We use DB2 z/OS version 9.7.
Our team deals with huge amount of data. so validating those after migration is a tedious task. So, we thought tester feature in SSMA could help us more in validation of data migrated from DB2..
We are honestly not aware of how the "fix advisor" works. We need to evaluate more on the same. But we assume by the name, the feature will suggest few fixes / reviews the conversion and suggest few changes. Correct me if I am wrong..
Thanks and Regards,
Akshay H