Compass is recommended. See this answer for Compass download information.
Compass is recommended because:
- Compass is designed specifically for Babelfish and to detect nuances in the DDL.
- Compass reports contain additional instructions for Babelfish.
Keep in mind, SCT is only used for assessment for Babelfish (although Compass is recommended). Do not use SCT's conversion feature: Babelfish understands the SQL Server dialect and DDLs directly, after adjusting the DDL for any unsupported features in the assessment report.
Quoted from this post.
You have two options for assessment tools for Babelfish. One option is the Babelfish Compass tool, which is part of the Babelfish product. When a new release of Babelfish becomes available, an up-to-date version of Compass will also be available. In contrast, AWS SCT will support newer Babelfish version after some time. Compass also provides a feature to automatically rewrite certain unsupported T-SQL constructs in such a way that Babelfish can support them after all. The other option is the assessment report built into AWS SCT. Both tools use the same underlying Babelfish feature definitions for evaluation, but Compass generally provides more accurate results.
Should I use Compass or SCT for a Babelfish assessment?Accepted Answer
How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.asked 7 months ago
How do I know if Babelfish supports my SQL Server application?Accepted Answer
If I use both the PostgreSQL and TDS port with Babelfish, what should I know?Accepted Answer
Babelfish: How do I get started?Accepted Answer
Does Babelfish support XML? How can I use XML?
Tag request for Babelfish
What are the limitations of Babelfish?Accepted Answerasked 6 months ago
What port does Babelfish work over and should I be able to test with osql?asked a year ago
Migrate SQL Server DB (outside of AWS) to Aurora DB in AWSAccepted Answerasked 4 months ago