Comparing Tables with Different Names

[wimagine7]

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

[alexa]

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.

[rances]

How About schema comparison? There's no option for custom mapping when comparing schema only. Am I right?

[alexa]

In the Schema Compare feature, schemas are mapped automatically.

[rances]

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.

[alexa]

We will implement such a possibility in one of the next product versions.

[rances]

That's great alexa, is it possible to receive a notification? Or is there another way to find out when the feature gets released?

[alexa]

We will drop you a notification then.