SQLWays (Beta) Web: Preserving Source Database Case for PostgreSQL as Target

PostgreSQL automatically converts identifiers to lowercase.

As a result, object names such as ‘Menu’ in MS SQL Server are converted to ‘menu’ when not explicitly quoted during the conversion process.

To enable this behavior in the tool, please follow the steps below:

1. Click the Settings button in top right corner.
2. Go to Options tab.
3. Expand DDL section.
4. Locate the option called QUOTE_IDENTIFIERS.
5. Set this option to Always.

This setting instructs the tool to quote all identifiers, thereby preserving their original case from the source database. Once this is configured, please run the conversion again, and the resulting PostgreSQL objects should retain their original names exactly as defined in MS SQL Server.

For your convenience, a screenshot is provided below showing where to locate and modify the QUOTE_IDENTIFIERS setting in the interface:

After that, run the conversion.

Preserving case-sensitive schema names

More Tips and Tricks

If you have any questions or face any difficulties, please contact our support team at support@ispirer.com