Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Database (text box editor type) (type: string): the database name to connect to.
  • Password (password editor type) (type: string): the password for the provided username.
  • Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the sql server. (This parameter is used only when the user wants to send an encrypted password from outside the task, for example Flowster User Portal).
  • Server Name (text box editor type) (type: string): the name or IP of the SQL Server to connect to.
  • Username (text box editor type) (type: string): the the username of the SQL Server Administrator.

...

  • Backup Path (text box editor type) (type: string): the path where the backup file will be created.
  • File Name (text box editor type) (type: string): the name of the backup file that will be created. Should be an .sql extension file (E.G. BackupFile.sql).
  • MySQLDump.exe Path (text box editor type) (type: string): the the path of the mysqldump.exe, or select it with the File Browser.
  • Password (password editor type) (type: string): the password for the provided username.
  • Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the sql server. (This parameter is used only when the user wants to send an encrypted password from outside the task, for example Flowster User Portal).

As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Backup Database activity:

...

  • Backup File Path (text box editor type) (type: string): the path of the backup file or select it with the File Browser. Should be an .sql extension file (E.G. C:\\BackupsFolder\BackupFile.sql).
  • MySQl.exe Path (text box editor type) (type: string)the path of the mysql.exe, or select it with the File Browser.
  • Password (password editor type) (type: string): the password for the provided username.
  • Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the sql server. (This parameter is used only when the user wants to send an encrypted password from outside the task, for example Flowster User Portal).

As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Restore Database activity:

...