Table Reflection Error

[Jeff Griffin]

Using sqlalchemy 1.4.5 and pymssql 2.1.5,  I am reflecting an Oracle Table from one database (Oracle) and attempting to create it in a second database (MS SQL Server).  On table.create I get the following error:

Compiler <sqlalchemy.dialects.mssql.base.MSTypeCompiler object at 0x.... can't render element of type NUMBER

Is there a way to deal with these type conversions so as to be able to create a comparible table in SQL Server?

Any pointers are appreciated.

[Mike Bayer]

we have explicit support for this use case now, please see https://docs.sqlalchemy.org/en/14/core/reflection.html#metadata-reflection-dbagnostic-types

--

SQLAlchemy -

The Python SQL Toolkit and Object Relational Mapper

 

http://www.sqlalchemy.org/

 

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description.

---

You received this message because you are subscribed to the Google Groups "sqlalchemy" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/bda43a6c-7d98-4aa7-ae8d-f8bbcae192a6n%40googlegroups.com.