Working with the Sample Console Script Files (OracleToSQL)
A few sample files have been provided along with the product for the user reference and usage. This section describes the way to easily customize these scripts to fit the end user needs.
Sample Console Script Files
The following sample console script files covering different scenarios have been provided for user reference:
ServersConnectionFileSample.xml
VariableValueFileSample.xml
AssessmentReportGenerationSample.xml
SqlStatementConversionSample.xml
ConversionAndDataMigrationSample.xml
ServersConnectionFileSample.xml:
This sample gives the different modes of connection available to the source and target database and the user can select any mode as per the requirement. This sample contains the Server definitions.
The user can connect to the required database by simply changing the values to the required source and target server definitions. In the example provided all values have been provided as variable values which are available in the VariableValueFileSample.xml. All other connection parameters can be removed from the user's working server connection file.
For more information on connecting to the source and target server, see Creating the Server Connection Files (OracleToSQL) .
VariableValueFileSample.xml: All variables that have been used in the sample console script files and
ServersConnectionFileSample.xml
have been collated in this file. To execute the sample console scripts the user has to simply replace the sample variable values with user defined ones and pass this file as an additional command line argument along with the script file.For more information on Variable Value File, see Creating Variable Value Files (OracleToSQL).
AssessmentReportGenerationSample.xml: This sample enables the user to generate an xml assessment report which can be used by the user for analysis before he begins to convert and migrate data.
In the
generate-assessment-report
command the user has to mandatorily change the variable value (refer VariableValueFileSample.xml) in theobject-name
attribute to the database name being in use by the user. Depending on the kind of object specified, theobject-type
value will also have to be changed.If the user has to assess multiple objects / databases he can specify multiple
metabase-object
nodes as illustrated in thegenerate-assessment-report
command's Example 4 of the sample console script file.For more information on generating reports, see Generating Reports (OracleToSQL).
Note
- Ensure that the variable value file command line argument is passed to the console application and VariableValueFileSample.xml is updated with the user specified values.
- Ensure that server connection file command line argument is passed to the console application and the ServersConnectionFileSample.xml is updated with correct server parameter values.
SqlStatementConversionSample.xml:
This sample enables the user to generate the correspondingt-sql
script for the source databasesql
command provided as input.In the
convert-sql-statement
command the user has to mandatorily change the variable value (refer VariableValueFileSample.xml) in thecontext
attribute to the database name that is being in use by the user. The user will also be required to change thesql
attribute value to the source databasesql
command that he/she require to be converted.The user can also provide sql files to be converted. This has been illustrated in the
convert-sql-statement
command's Example 4 of the sample console script file.Note
Ensure that the variable value file command line argument is passed to the console application and VariableValueFileSample.xml is updated with the user specified values.
ConversionAndDataMigrationSample.xml:
This sample enables the user to perform an end to end migration from conversion to data migration. The list of mandatory attribute values that they will have to change is listed below:Command Name
map-schema
Schema mapping of source database to the target schema.
Attribute
source-schema:
Specifies the source database that requires to be converted.sql-server-schema
: Specifies the target database that is to be migrated to
Command Name
convert-schema
Performs schema conversion from source to the target schema.
If the user has to assess multiple objects / databases he can specify multiple
metabase-object
nodes as illustrated in theconvert-schema
command's Example 4 of the sample console script file.
Attribute
object-name
: Specify the source database / object name that requires to be converted. Ensure that the correspondingobject-type
is changed based on the type of object that is specified in theobject-name
Command Name
synchronize-target
Synchronizes the target objects with the target database.
If the user has to assess multiple objects / databases he can specify multiple
metabase-object
nodes as illustrated in thesynchronize-target
command's Example 3 of the sample console script file.
Attribute
object-name:
Specify the sql server database / object name that requires to be created. Ensure that the correspondingobject-type
is changed based on the type of object that is specified in theobject-name
Command Name
migrate-data
Migrates the source data to the target.
If the user has to assess multiple objects / databases he can specify multiple
metabase-object
nodes as illustrated in themigrate-data
command's Example 2 of the sample console script file.
Attribute
object-name:
Specifies the source database / tables name that requires to be migrated. Ensure that the correspondingobject-type
is changed based on the type of object that is specified in theobject-name
See Also
Creating Variable Value Files (OracleToSQL)
Creating the Server Connection Files (OracleToSQL)
Generating Reports (OracleToSQL)