Re: [sqlalchemy] Table Reflection Error

[Mike Bayer]

On Fri, Apr 23, 2021, at 5:38 PM, Jeff Griffin wrote:
> 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  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.

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+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/sqlalchemy/bda43a6c-7d98-4aa7-ae8d-f8bbcae192a6n%40googlegroups.com
>  
> .

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/947ae7ae-4314-4a32-9fcb-4bbf8bd622b5%40www.fastmail.com.

[sqlalchemy] 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 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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/bda43a6c-7d98-4aa7-ae8d-f8bbcae192a6n%40googlegroups.com.