Question: Can the dbschema app functionality can be accessed via cli

wise-coders / dbschema

DbSchema Database Designer

https://dbschema.com

67 stars 3 forks source link

Question: Can the dbschema app functionality can be accessed via cli #61

Closed ghost closed 2 years ago

ghost commented 2 years ago

Hi, thank you very much for a great product! We are looking to automate our database versioning, which looking at the app can mostly be done manually via the application.

Is it possible to replicate the same within an environment such as Azure Pipelines, where no UI is available.

The workflow in example:

Generate model from an SQL file.
Compare that model against an existing database
Generate an SQL script to match the two databases.

wise-coders commented 2 years ago

Please check the Help / Automation Scripts dialog. The steps you included here are scripted in there. If more assistance is needed, please write back and I will help.

ghost commented 2 years ago

@wise-coders

Hi, I tried downloading the linux distribution from https://dbschema.com/download/DbSchema_unix_8_5_2.tar.gz. and I created a simple script: out.println("Hello worlds"), but after running: ./DbSchema -x ./sync.groovy there is no output

wise-coders commented 2 years ago

You are right, this is an issue. We will fix this in the next minor release.

ghost commented 2 years ago

Thanks so much for your responses! Do you have an idea of how long it might take for the next release? A month, two weeks, etc.

wise-coders commented 2 years ago

Two weeks cca. We may have a beta version ready in 1 week, please ask me again later and I will send you the link.

ghost commented 2 years ago

Hello, I'd like to test the beta version if it's ready :)

wise-coders commented 2 years ago

Today the beta is ready: https://dbschema.com/beta.php The version number is the same, the build number is higher.

ghost commented 2 years ago

The functionality is now working, I'm closing the issue