PostgreSQL: Ora2Pg 24.0 have been released

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

Montreal, Canada - July 5th, 2023

Ora2Pg

Version 24.0 of Ora2Pg, a free and reliable tool used to migrate an Oracle database to PostgreSQL, has been officially released and is publicly available for download.

This major release adds official support to migration of SQL Server database to PostgreSQL. It also fixes several issues reported since past height months and adds some new features and improvements.

• Add SQL Server migration to Ora2Pg. Most of the SQL Server objects are supported as well as data export. Translation of the TSQL stored procedures to plpgsql is complicated because of the lack of statement separator in TSQL but as usual Ora2Pg is doing is best to do as much work as possible. Migration assessment is also possible with SQL Server database. There is some dedicated configuration directives added to ora2pg.conf.
• Enable the use of ALLOW/EXCLUDE directive with SHOW_* reports and throw a fatal err...

Get the full details here: PostgreSQL: Ora2Pg 24.0 have been released