Ispirer Website
Ispirer Capabilities: PostgreSQL Migration
Free Trial
Synonyms Conversion from DB2 LUW to PostgreSQL
Since PG doesn’t support synonyms, they could not be converted from DB2 except those that created for tables.
To convert such synonyms using view, you need to use the option:
[DDL]
SYNONYM_TO_VIEW=Yes
More details on how to set the option can be found in the How to Set Options in SQLWays Wizard article.
If this option is used, instead of synonyms for tables and views, PostgreSQL will create views for the corresponding objects:
| DB2 LUW | POSTGRESQL |
|---|---|
| CREATE ALIAS Al1 FOR tab1; | CREATE VIEW Al1 AS SELECT * FROM tab1; |
For other types of objects (functions, procedures, etc.), during migration, synonyms will be skipped and the code will change the use of synonyms to the objects themselves.
If you have any other questions regarding the usage of our tool, please, contact our support team: support@ispirer.com