Can Flyway Desktop avoid comparing objects inside schemas that I haven't specified?
anthonym
Posts: 3 New member
Scenario:
* I'm using Flyway Desktop 7.6.0, in either "Schema model" or "Migrations" mode
* There is one Postgres DB function in our "insights" schema that uses a SQL BODY instead of PL/pgSQL.
* I've specified a bunch of DB schemas for the project, excluding that one schema: "insights"
* The DB comparison step fails with this error: "Error registering comparison sources -- The function my_sql_body_function() was declared using the sql_body form, which is not yet supported."
Question: Is there a way to tell Flyway Desktop to ignore that sql_body function in the "insights" schema, and only compare objects in the schemas that I've specified?
Tagged:
Answers
Hi Anthony,
Apologies for the issues you’re experiencing with Flyway Desktop.
Could you please:
If you’re not already using a filter, you’ll need to create one to define which objects Flyway should compare. You can create a filter file by following the steps outlined in the documentation for PostgreSQL filtering: PostgreSQL and MySQL Filtering Documentation.
Once you’ve set up the filter:
If the issue persists after applying the filter, please send over both the Log and TOML file, and we can investigate further.
Best,
Hassan
Product Support Engineer
Follow-up question: What does the "Schemas" list actually do in the "Connect to a target database" dialog? Does it not filter the schemas that are compared by the project?
I would like to exclude our entire "insights" schema, something like this: