Hi, When we did our migration from SQL Server to PostgreSQL, we mainly used two tools: sqlserver2pgsql for most of our schema-related changes. You can find that here:
https://github.com/dalibo/sqlserver2pgsql. AWS Schema Conversion Tool (SCT) for migrating views and stored functions/procedures. The AWS SCT also can do schema conversions. You can find that here:
https://aws.amazon.com/dms/schema-conversion-tool/ Keep in mind that these conversion tools do the majority of the work, but the output they generate needs to be reviewed. For example, columns with an isjson() constraint need to be converted to json or jsonb columns. Stored procedures/functions
sometimes don’t convert at all. The following sites also provide the ability to conversion SQL statements using SQL Server-specific syntax to PostgreSQL. https://www.jooq.org/translate/
https://www.sqlines.com/online https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL Hope this helps, Joel From: Scott Simpson <Scott.Simpson@xxxxxxxxxx> ATTENTION: This email originated from outside of Tecsys. Use caution when clicking links or opening
attachments. | Ce courriel provient de l'extérieur de Tecsys. Soyez prudent lorsque vous cliquez sur des liens ou ouvrez des pièces jointes.
Hi, I need to migrate many PostgreSQL Stored Procedures and functions to MSSQL. I can find anything online that seems to handle this task. Are there any tools that you have that can do this job? Kind Regards Zellis | Scott Simpson | Senior Engineer Thorpe Park United Kingdom Work : +44 (0)20 3986 3523 Email : Scott.Simpson@xxxxxxxxxx Web : www.Zellis.com
|