Unable to insert values in to a existing table even after identity insert is on

blue-yonder / turbodbc

Turbodbc is a Python module to access relational databases via the Open Database Connectivity (ODBC) interface. The module complies with the Python Database API Specification 2.0.

http://turbodbc.readthedocs.io/en/latest

MIT License

623 stars 85 forks source link

Unable to insert values in to a existing table even after identity insert is on #217

Open SangitapuSahithi opened 5 years ago

SangitapuSahithi commented 5 years ago

Hi,

When Iam trying to insert the data with turbodbc connection in to a table with identity , Iam facing the error "cannot insert explicit value for identity column in table 'table_name' when IDENTITY_INSERT is set to OFF even on explicit execute of IDENTITY_INSERT ON on the table Could you please look in to it ?

Regards, Sahithi

simhadrib commented 5 years ago

Hello,

I have similar problem , IDENTITY_INSERT ON and OFF works well with sqlalchemy however it is taking more time when we try to migrate a table with records more than 1 million. We tried to use turboodbc , however we are unable to migrate data with IDENTITY_INSERT ON and OFF configurations.

Our source and destination databases are MSSQL.

Thanks, Simhadri