dbForge Fusion
dbForege Fusion has no commandline support for generating change scripts during the build which is critical to automation.
It is critical for upgrades I'm able to do this on the build server
- Deploy a versioned release of the database
- Create a change script via command line
- Deploy the script for verification
- Include the change script for every release in our installer This way we can upgrade from any database we released to the latest.
(I have this working with Visual Studio & SQL Server but we need MySQL)
DBForge Studio for MySQL would work except it has not source code integration. Both products together contain all features that should be in one product.
This is technically not possible for Fusions.
-
Clint commented
The ability to do CI/CD is critical to our business. It's a shame this is not a feature added. It would have been nice to give devart a few thousand to license this app.
-
Craig Brunetti commented
Agreed, this response is sort of ridiculous. Forget an MSBUILD-capable plugin, which this is not, the inability to compile these database projects from command-line by neither Fusion nor Studio really leaves this product behind the modern Agile methodology, in which CI is key.
There are two straight-forward solutions to this:
1) Add to dbForge Studio a command-line way to compile these projects, or
2) Create a separate executable, paired with an MSBUILD-oriented project and customization, that would allow MSBUILD to invoke the compile on a headless environmentHonestly, this lack of desire to integrate with people's CI will keep me from purchasing licenses. This is nonsense.
-
David Angel commented
How can this not be technically possible your "what's new in dbForge Fusion for SQL Server" says you are doing it for SQL Server.
Could we get the same command line interface for MySQL fusion?
http://www.devart.com/dbforge/sql/fusion/whatsnew.html -
David Angel commented
Even if it isn't possible to do this via Visual Studio commandline at least you could give us a commandline utility that gave us the ability.
Without commandline support there is no chance for automation which makes the tool useless for any enterprise level development. :(