@rioka Thanks for reaching out and apologies for the delay... Summer time in EU :). Its our backlog to write up a documentation for baselining existing database. Hmmm, I think what you can do is to create v0.00 with just simple script like init.sql and a --This is baseline database version statement. Execute this in your staging and production. This will establish the needed tracking tables in the database. Then you can add all the baseline script files in v0.00 and execute first time in dev and test. This enable you to hold all baseline scripts in v0.00 and get skipped in staging and production.
This is still hackish or work around. Sounds like yuniql rebase which is what we need here...
@rioka Thanks for reaching out and apologies for the delay... Summer time in EU :). Its our backlog to write up a documentation for baselining existing database. Hmmm, I think what you can do is to create
v0.00with just simple script likeinit.sqland a--This is baseline database versionstatement. Execute this in your staging and production. This will establish the needed tracking tables in the database. Then you can add all the baseline script files inv0.00and execute first time in dev and test. This enable you to hold all baseline scripts inv0.00and get skipped in staging and production.This is still hackish or work around. Sounds like
yuniql rebasewhich is what we need here...Originally posted by @rdagumampan in https://github.com/rdagumampan/yuniql/issues/280#issuecomment-1217053198