Splice and Dice Data
Good for simple situations where you are upgrading from a clean source database that just contains “day one” static data in purely lookup tables, i.e. tables where the data is static and controlled by you. Examples might be tables like CustomerType, Salutation or CountryCode. In this mode any table in the source that has data will be compared, all columns and all rows. The following overall options control how those tables will be processed:
• Check for missing data to insert in the target
• Check for extra data to delete in the target
• Check for different data to update in the target
• Disable FKs
• Fire Triggers
Grid Selection Mode
In this mode you can control the data compare and upgrade in great detail. The overall options now enable detail columns in the grid allowing you to control each option per table.
You can individually select tables or use the various selection link options.
• Select All
• Select All in Source with data
• Select All in Target with data
Use the columns button to select specific colums in a table. If you are not using all columns in a table then the upgrade must be told what to do if it needs to insert a row in that table. i.e. what to do about the columns that are not compared. The options are to exclude the columns from the insert statement or use the value from the source table. Excluding the column from the insert statement will cause the default, if there is one, for the column or null.
You can enter a statement for the where clause. NB. The where key word not needed.
1/ For data compare to be efficient the table needs a PK or unique key.
2/ In automatic mode the detail in table grid is ignored.
All these options can also be controlled using the settings file. As always, the best way to learn the settings is to use the GUI to create a template settings file and modify it if you need to.
If you have the Automation toolkit and are programming your own apps, there are the new public interfaces to support this in the API.