> I was wondering if anyone has any tips that are specific for SQL Server
> users? Best features? Known issues? Common rebuttals?
Are you talking about SS to PG migration.
Generally SQLServer shops use SS specific functions and T-SQL heavily since
they provide very good functionality.
For example:
1, convert function is used heavily in SQL to format various datetime formats.
2. SS does case insensitive searches. Converting it to PG involves modifying
the SQL. Not an easy job to do.
3. SS has 3 part structures. DB.SCHEMA.TABLE which can be used in SQL. PG can
go only up to 2 part SCHEMA.TABLE.
3 part is possible, but using FDW or other cumbersome mechanism.
