Multiple tables found whose name matches this temporal table

johnatarchwellhealth

I received this error message when trying to pull changes to db.  The duplicate table has now been removed from db but Flyway still gives message.

johnatarchwellhealth

Full error msg FWIW: Error registering comparison sources: Multiple tables found whose name matches this temporal table: [payor_prod].[member]. Duplicates are: [payor_prod].[[member_history], [payor_prod].[member_history]

Jon_Kirkwood

Hi @johnatarchwellhealth

Thank you for reaching out on the Redgate forums regarding your multiple table error.

Glad you were able to resolve it by removing the table. Are you able to confirm how it was removed?

It may be possible that the table still exists within the schema history table if it was not removed per a migration through Flyway