here is the code I am using to copy the database:
engine_src = create_engine('mssql://blah_blah_blah)
engine_dst = create_engine('sqlite:///new.sqlite')
metadata_src = MetaData(bind=engine_src,reflect=True)
metadata_dst = MetaData(bind=engine_dst)
for table in metadata_src.sorted_tables:
dest_table = table.tometadata(metadata_dst)
dest_table.create()
#or, use metadata_dst.create_all() here, without create() for each
table
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
