Content Comparison

...

The Backup Database activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image RemovedImage Added

Parameters:

• Backup Path (text box editor type) (type: string): the full path where the backup file will be created.Media Name 
• Check Folder Exists (text box editor type) (type: stringcombobox): the new media a media name. For better results, use the same name as the database's. As an example, the Restore activity will work properly on a 2014 SQL Server when using the same name as the database's for the media set.select True if the folder where the backup will be created should be checked for existence, otherwise select False. By default the True value will be selected. The False option can be selected for situations where the user doesn't have rights for checking the folder, but it can create the backup.
• Media Name (text box editor type) (type: string):  the name of the backup set. Names can have a maximum of 128 characters. (E.g. 'Full Backup of Database'). In the example the name of the backup is the same the new media a media name. For better results, use the same name as the database's. As an example, the Restore activity will work properly on a 2014 SQL Server when using the same name as the database's for the media set.
• Timeout Name (text box editor type) (type: Int32string): the time in seconds to wait for  the name of the backup operation to execute. The default value in 30 seconds.

...

Execution: the activity will create a backup file of the database settled in the connection activity, in the specified folder:

Image Removed

The backup file can be seen in the given location:

Image Removed

Delete Row(s) from Table

This activity deletes Row(s) from a SQL Server database table.

Activity Parameters

The Delete Row(s) from Table activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image Removed

Parameters:

• Table (text box editor type) (type: string)set. Names can have a maximum of 128 characters. (E.g. 'Full Backup of Database'). In the example the name of the backup is the same as the database's.
• Timeout (text box editor) (type: Int32): the time in seconds to wait for the backup operation to execute. The default value in 30 seconds.

The backup file can be seen in the given location:

Image Added

Delete Row(s) from Table

This activity deletes Row(s) from a SQL Server database table.

Activity Parameters

The Delete Row(s) from Table activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image Added

Parameters:

• Table (text box editor type) (type: string): the table name where the row(s) will be deleted from.
• Where Statement (text box editor type) (type: string): the Where statement to filter the row(s) that will be deleted. For example: ID>2, where all rows with an ID higher than 2 will be deleted.
  
  

...

This activity restores a Database from a backup .bak file.

Activity Parameters

The Restore Database activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image Removed

Parameters:

...

file.

Activity Parameters

The Restore Database activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image Added

Parameters:

• Backup File Path (text box editor type) (type: string): the path of the backup file or select it with the File Browser. The .bak file path can be manually written or selected by clicking the Image Added button. In this example the backup file has the same name as the database's.
• Check File Exists (text box editor type) (type: stringcombobox): the path of select True if the backup file or select it with the File Browser. The .bak file path can be manually written or selected by clicking the Image Removed button. In this example the backup file has the same name as the database'sshould be checked for existence, otherwise select False. By default the True value will be selected. The False option can be selected for situations where the user doesn't have rights for checking the folder, but it can create the restore.
• Timeout (text box editor) (type: Int32): the time in seconds to wait for the backup operation to execute. The default value in 30 seconds.
  

...