search

janripke / noora

NoOra is a database deployment tool which can be used to automate the database deployment cycle and is designed for agile and or devops teams. The supported database platforms are Mysql, Postgresql Mssql and Oracle
Apache License 2.0
17 stars 5 forks source link

Feature request: schema/table option #2

Open sertaco opened 6 years ago

sertaco commented 6 years ago

Hi Jan,

I think we cannot selectively recreate dbs at the moment. It might be a good extension

arnicvs commented 5 years ago

Could you elaborate on this? I've actually been working to remove support around this, based on the fact that there is only one application properties table for a project, and all objects inside the project should always be at the same version. If this is an issue, we should discuss how to deal with this.

sertaco commented 5 years ago

Hi Niels, I think we are talking about different things. The feature request I raised here refers to the situation when you have multiple databases in Noora configuration (myproject.json). for example as follows: { "databases": [db_a, db_b, db_c],...}

In this case it would be handy to have a switch in "mynoora recreate" command such as this: mynoora recreate -h my-host-endpoint -d [db_a, db_b] to recreate only db_a and db_b

arnicvs commented 5 years ago

Yeah that's what I'm talking about. It should not be possible to be able to make changes to individual databases inside a project, because the version of your project affects all databases inside the project.

So, inside a specific environment, all databases should always have the same version, and as such you don't want to be able to for example recreate only specific databases, because that's going to mess up your versioning.

If I'm still interpreting it wrong, maybe Jan can explain it to me. :)

sertaco commented 5 years ago

You are right if you are releasing your code into production. My use case is for development when I am tweaking certain tables for example

On 6 May 2019 Mon at 11:59 Niels Roosen notifications@github.com wrote:

Yeah that's what I'm talking about. It should not be possible to be able to make changes to individual databases inside a project, because the version of your project affects all databases inside the project.

So, inside a specific environment, all databases should always have the same version, and as such you don't want to be able to for example recreate only specific databases, because that's going to mess up your versioning.

If I'm still interpreting it wrong, maybe Jan can explain it to me. :)

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/janripke/noora/issues/2#issuecomment-489568327, or mute the thread https://github.com/notifications/unsubscribe-auth/AAM52W77WQKBG2OJVM3FUEDPT76PRANCNFSM4GBYMHUA .

-- Kind regards, Sertaç