Hello,

I'm currently looking into available tools to perform DDL and DML comparison from the command line for an automation project of database continuous delivery. So besides a tool running from the command line it also needs to be able to generate the necessary scripts.
After a day of playing around with both dbForge schema and data compare, everything is looking fine and they seem to be good candidates for this project.
Unfortunately I'm currently stuck with one challenge. As the comparison phase is only done once, in the beginning of the automation chain, the generated scripts need to be portable. Having a look at the resulting files they could do the job if I could get rid of the USE <DATABASE> related statements.
Other comparison ools (Redgate, idera, ..) that I'm investigating have provided a toggle option for this when generating the scripts. Moreover from my development experiences this should be rather a quick win :-).

Cheers and happy voting

Björn