Migrate columns from Oracle to MsSql

mkleehammer / pyodbc

Python ODBC bridge

https://github.com/mkleehammer/pyodbc/wiki

MIT No Attribution

2.92k stars 561 forks source link

Migrate columns from Oracle to MsSql #1138

Closed rmartinsdesouza closed 1 year ago

rmartinsdesouza commented 1 year ago

Environment

Python: 3.9.13
pyodbc:
OS: Windows
DB: Oracle, MsSql
driver:

Issue

I need migrate columns from Oracle to MsSql, but i do know make compare data type. I think transform and change ALTER TABLE TAB_ORIGIM_ORACLE ADD TYPE_ORACLE DEFAULT NULL to ALTER TABLE TAB_DESTINATION_MSSQL ADD TYPE_MSSQL DEFAULT NULL

gordthompson commented 1 year ago

This is not really a question specific to pyodbc.