Add Data files or Log files
Description
The plugin is designed to add Data file or Log file in MSSQL server database.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection: | ||
| 2 | Server Name | The IP address of remote machine on which SQL server instance is present should be given. This field is mandatory. |
| 3 | Instance Name | The instance name of the MSSQL server should be provided. If we provide Instance name, Port number field will get disabled. Either Port or Instance Name is mandatory. |
| 4 | Port | The port number of the MSSQL server should be provided. If we provide Port number,there is no need to provide Instance name. Port number should only be an integer. Port number field is disabled if an instance name is entered.Either Port or Instance Name is mandatory. |
| 5 | User Name | The username of MSSQL server to authenticate. |
| Password: | ||
| 6 | Checkbox: Accept Value as variable/static | Leave checkbox unchecked to accept Password value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Password field to appear as Text box. |
| 7 | Password | The Password to the username to authenticate. Validate username and password to authenticate to SQL server instance. Password is entered using a widget. The widget handles both Text Var(static value or environment variable) and Combo(drop down containing values from previous steps). This field is mandatory. If checkbox above is enabled Password field appears as Text box. Else if checkbox above is disabled Password field appears as a drop down to select fields from previous steps. |
| 8 | Other Connection Parameter | Specify multiple, semi-colon separated parameters other than the default connection parameters. Other connection parameters will be appended to the default connection parameters. Example of default connection parameters: Server Name, Password.Examples of other connection parameters: encrypt=false;trustServerCertificate=false |
| Button: | ||
| 9 | Test Connection | Verifies whether the connection is established or not. NOTE: Test Connection button does not work for Previous step fields. Test Connection button only works with static values and environment variables. |
| Input Fields: | ||
| 1 | Database Name | Name of the Database on which the datafile/log file is to be created or Select from the list populated by clicking Get Database Button. This field is mandatory. |
| 2 | Button: Get database | Populates the list of database from the connected Instance. |
| 3 | Logical Name | Logical name of the data file or log file that is to be created. This field is mandatory. |
| 4 | File Type | Acceptable values are Rows Data or Log. When value is Rows Data, a datafile will be created and when value is Log, log file is created. This field is mandatory. |
| 5 | File Group | Name of the file group for the File Type(Ex: Primary is the file group for Rows Data file type) |
| 6 | Button: Get File Group | Populates the list of file groups from the selected database. |
| 7 | Initial Size(in MB) | Size of the file should be mentioned in MB. This field is mandatory. |
| 8 | Folder Path | Specify the browsed folder path to create the file. This field is mandatory. |
| 9 | Button: Browse | Browse the folder path where the file needs to be created. |
| 10 | File Name | Specify the physical name of the data file or log file. This field is mandatory. |
| NOTE: | Get Database, Get File Group and Browse button do not work for previous step variables. All the buttons work only with static values and environment variables. | |
| Autogrowth Fields: | ||
| 1 | Enable Autogrowth | Acceptable values are “Yes” or “No”. These are visible when you hover over the field. When value is Yes, it is considered that you want to enable autogrowth for the file. If No is selected any entries made in the fields below is ignored. |
| File Growth: | ||
| 2 | Growth In Percent /In MB | Acceptable values are Percent or MB. If Percent is chosen then you specify growth value in percent below. If MB is chosen you are specifying an absolute value for file growth. |
| 3 | Value | Specify the value for growth of a file in percent or MB as chosen above. |
| Maximum File Size: | ||
| 4 | Unrestricted File Growth | Acceptable values are “Yes” or “No”. These are visible when you hover over the field. When value is Yes, it is considered that you want the Unlimited growth of the file. If Yes is selected any entries in the field below are ignored. |
| 5 | Restricted File Growth(in MB) | If Unrestricted File Growth is No, specify the Restricted size to the file in MB |
| Output Fields: | ||
| 1 | Result | Output field to hold the result of the successful plugin execution. This field is mandatory. |
Known Errors:
When you select values for Instance name or Port field from a previous step input (i.e. Generate Rows or Microsoft Excel Input etc.) the corresponding Port or Instance name is disabled but may be unlocked when revisited