WhereScape RED provides a generic unload utility for backing up the metadata. The advantage of this backup is that it is database, and database version independent. It can be used to backup the metadata regardless of the version of the database client running on the PC. It is possible to transport the metadata from one database platform to another using unload and load. For example, the metadata from a SQL Server unload can be loaded into an Oracle database.
After performing a cross platform unload and load:
- Transformations must be altered manually to use the correct syntax for the new database.
- Generated procedures regenerated.
- Modified and custom procedures must be changed to use the procedure language of the new database platform.
Performing an Unload
An unload can be performed within the WhereScape RED tool by selecting the Backup > Unload the Metadata to Disk menu option.
A popup window asks for confirmation to proceed with the unload. Click Yes.
An additional pop-up window asks for the folder where the metadata will be exported. Select a directory and then click Save.
Enter a comment for the unload and click OK.
Finally, click Yes or No on the include version history dialog:
This either includes or excludes version history metadata in the unload.
The unload starts and a progress bar is displayed to show the status.