Multiple tables found whose name matches this temporal table

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.


  • Options
    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]
  • Options
    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

    Jon Kirkwood | Technical Support Engineer | Redgate Software

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file