Generate a set of test data, based on an identifying number, for columns with text and date identifiers?
Text columns use as much of the column name as possible concatenated with the TurboData start to end range. Dates use the default start date plus the number of days of the TurboData start to end range. This gives a range of unique test data.
Set up a different business case scenario for a set of tables within my database without overwriting the work I have done?
Create a new Insert Data scenario. Select the tables to work with for this scenario. The previous scenario will remain unchanged until you open it for editing.
Find out how many tables are in my database schema?
Go to Table Statistics. The total number of tables is given at the top of the dialog.
Print out my database schema?
Select Database Definition Report from the Database menu. When the report is displayed, slelect the Print option from your HTML viewer.
Exclude almost all the columns in a table without having to keep moving the mouse up and down to click from one object to another?
To prevent having to move the mouse pointer repeatedly up and down between the tree and the column details, use your mouse hand just for selecting the columns, and use your other hand to exclude them with Alt-X. (You can include them again with Alt-I).
Create test data for a DBMS that is not yet supported by TurboData?
Set up a DSN to the database. Read in the database schema after selecting Other DBMS and ODBC on the New Database Connection dialog. When you want to create test data go to the Generate dialog, and select a compatible DBMS from the drop down list that will create the SQL in a syntax that your database can use.
