dbForge Data Compare - Setting tables to compare

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
cdunn66
Posts: 5
Joined: Mon 24 May 2021 05:02

dbForge Data Compare - Setting tables to compare

Post by cdunn66 » Thu 05 Aug 2021 03:23

Okay, my problem is that when I need to compare two schemas, I always need to reset the tables that I need to compare.

This is because my source database keeps changing as we need to spin up a new one per development branch and the application treats this as whole new comparison.

Given that we have over 300+ tables in each database this becomes a very tedious and error prone process to do each time.

Is there a way that I can specify to the application a list of the 50 or so reference tables only that I want compare each time?

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: dbForge Data Compare - Setting tables to compare

Post by dzhanhira » Tue 08 Feb 2022 11:25

Kindly note that table exclusions can be configured on the Options page (data comparison wizard): Include tables or views by mask Exclude tables or views by mask.

And on the Mapping page (data comparison wizard). Save the .dcomp file and change the database name in a text editor.
You can use Command Line.
Please, check our Documentation https://docs.devart.com/studio-for-mysql/

Post Reply