The SQL Server assests provide a way to Backup, Restore, or initiate a Bulk Insert. Having these items as assets allows for quick development of tests without needing to duplicate the commands contained within the asset.
T-SQL Backup / Restore
T-SQL Backup / Restore
| Icon | Description |
|---|---|
 | The T-SQL Backup / Restore asset stores a backup or restore SQL command, that can later be used with the Execute Query Command action. Backups and restores use the default backup location of the system running the test. |
Backup / Restore Editor
| Function | Description |
|---|---|
| Mode | Select either Backup or Restore. |
| Database | The name of the database to back up or restore. |
| File Name | The name of the file to restore, or the name to give the backup. |
T-SQL Bulk Insert
T-SQL Bulk Insert
| Icon | Description |
|---|---|
 | The T-SQL Bulk Insert asset stores the information for a bulk insert that can be executed using the Execute Query Command action. Specifiy the table that the data is inserted into, a file that contains the information, and the field separator. |
Bulk Insert Editor
| Function | Description |
|---|---|
| Table | The table where the data is inserted. |
| File Name | The location of the file that holds the data to be inserted. |
| Field Separator | Specify if the data uses a separator other than the default tab. |
