Could you please make it possible to compare tables with different tablenames?
This should be applied to all tools.
I do believe this is possible in the SQL Server-tools.9 votes
We frequently bring data from production databases to staging and development environments, it involves around 120 tables , but to start with we want to pick 3 or 4 huge tables(rows ~ 3 million) and see how much time it will take to do data comparison and deploy differences, instead of copying down entire tables.Also please see if you can develop the functionality of selecting a list of tables for comparison before registering entire databases.5 votes
I would prefer if the generated script would use insert/update/delete commands for each records instead of execute immediate.3 votes
When generating a deployment script in Schema Compare for Oracle you have the option to 'Exclude schema names in the deployment script'. Please could we have the same functionality in Data Compare for Oracle. This would be very useful when applying the script to different schemas.2 votes
- Don't see your idea?