Using python query oracle database, save the results to the MSSQL (new table), how should do?
My approach is to use pandas, tosql, but efficiency is too low,
, according to the online use pyODBC fast_executemany accelerate pandas. DataFrame. To_sql, there is an error: "(pyODBC. Error) [hy090] [misrosoft] [odbc driver for SQL server 13] invalid string or buffer length (0) (sqlexecute)"