I have very very big production Sybase DB. Currently we have custom script that is handling migrations for us.
We are going to introduce Liquibase or Flyway and check how it will work for us.
Firstly we decided to try with Flyway as it is simpler at first glance.
I was digging around but didn't find any usefull thing.
My question is: Is it possible to use Flyway withouth doing dump of current db? DB is very very big and we want to minimalise operational risk.
Yes, in general it is possible to do that. But unfortunatelly Sybase is not supported by Flyway and basically speaking is saying this clearly if you try to run it with sybase.
I will use liquibase.
There were some threads in Flyway github but Sybase support hasn't been released yet.