You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Lots of legacy apps use Oracle as their source db. The source-mssql uses sqlcmd, source-oracle could use sqlplus which is available in the instant-client. MsSQLConnector uses pyodbc, OracleConnector could use cx_oracle or oracledb which may be preferred since its a light client and doesn't depend on the thick instant-client being installed.
Oracle has
all_tables and all_views for the tables(self) method
all_tab_columns for the columns(self) method
all_constraints and all_cons_columns for the foreign_keys(self) method
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Lots of legacy apps use Oracle as their source db. The source-mssql uses sqlcmd, source-oracle could use sqlplus which is available in the instant-client. MsSQLConnector uses pyodbc, OracleConnector could use cx_oracle or oracledb which may be preferred since its a light client and doesn't depend on the thick instant-client being installed.
Oracle has
Beta Was this translation helpful? Give feedback.
All reactions