Ispirer Website
Ispirer Capabilities: PostgreSQL Migration
Free Trial
Preserving Source Database Case in Names of Objects for PostgreSQL as Target
Since in PostgreSQL unquoted names are always stored to lower case, to enclose all the identifier names in quotes in target scripts in SQLWays Wizard we can switch on the option, which is responsible for this action:
- Enable expert mode in the tool
- Set the option QUOTE_IDENTIFIERS=Always
After that run the conversion.
NOTICE: Since the option is set, the object names will be created in double quotes in PostgreSQL.
If you have any questions or face any difficulties, please contact our support team at support@ispirer.com