[sqlalchemy] MemoryError in VSCode using dtype NVARCHAR(None) for SQL Server NVARCHAR(max)

Hello, I am moving an Oracle Database to SQL Server. I go through the table columns and create a dictionary of columnName: sqlalchemy.types. and then push them to SQL Server using df.to_sql. Most tables work fine except when I have a large VARCHAR2 from Oracle of 8000+ I need it to become a

[sqlalchemy] OverflowError: int to big to convert

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