Skip to content
← Flyway

How can we improve Flyway?

Flyway: Desktop

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Limit Static Data by rows using a WHERE clause

I would like the ability to source control a subset of rows in a table.

We have a table with extra rows in DEVELOPMENT for dev purposes ONLY. I don't want to track these in version control or deploy these.

16 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
AdminStephanie (Product Manager, Redgate) shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
AdminStephanie (Product Manager, Redgate) responded  · 

Currently, this is not available in the Flyway Desktop GUI. Flyway Enterprise ships with our Data Comparison technology for SQL Server and Oracle, so this can be done and automated as part of a pipeline. We've documented this at https://documentation.red-gate.com/display/FD/Tutorial+-+Using+Redgate%27s+Data+Compare+to+limit+rows and would love to discuss this with you.

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • simon whitworth commented  ·   ·  Report

    For the exact same reason as Stephanie, we would like the ability to source control a subset of rows in a table.

    We have a table with extra rows in DEVELOPMENT for dev purposes ONLY. I don't want to track these in version control or deploy these.