Re: selective migration options (e.g. create and add only)

2017-06-12 Thread mike bayer
not sure would need to see an example of the "CREATE TABLE" for one of the tables here and I can test a correct metadata structure to see if round trip comes out the same. On 06/12/2017 03:48 PM, kt...@spci.ca wrote: Thx Michael, Sorry about being not clear, You care right, I am using autoge

Re: selective migration options (e.g. create and add only)

2017-06-12 Thread ktang
Thx Michael, Sorry about being not clear, You care right, I am using autogenerate. I read the doc, I think that's what I am looking for. Thanks. for the missing auto inrement, I found whenever there are multiple primary key (foreign or not), the created tables are different. case 1: 1 primary

Re: selective migration options (e.g. create and add only)

2017-06-09 Thread Michael Bayer
On Friday, June 9, 2017 at 9:00:00 AM UTC-4, ktang wrote: > > Hi, > > I have an application migrating existing mysql dbs which may have tables > only in some system. > I am trying to use alembic to handle the migration. > > When I migrate the db to a newer version, if I don't want to drop any >

selective migration options (e.g. create and add only)

2017-06-09 Thread ktang
Hi, I have an application migrating existing mysql dbs which may have tables only in some system. I am trying to use alembic to handle the migration. When I migrate the db to a newer version, if I don't want to drop any existing tables or columns, how can I do this (just adding stuff)? And a m