Re: [sqlalchemy] Does alembic support multiple databases?

2022-05-13 Thread Simon King
There are a few possibilities. You could have separate configuration files for each database (eg. alembic-dev.ini and alembic-prod.ini), and choose between them with the "--config" command line option. If you want to stick to a single configuration file, you could put both connection strings in yo

Re: [sqlalchemy] Does alembic support multiple databases?

2022-05-09 Thread thavha tsiwana
wondering if there is more clearer information or a code snippet for this, I am also struggling to use 2 databases (1 dev, 1 prod) in my alembic project, I have successfully ran the migrations on the dev database, now I want to run my migrations to the prod database, I have no idea on how to mo

Re: [sqlalchemy] Does alembic support multiple databases?

2022-02-01 Thread Ruslan Skira
If you have git example, share, please. On Monday, 30 April 2012 at 04:10:14 UTC+3 limodou wrote: > On Sun, Apr 29, 2012 at 11:13 PM, Michael Bayer > wrote: > > > > On Apr 29, 2012, at 10:56 AM, limodou wrote: > > > >> On Sun, Apr 29, 2012 at 10:42 PM, Michael Bayer > >> wrote: > >>> You would a

Re: [sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread limodou
On Sun, Apr 29, 2012 at 11:13 PM, Michael Bayer wrote: > > On Apr 29, 2012, at 10:56 AM, limodou wrote: > >> On Sun, Apr 29, 2012 at 10:42 PM, Michael Bayer >> wrote: >>> You would assemble a multi-database scheme of your choosing in env.py.   If >>> you do "alembic init multidb" you'll see an e

Re: [sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread Michael Bayer
On Apr 29, 2012, at 10:56 AM, limodou wrote: > On Sun, Apr 29, 2012 at 10:42 PM, Michael Bayer > wrote: >> You would assemble a multi-database scheme of your choosing in env.py. If >> you do "alembic init multidb" you'll see an example of one. How env.py >> is organized depends greatly o

Re: [sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread limodou
On Sun, Apr 29, 2012 at 10:56 PM, limodou wrote: > On Sun, Apr 29, 2012 at 10:42 PM, Michael Bayer > wrote: >> You would assemble a multi-database scheme of your choosing in env.py.   If >> you do "alembic init multidb" you'll see an example of one.     How env.py >> is organized depends greatl

Re: [sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread limodou
On Sun, Apr 29, 2012 at 10:42 PM, Michael Bayer wrote: > You would assemble a multi-database scheme of your choosing in env.py.   If > you do "alembic init multidb" you'll see an example of one.     How env.py is > organized depends greatly on the relationship of the databases to each other, >

Re: [sqlalchemy] Does alembic support multiple databases?

2012-04-29 Thread Michael Bayer
You would assemble a multi-database scheme of your choosing in env.py. If you do "alembic init multidb" you'll see an example of one. How env.py is organized depends greatly on the relationship of the databases to each other, that is, to what degree they are mirrors of each other versus st