Comparing Tables with Different Names
Comparing Tables with Different Names
We have two tables in the same server / database with different names (the attributes are identical). We use them to store system settings. Prior to our deployments, we move the rows from the settings table over to the settings_old table. Following our deployment, we would like to compare the 2 tables to see what's changed. Is this possible?
Thanks,
Doug
Thanks,
Doug
Re: Comparing Tables with Different Names
You can map the tables having different names and define comparison keys on the 'Mapping' page of the 'New Data Comparison' wizard. Please refer to the 'How To: Map Tables and Views' and 'How To: Map Columns' topics in the product's Help documentation for details.
Re: Comparing Tables with Different Names
How About schema comparison? There's no option for custom mapping when comparing schema only. Am I right?
Re: Comparing Tables with Different Names
In the Schema Compare feature, schemas are mapped automatically.
Re: Comparing Tables with Different Names
Exactly what I've found. Why is custom mapping of tables only available for data comparison. If tables have different names, then the names are different for both data and schema comparison. Makes no sense.
Auto mapping maps to exact same table names and has no option to define a different prefix for the tables.
Auto mapping maps to exact same table names and has no option to define a different prefix for the tables.
Re: Comparing Tables with Different Names
We will implement such a possibility in one of the next product versions.
Re: Comparing Tables with Different Names
That's great alexa, is it possible to receive a notification? Or is there another way to find out when the feature gets released?