Using mtsmaker without a database/query file

About this task

Schemas can be generated without using database/query files. However, you must specify all of the necessary information so that mtsmaker can generate the tree scripts for queries, tables, views, or stored procedures.

To generate a schema script file (.mts) for a query, specify the following mtsmaker parameters:

mtsmaker   -S "sql_select_statement"
   -Z database_adapter_type 
   [-U user_id]
   [-P password] 
   [-D {datasource|connect_string|server\\database}]
   -O mts_file_name 
   -F mtt_file_name
   -N type_name 
   [-X [F][O][T]]

To generate a schema script file for a table, view, or stored procedure, specify the following mtsmaker parameters:

mtsmaker   -T table_name|-G stored_procedure_name
   -Z database_adapter_type
   [-U user_id]
   [-P password] 
   [-D {datasource|connect_string|server\\database}]
   -O mts_file_name 
   -F mtt_file_name 
   [-X [F][O][T]]