SQL Library

The SQL Library is a perfect way to organize or share your SQL scripts. The SQL Library is a hierarchy of files and folders. You can add your script to the library using Windows explorer. You can also save the script from DTM SQL editor into SQL library.

To access SQL Library click arrow "From Library" button at the main task properties page.
Please note that this option is supported by Enterprise edition of the stress test tool only.

The default location of the library is "library" subdirectory in the product folder. For example, "C:\Program Files\DTM DB Stress\Library". You can change this value using settings dialog

The SQL script selected in the library can be saved using one of the following methods:

  • Insert - insert the file at the current cursor position.
  • Append - append the SQL file to the end of the script currently being edited.
  • Replace - replace the current script.

DTM Data Generator: SQL library usage