|
Database::ScriptObject |
||
| Description | ||
| Creates SQLserver sql-statements of existing tables, views, stored-procedures, functions, triggers and/or indexes. | ||
| Script Table | ||
 |
||
| Options | ||
| Server |
Name/address of the database-server. |
|
| Username |
Username for database connection. | |
| Password |
Password for database connection. | |
| Database |
Database name. | |
| Trusted
Connection |
When checked a trusted-connection is established with the database-server and no username & password is required. | |
| Persis
Security Info |
"When set to false (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values including the password. | |
| Table |
The table of which the sql-statement must be created. | |
| Variable
Name |
The name of the variable to which the statement will be saved. | |
| Only
create if table doesn't exist |
If enabled, the statement will include an "IF NOT EXIST ...." clause to only create the table if it doesn't exist. | |
| Include
"IF (NOT) EXIST..." |
If enabled, the statement will include an "IF (NOT) EXIST .... (DROP {table})" clause.. | |
| Script View | ||
 |
||
| Options | ||
| View |
The view of which the sql-statement must be created. | |
| Variable
Name |
The name of the variable to which the statement will be saved. | |
| Only
create if view doesn't exist |
If enabled, the statement will include an "IF NOT EXIST ...." clause to only create the view if it doesn't exist. | |
| Include
"IF (NOT) EXIST..." |
If enabled, the statement will include an "IF (NOT) EXIST .... (DROP {view})" clause.. | |
| Script Stored Procedure | ||
 |
||
| Options | ||
| SP
List |
The stored-procedure of which the sql-statement must be created. | |
| Variable
Name |
The name of the variable to which the statement will be saved. | |
| Script Function | ||
 |
||
| Options | ||
| Function |
The function of which the sql-statement must be created. | |
| Variable
Name |
The name of the variable to which the statement will be saved. | |
| Script Trigger | ||
 |
||
| Options | ||
| Trigger |
The trigger of which the sql-statement must be created. | |
| Variable
Name |
The name of the variable to which the statement will be saved. | |
| Script Index | ||
 |
||
| Options | ||
| Table |
The table that contains the index. | |
| Variable
Name |
The name of the variable to which the statement will be saved. | |
| Index
name filter |
Only indexes of which the name matches this regular expression will be included in the statement. | |