Toad World® Forums

How to export settings selection

Hello,

I would like to know if there is a way to find or export the "Selection" of the different script generation to share it.

I attached a screenshot to show you the selections I would like to export.

Regards.

Hello,

If you have TDM 5.4, you can use Action Definitions:

  1. In the last dialog of Generate Change Script wizard or in DDL Script Generation dialog, click the Save Action button. You will be asked for a name and optionally a description. Enter whatever you want and Save.

  2. Go to Model Menu | Manage Model Actions. You should see your saved Action Definitons.

5224.Actions3.png

  1. Select one of them and then click on Save Action Definition to File button. Choose the file name and location. Then do the same for the other action.

8838.Actions4.png

  1. Now you can share the files with everyone. They only need to click on Load Action Definition from File button, find the appropriate files and import them. Once they’re done, just double-click the saved Action Definition to Run it. (An alternative is to click on Load Action button in the first dialog of Generation/Comparison/Report wizard and choose the desired Action Definition).

About Action Definitions: They are customized Model Actions (Generations, Comparisons, Reports…), where all your selections and settings are saved. You can learn more about them in the Application Help.

If you have TDM 5.3, you will be able to create Action Definition for Change Script, but not for DDL Script Generation.

Regards,

Lukas

Hello Lukas,

Thansk for your answer it’s perfect.

Regards.

Hello again,

I would like to know if there’s a way to export the templates too.

Regards.

Hello again.

Templates are by default stored in one file - Templates.txg, which is located in "_C:\Users*username*\Documents\Toad Data Modeler\Standard Installation #\Packages_". Just copy the package to the Standard Installation folder of any other TDM installation.

Another way to do this is to add your custom templates to a package of your choice and then export the package. Go to Settings | Templates, click the pencil icon of the desired template and set Package to any package.

This approach might be better, since you will be actually exporting only your custom templates. When you export Templates.txg, you also export all of the default templates, which may not be desired.

Regards,

Lukas

Thanks for the tips Lukas.

Regards.