You can start Toad Data Modeler from command line and add additional parameters to make it perform various tasks on startup:
Open-File -File:"Name=*Path to file*"[,Name=<string>]*
Open-File -File:Name=”*Path to file*”
TIP: You can include more than one parameters. Use comma (,) to separate multiple parameters. See examples for more information.
The following command opens a model called Videorental.txp:
TDM.exe Open-File -File:Name="C:\Models\Videorental.txp"
The following command opens two models at once:
TDM.exe Open-File -File:Name="C:\Models\Videorental.txp", Name="C:\Program Files (x86)\Quest Software \Toad Data Modeler - Beta\Samples\Employee.txl"
New-Model -ModelType:"*model type*"[ -ModelName:"*model name*"]
Creates a new logical model with default name:
TDM.exe New-Model -ModelType:"Logical Model"
Creates Oracle 10g model with the specified name:
TDM.exe New-Model -ModelType:"Oracle 10g" -ModelName:"My Physical Model"
Executes script stored in the application. First parameter is ScriptName (name of the script), second is MethodName(name of the method in script) and the following parameters (Par1Name, Par2Name...) will be passed as parameters to the script method.
Execute-Script -Parameter:ScriptName="*script name*",MethodName="*method name in script*"[,Par1Name=Par1Value, Par2Name=Par2Value...] -TDM [-Silent]
TDM.exe Execute-Script -Parameter:ScriptName=MyScript,MethodName=MyMethod,Par1Name="ABC",Par2Name="DEF" -TDM -Silent
-TDM: The executed script is stored in Toad Data Modeler.
-Silent: Script will be executed in Silent mode and you will be able to work with the application regardless the state of the executed script.
Writes messages to log. May be useful for sending reports to TDM developers.
TDM.exe Import-ToadForOracleERD -file:"NopathMovERD.erd"
TDM.exe Import-ToadForOracleERD -file:NopatMovERD.erd -Connection:"SERVER=OstDbServer:1521/ORCL, USER=movies,PROTOCOL=TNS,CONNECTAS=NORMAL,SAVEPASSWORD=1,ORACLEHOME=c:\oracle\product\10.2.0\db_1,HOST=OstDbServer,SErVICENAME=ORCL, PORT=1521,LDAP=,METHOD=1"
Note: To set the size of a step to move, select Settings | Options | Graphics | Move Objects by (mm/10) (in tenths of millimeters).
(The larger your model is, the more significant difference in speed you will notice.)
(Frameless report layout is not recommended as it uses Java script that goes through all objects, which takes too much time if your model is large.)
Toad Data Modeler and Toad for Oracle products have started the integration process.
Toad for Oracle® is a powerful application development tool built around an advanced SQL - PL/SQL editor. Using Toad, you can build and test scripts, PL/SQL packages, procedures, triggers, and functions. You can create and edit database tables, views, indexes, constraints, and users. The Schema Browser and Project Manager provide quick access to database objects.
Toad’s Editor provides an easy and efficient way to write and test scripts and queries, and its powerful data grids provide an easy way to view and edit Oracle data. With the optional DB Admin module you can manage space, compare schemas, monitor database performance, create new databases, maintain redo logs, perform health checks, and much more.
Toad for Oracle Integration in Toad Data Modeler
Select Settings | Options | Toad for Oracle Integration.
Toad Data Modeler recognizes Toad for Oracle connections and displays them in the: