Partial Data Comparison and Syncronization

In partial data comparison and synchronization, the goal is to compare exactly what you need and just a subset of the entire database, at the same time to fully control on a database record level, which rows should be inserted, updated or deleted. DBTYP.NET Studio brings this feature, highly improving performances, and helps you to focus on the most important objects to you. There are two types of partial data comparisons: early, tables and columns selection and where filtering, and late, rows synchronization selection.

Tables and Columns Selection

This feature allows you to early define which tables you want to be compared and for each table which rows. On the sample below, we decided to compare just 3 tables out of the whole database: Customers, Employees and Products but, as you can see, we do not want to compare all columns on Employees table and those columns which we don't want to compare and synchronize are checked off.

Rows Synchronization Selection

After comparing , DBTYP.NET Studio allows you to control which rows need to be synchronized. Initially, all rows are selected, but you can exclude these which you don't need to be synchronized.
Please note, that such a defined comparsion you can save as new or add to an existing project. For details, take a look at Project Management

WHERE Data Filtering