Re: [sqlalchemy] OverflowError: int to big to convert

2020-11-09 Thread Mike Bayer
that error is thrown by SQL Server and/or the ODBC driver you are using. make sure you are using an appropriate datatype for the column in the database. You can likely get more help on the pyodbc issue tracker at https://github.com/mkleehammer/pyodbc/issues as SQLAlchemy just passes these

[sqlalchemy] OverflowError: int to big to convert

2020-11-09 Thread J Sherwood
Hello, I am trying to transfer an Oracle Database(12) to an SQL database(2016) table by table. I read it from the Oracle database using: *ocon = cx_Oracle.connect(username,password,dsn,encoding='UTF-8') df = pd.read_sql("SELECT * FROM TABLE",con=ocon) * I then try to write the dataframe to the