What is the difference between Extract and BackUp functions in STUDIO?
Backup Database Service can perform the following: – create a backup of a whole database; – create a differential backup of a database; – create a backup of separate files and groups of files; – create a differential backup of separate files and groups of files; – create a backup of a transaction log. This method cannot be used for creating backups of separate database objects or schemes. A backup is always saved on the server. If backups of transaction logs are available, you can restore a database at a definite time moment. DB Extract for SQL Server or Extract Database Wizard of SQL Manager for SQL Server creates backups either of whole databases or of only separate objects or schemes in a form of SQL script. The generated script can contain SQL Utility statements, Data Definition statements and Insert Data commands. A backup is savedon the client side. You can restore data only at the time when this backup was created. Thus, Backup Database Service uses SQL Server capabilities to cr
Backup Tables Service can be used only for creating backups of MyISAM tables. When creating a backup in this way, MyISAM tables chosen by a user are blocked (LOCK TABLES SQL command) and then the files, where structure (.frm) and data (.MYD) are physically kept, are copied according to the chosen path (BACKUP TABLES command). The last can be either a local directory on the server or a shared folder in the network. This path is defined from the server side where MySQL is installed. Extract Database Wizard of SQL Manager for MySQL or DB Extract for MySQL creates backups of databases or user-defined objects in a form of SQL script. The generated script can contain SQL Utility statements, Data Definition statements and Insert Data commands. Thus, Backup Tables Service uses MySQL server possibilities to create backups of only structure and data of MyISAM tables. This service is characterized by high speed and reliability, but it cannot place backup files in any client folder. This method ca
