How to get MySQL Stored Procedures using GeneratechangeLog

General Discussion
1

I am trying to generatechangelog for my procedures in mysql 5.7, doc says the below command but this is not working, anyone facing the same issue? please help.

--diffTypes=storedprocedures

Thanks in Advance.

2

Hi @adarshg2

Are you using Liquibase Open Source?

The documentation here hints that it might be a Pro edition option only under the section titled “Additional functionality with Liquibase Pro”.

Though the --diffTypes parameter list mentioned above this section lists the Stored Procedure option as well, I am not sure about it. The documentation on generateChangeLog is not completely clear if Liquibase Open Source supports capturing Stored Logic (i.e. stored procedures, functions, triggers, etc.) or not.

Hope this helps.

Thanks,
Rakhi Agrawal