HowTo do SQL Backup Options

Click in the Image on "Start" or "Save" to open a Step by Step tutor page

Options you must define

Select the Tables to work on

  • Double-click on any Table to toggle the selection (the leftmost icon is displayed or not to show the "selected" mode)
  • Use the "Tag All" - "Untag"all" or "Tag Filled" (Tables with data) buttons for easier multi selections

Change Output Folder

  • Click on this button to select another folder (default is DB name and a date time stamp under SQL Backups DMC sub folder in Data)

FTP Upload (if you want the resulting ZIPPED (password protectable) file to be sent via FTP at the end of the task then :

  • Fill in the FTP "Server" - "Folder" - "User" & "Pwd" entry fields
  • The generated sql scripts will all be zipped in an archive and uploaded to this FTP server

Password protect the ZIP archive

  • Define a "Zip Pwd" to enable this option

Add the CREATE TABLE scripts

  • If you want to have the relevant CREATE TABLE scripts added to the INSERT VALUES one then check this option box (it will open up the display of the "Drop Table Scipt"

Add the DROP TABLE scripts

  • If you want the DROP TABLE script to be added then check this option box

Only Create Table Scripts

  • If you ONLY want to have the STRUCTURE (CREATE TABLE) scripts generated and NO Data script then use this option check box

Save

Create a Project (named as per the DB Name) to use again OR to ship to your end-users ( RT Engine).


Close

Cancel this Task.