What's the use pattern for shared database

FanGuogang

Hi, I am new to flyway.

We are using following branching model:

1. main
2. uat
3. sit
4. dev
5. feature_1
6. feature_2
7. feature_...

while all feature branches share one database instance for development...because it's heavy to setup.

how to distribute database migration file versions between feature branches ?

I am sorry for my poor English...best wishes to you.

Peter_Laws

Hello FanGuogang, welcome!

Your English is great and thank you for the question.
If I understand correctly, your goal is to minimise the amount of script duplication across branches?

Phil_Factor

Each feature branch will need its own migration files starting with a baseline file that represents the database at the point of branching. You can use the same instance for each feature as long as there is no overlap. This means they cannot alter  each other's tables and so on. It's not ideal, but we've all worked that way in the past.
Come back and ask if I haven't made myself clear!