Return
-
Title
Data Compare OK and Cancel buttons missing in Select :Columns for Comparison windiow -
Description
When comparing two tables that don't have a primary or unique key, it is needed to define the comparison key by selecting the column(s) to be compared. In TDP 5.6, the OK and Cancel buttons are missing in this window.
Steps to reproduce – identical regardless of database flavour (Oracle, MSSQL, PostgreSQL –whatever), except perhaps data type syntax. This example is for Oracle.1. Create a table WITHOUT a primary or unique key. Minimum of columns are necessary.Example:Create table test1 (c1 number, c2 varchar2(10));2. Either create the same table in another database, or create a second one with a differentname in the same database. I did the latter: created the table test2.Create table test1 (c1 number, c2 varchar2(10));3. Open TDP 5.64.Run Data Compare (Tools | Compare | Data Compare) and connect to your database(s).5.Select the newly created tables (test1 for source and test2 for target). You will see a redindicator telling you that a comparison key can’t be selected (because there is no PK or UK6.Click on the field with the red indicator (“Columns Mapped”) in order to determine thecolumns for the comparison key. Notice there are not “OK” and “Cancel” buttons in the lower right-hand corner so it is not possible to save the changes
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.