Two 'little helpers', straight forward and efficient, let you explore structures and data of both source and destination database. Execute common SQL statements by selecting statements and table names by mouse click from the SQL Wizard and transferring both to the SQL Console. Display the result set in the SQL Console window.

click to enlarge
Start the SQL Wizard from the DBtrans Source or Destination menu and display all columns of the selected table including type, length, scale, null and primary key.
click to enlarge
Select columns and an SQL statement and an alias name (optional). The SQL wizard inserts table name and columns (including alias) into the statement and copies it to the clipboard.
click to enlarge


Paste and execute the SQL statement and display the result data set.