Data Management > SQL Backup

During this task DMC will loop on the selected Tables and generate for each of them an sql script containing all the INSERT clauses required to allow you to restore the table from this script (with any good RDBMS)

Options you can define :

ADD the CREATE TABLE script

ADD the DROP IF EXISTS script

ONLY Create the CREATE TABLE scripts (NO DATA) - allows you to store in sql scripts the Tables STRUCTURES

ZIP Password : After all scripts are generated, DMC compacts them in a ZIP archive - define a PASSWORD to use for this archive

FTP Upload : When the ZIP archive is complete, DMC can upload it to any FTP server you define here after filling in all relevant fields : server - folder - user name and password

SAVE : You can save all these settings in a special Profile to be used again.

sql_backup

1. Double-Click on the DataBase you want to backup to open up all Tables and the necessary option fields

2. Select the Tables to include in this task ( double-click toggles the selected one and other buttons to Tag All - Tag Filled - Un Tag All)

(by default DMC will pre select for you all FILLED Tables - containing data)

3. Define your Options (create table - drop table)

4. Define FTP upload of zip archive or not

5. Define Zip password or not

6. Define the FOLDER to use to write the scripts (default is %datadir%/cgf_import/SQL_Backups/DBName@datetimestamp )

7. (Optional) Save as a profile

8. Start the Task

When you click on the Start Button this tab will be hidden and a second one will open showing you all the progress done during the task

If an error is encountered the current table is skipped error reported on screen and the next table treated

When the task ends the Total Time taken to perform it is displayed on screen - a button is displayed to let you OPEN the destination defined FOLDER containing the sql scripts and ZIP archive

sql_backup_completed

You can start again or another SQL Backup task immediately simply by changing TABS (after selecting another DB the destination FOLDER datetime stamp is updated so as to allow you several backups in a row in different folders).

THIS TASK IS RUNTIME ENGINE COMPLIANT

If you need to perform this task on your clients machines , then SAVE it as a Profile when all is defined and use the Runtime Engine to run it from your application

The destination Folder - FTP Server Folder User Name & Password as well as the ZIP Password can be changed dynamically from your application to meet your requirements