Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
When rendering a assessment report on a SQL Server Instance (version 2014), ora2pg gave me an error:
DBD::ODBC::st execute failed:
[Microsoft][ODBC Driver 18 for SQL Server][SQL Server]
Invalid column name 'auto_created'. (SQL-42S22) [state was 42S22 now 42000]
[Microsoft][ODBC Driver 18 for SQL Server][SQL Server]
Statement(s) could not be prepared. (SQL-42000) at /usr/local/share/perl/5.34.0/Ora2Pg/MSSQL.pm line 1824.
SQL Server version: 12.0.5000.0
Ora2Pg version: 24.1
darold
commented
8 months ago
Hello,
When rendering a assessment report on a SQL Server Instance (version 2014), ora2pg gave me an error:
SQL Server version: 12.0.5000.0 Ora2Pg version: 24.1
Regards