FAQ

• I just want to Data Compare my selected tables and anything that is new. How can I do that?
  
  Firstly choose Table Selection and configure the project as Semi-Automatic in Settings and then only check Auto include newly discovered Tables & Columns plus Select All newly included tables ready for compare.
  This will only add table and columns that have been added to the schema since the last project edit. Table you excluded will be left excluded. Any new columns that can be compared will also be added to the compare.
  
  
• I have a lot of data in one table want to restrict the data to a smaller amount
  In the Table List within Table Selection click the filter icon  next to the table row you wish to filter. Then enter the source and/or target filter clause, basically a where clause without the where, and now your data will be filtered.
  
  
• I want to compare a column using a calculation but still display and copy the original data.
  Choose the table row in Table Selection and click Configure Columns to display the column list. On the source and target side there is the Convert column. Click the cell for the column to change and enter your formula. This can be any calculation support by the SELECT statement. In the top right corner of the convert box there is an option Only Compare. Check this option to use the formula for compare only and keep the original data for display and deployment.