Before you start the conversion process, you can set conversion settings for data types.

1. Enable Expert mode: Select Settings | Options | General | check the Expert Mode checkbox.
2. From the main menu, select Expert Mode | Expert Mode Settings | Data Type Conversion Settings.

3. In the Source and Destination boxes choose the desired databases.
4. Press to display available data types. Click to view only exceptions.

You can see a list of data types of source model that will be converted to data types in destination model.

Example: Oracle Blob data type will be converted to Microsoft SQL Server 2012 model as Image data type. You can change the destination model data type.

Note: The modified database conversion settings are saved to DataTypeConversion.txn file stored by default in: C:\Users\*username*\AppData\Roaming\Quest Software\Toad Data Modeler\*Installation name*\Configs. If you want to restore the original conversion settings, you can simply delete this .txn file.

5. Confirm OK.

Execute Script

If you want to use your own script for data type conversion, click the Go to Exception Script button. A dialog offer you to create a new script. Confirm and the newly created script will be shown in Script Editor, where you can edit it as you like.

Example:

function Convert(){

  var Log = System.CreateObject('Log');

  Log.Information('Konverze');

  Log.Information('Input MD: '+ InputModelDef.Abbrev );

  Log.Information('Output MD: '+ OutputModelDef.Abbrev );

  

  Log.Information(InputDataType.ConversionID.Code);

         

  var outDT                                     

  if (InputDataType.ConversionID.Code == 'C_X'){

   Log.Information('HERE');

    for( i = 0; i < OutputDataTypes.Count; i++ )

    {

      outDT = OutputDataTypes.GetObject( i );

      Log.Information( outDT.Name );

      if (outDT.Name=='Box') {

        return(i);

      }

    }

  }  

  

  return(0);

}