Comments (10)
darold
commented on June 30, 2024
I don't know what issues you are talking about if this is a connection problem like in #1668 you should review your settings I can not reproduce with a MS SQL Server 2019:
/home/git/test_ora2pg/mssql-db$ sh export_schema.sh
[2023-10-04 13:28:52] [========================>] 16/16 tables (100.0%) end of scanning.
[2023-10-04 13:28:52] [========================>] 6/6 objects types (100.0%) end of objects auditing.
Running: ora2pg -p -t SEQUENCE -o sequence.sql -b ./schema/sequences -c ./config/ora2pg.conf
[2023-10-04 13:28:52] [========================>] 0/0 sequences (100.0%) end of output.
Running: ora2pg -p -t SEQUENCE_VALUES -o sequence_value.sql -b ./schema/sequence_values -c ./config/ora2pg.conf
[2023-10-04 13:28:52] [========================>] 0/0 sequences (100.0%) end of output.
Running: ora2pg -p -t TABLE -o table.sql -b ./schema/tables -c ./config/ora2pg.conf
[2023-10-04 13:28:52] [========================>] 16/16 tables (100.0%) end of scanning.
[2023-10-04 13:28:52] [========================>] 16/16 tables (100.0%) end of table export.
Running: ora2pg -p -t PACKAGE -o package.sql -b ./schema/packages -c ./config/ora2pg.conf
Action type PACKAGES is not available for MSSQL.
Aborting export...
Running: ora2pg -p -t VIEW -o view.sql -b ./schema/views -c ./config/ora2pg.conf
[2023-10-04 13:28:52] [========================>] 5/5 views (100.0%) end of output.
Running: ora2pg -p -t GRANT -o grant.sql -b ./schema/grants -c ./config/ora2pg.conf
WARNING: Exporting privilege as non DBA user is not allowed, see USER_GRANT
Running: ora2pg -p -t TRIGGER -o trigger.sql -b ./schema/triggers -c ./config/ora2pg.conf
[2023-10-04 13:28:53] [========================>] 0/0 triggers (100.0%) end of output.
Running: ora2pg -p -t FUNCTION -o function.sql -b ./schema/functions -c ./config/ora2pg.conf
[2023-10-04 13:28:53] [========================>] 0/0 functions (100.0%) end of functions export.
Running: ora2pg -p -t PROCEDURE -o procedure.sql -b ./schema/procedures -c ./config/ora2pg.conf
[2023-10-04 13:28:53] [========================>] 0/0 procedures (100.0%) end of procedures export.
Running: ora2pg -p -t TABLESPACE -o tablespace.sql -b ./schema/tablespaces -c ./config/ora2pg.conf
WARNING: Exporting tablespace as non DBA user is not allowed, see USER_GRANT
Running: ora2pg -p -t PARTITION -o partition.sql -b ./schema/partitions -c ./config/ora2pg.conf
[2023-10-04 13:28:53] [========================>] 0/0 partitions (100.0%) end of output.
Running: ora2pg -p -t TYPE -o type.sql -b ./schema/types -c ./config/ora2pg.conf
[2023-10-04 13:28:54] [========================>] 0/0 types (100.0%) end of output.
Running: ora2pg -p -t MVIEW -o mview.sql -b ./schema/mviews -c ./config/ora2pg.conf
[2023-10-04 13:28:54] [========================>] 0/0 materialized views (100.0%) end of output.
Running: ora2pg -p -t DBLINK -o dblink.sql -b ./schema/dblinks -c ./config/ora2pg.conf
[2023-10-04 13:28:54] [========================>] 0/0 dblink (100.0%) end of output.
Running: ora2pg -p -t SYNONYM -o synonym.sql -b ./schema/synonyms -c ./config/ora2pg.conf
[2023-10-04 13:28:54] [========================>] 0/0 synonyms (100.0%) end of output.
Running: ora2pg -p -t DIRECTORY -o directorie.sql -b ./schema/directories -c ./config/ora2pg.conf
[2023-10-04 13:28:54] [========================>] 0/0 directory (100.0%) end of output.
Running: ora2pg -t PACKAGE -o package.sql -b ./sources/packages -c ./config/ora2pg.conf
Action type PACKAGES is not available for MSSQL.
Aborting export...
Running: ora2pg -t VIEW -o view.sql -b ./sources/views -c ./config/ora2pg.conf
[2023-10-04 13:28:54] [========================>] 5/5 views (100.0%) end of output.
Running: ora2pg -t TRIGGER -o trigger.sql -b ./sources/triggers -c ./config/ora2pg.conf
[2023-10-04 13:28:55] [========================>] 0/0 triggers (100.0%) end of output.
Running: ora2pg -t FUNCTION -o function.sql -b ./sources/functions -c ./config/ora2pg.conf
[2023-10-04 13:28:55] [========================>] 0/0 functions (100.0%) end of functions export.
Running: ora2pg -t PROCEDURE -o procedure.sql -b ./sources/procedures -c ./config/ora2pg.conf
[2023-10-04 13:28:55] [========================>] 0/0 procedures (100.0%) end of procedures export.
Running: ora2pg -t PARTITION -o partition.sql -b ./sources/partitions -c ./config/ora2pg.conf
[2023-10-04 13:28:55] [========================>] 0/0 partitions (100.0%) end of output.
Running: ora2pg -t TYPE -o type.sql -b ./sources/types -c ./config/ora2pg.conf
[2023-10-04 13:28:55] [========================>] 0/0 types (100.0%) end of output.
Running: ora2pg -t MVIEW -o mview.sql -b ./sources/mviews -c ./config/ora2pg.conf
[2023-10-04 13:28:55] [========================>] 0/0 materialized views (100.0%) end of output.
To extract data use the following command:
ora2pg -t COPY -o data.sql -b ./data -c ./config/ora2pg.conf
I use the following DSN:
ORACLE_DSN dbi:ODBC:driver=msodbcsql18;server=localhost;database=sakila;TrustServerCertificate=Yes
With the following declaration in /etc/odbcinst.ini
[msodbcsql18]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.3.so.1.1
UsageCount=1
TrustServerCertificate=Yes
TrustCertificate=Yes
If this is something else, please report the errors.
from ora2pg.
bharanisvng
commented on June 30, 2024
whether all the bug or issues (specifically for ms sql server to postgresql ) reported in ora2pg ver 24.0 is fixed in ver 24.1 ??
from ora2pg.
bharanisvng
commented on June 30, 2024
weird issue with the simple command
ora2pg -t COPY -o data.sql -c "c:\0_free_pgm_files\ora2pg-24.1\mss_ora2pg.conf"
refer enclosed document for the pictorial snapshots
using MS Sql server 2019 with ora2pg ver 24.1
ver_1_1_bsv_laptop.docx
can you please guide on how to overcome the issue ?
from ora2pg.
bharanisvng
commented on June 30, 2024
please note , this suggestion already implemented.
from ora2pg.
bharanisvng
commented on June 30, 2024
output of sqlserver configuration manager
output #1
<img width="414" alt="image" src="https://github.com/darold/ora2pg/assets/126074951/6f44bcad-170a-4948-b0c4-7831eaac02bc">
[err.pdf](https://github.com/darold/ora2pg/files/12830372/err.pdf)
from ora2pg.
bharanisvng
commented on June 30, 2024
please note : i am not using any of the linux server. all are windows 11 based using my laptop
from ora2pg.
bharanisvng
commented on June 30, 2024
Darold - any update on my query ?
from ora2pg.
darold
commented on June 30, 2024
I have never tried MSSQL migration on a Microsoft OS so I can not help much more on this. Perhaps using a Linux distribution will be easier and actually it will be more efficient, on Windows you will not benefit of multiprocess for data export.
from ora2pg.
bharanisvng
commented on June 30, 2024
understood your input. thanks will attempt will linux distribution favor for MS SQL Server installation
from ora2pg.
bharanisvng
commented on June 30, 2024
and will update you. will follow your detailed steps on the linux front
from ora2pg.
Related Issues (20)
- ora2pg -c ora2pg.conf -t COPY -a tablename not working HOT 1
- Package name is shorter when referenced in CREATE TYPE HOT 4
- Package/Schema is missing in search_path HOT 1
- Unrecognized character in Ora2Pg/PLSQL.pm line 1237 HOT 1
- ORA-12505: TNS:listener does not currently know of SID given in connect descriptor HOT 2
- Problem with slow data migration speed. HOT 5
- Function JSON_ARRAYAGG does not get translated properly
- name of a column is a reserved word in postgresql HOT 3
- ORACLE_DSN doesnt recognized HOT 10
- bad table creation operator HOT 2
- There is no control for default values HOT 2
- Invalid timestamp format conversion HOT 2
- BLOB Migration Issue HOT 8
- is this tools supports mysql 8 default authentication as I want to migrate database from mysql v8 to postgres HOT 2
- SQL queries selecting NEXVAL from the sequence in the trigger are not translated HOT 1
- DROP_FKEY happens even during --oracle_speed, when >1 table HOT 2
- error message : Unmatched ( in regex; marked by <-- HERE in m/\bg_grsamt( HOT 3
- SQL Server 2014 does not provide sys.indexes.auto_created column HOT 1
- issue using ora2pg conversion to postgresql for objects referred with mdsys.geomerty (specifically related to shapefiles) HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ora2pg.