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 <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.
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 > > <https://groups.google.com/d/msgid/sqlalchemy/bda43a6c-7d98-4aa7-ae8d-f8bbcae192a6n%40googlegroups.com?utm_medium=email&utm_source=footer>. -- 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.