search

darold / ora2pg

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.
http://www.ora2pg.com/
GNU General Public License v3.0
1.01k stars 343 forks source link

need some hint w.r.to ver 24.0 and the usage of MSSql Server to Postgresql Conversion #1662

Closed bharanisvng closed 1 year ago

bharanisvng commented 1 year ago

Team Need need some hint w.r.to ver 24.0 and the usage of MSSql Server to Postgresql Conversion a) what is the command syntax for generating assessment report - ms sql server to postgresql -M is not working if detailed documentation is available, can u please share it

b) how to generate DDL's Dump using MS Sql Server

darold commented 1 year ago

Hi,

First, please use latest development code I have fixed several MS SQL DDL export since the last release.

a) what is the command syntax for generating assessment report - ms sql server to postgresql -M is not working

This is the same as for Oracle: ora2pg -c config/ora2pg.conf -t SHOW_REPORT the source database type is auto-detected from the ORACLE_DSN value. Supposing that you have the right connection string.

b) how to generate DDL's Dump using MS Sql Server I don't know how to do that in SQL Server and also this is not the right place to ask help on SQL Server.

bharanisvng commented 1 year ago

a) as suggested , we have downloaded Development code and were testing MS SQL Server to Postgresql migration using ora2pg - dev version
ora2pg-master>ora2pg -t SHOW_REPORT -c ora2pg.conf -M dbi:ODBC:Driver="test2" > report1.html DBI connect('Driver=test2','sa',...) failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002) at C:/Strawberry/perl/site/lib/Ora2Pg/MSSQL.pm line 76. receiving the above said error. We confirmed the standalone ODBC driver is working correctly

b) regarding other question , need to know how to generate the postgres converted ddl for sql server as source by ora2pg.

darold commented 1 year ago

A good start is to read the README file and especially the part related to SQL Server. There is also plenty of ora2pg example of use on the web.