My company is a software company. Therefore, we need to constantly test the db scripts against various versions of databases. In my db upgrade test, I used the scripts to create a V2 database and upgrade a V1 database to V2, and then use SQL Data Compare to compare reference data in these 2 databases. In our system, all tables has a column 'trans_id'. All DML operations require a new trans_id and this trans_id is obtained at runtime. Therefore, the same records being added may have attached with different trans_id. So, even the records do not have change on columns except 'trans_id', the SQL Data Compare would show these records in comparison report.
By using current version of SQL Data Compare, for each new database, I can only set filter to exclude columns at table-level manually. For each new comparison, I would need to do this for approximately 60-80 tables each time, no fun to do this. therefore,I like a future version of SQL Data Compare allows me to set a global filter to exclude the column(s)
My company is a software company. Therefore, we need to constantly test the db scripts against various versions of databases. In my db upgrade test, I used the scripts to create a V2 database and upgrade a V1 database to V2, and then use SQL Data Compare to compare reference data in these 2 databases. In our system, all tables has a column 'trans_id'. All DML operations require a new trans_id and this trans_id is obtained at runtime. Therefore, the same records being added may have attached with different trans_id. So, even the records do not have change on columns except 'trans_id', the SQL Data Compare would show these records in comparison report.
By using current version of SQL Data Compare, for each new database, I can only set filter to exclude columns at table-level manually. For each new comparison, I would need to do this for approximately 60-80 tables each time, no fun to do this. therefore,I like a future version of SQL Data Compare allows me to set a global filter to exclude the column(s)