Detailed description of SQL timed backup database tools

A very useful timed backup database tool can save the Job backup time, And the built-in backup format is high compression, and the compression ratio can reach 10% (when the database file usage is 100% ). The disadvantage is that regular backup can only use its backup format, that is, the software must be installed during recovery. (1) Efficient backup-SQLBackup5.3 function: comes with high compression

A very useful timed backup database tool can save the Job backup time, And the built-in backup format is high compression, and the compression ratio can reach 10% (when the database file usage is 100% ). The disadvantage is that regular backup can only use its backup format, that is, the software must be installed during recovery. (1) Efficient Backup-SQL Backup 5.3 function: comes with high compression

This is a very easy-to-use timed backup tool that saves the time required for Job backup. the built-in backup format is high compression, and the compression ratio can reach 10% (when the file utilization rate is 100% ). The disadvantage is that regular backup can only use its backup format, that is, the software must be installed during recovery.

　　(1) Efficient Backup-SQL Backup 5.3

Function: provides a data backup mode with a high compression ratio. You can view all the backup and recovery records of the database and create a scheduled database backup and recovery plan.

Comments:

A very useful timed backup database tool can save the Job backup time, And the built-in backup format is high compression, and the compression ratio can reach 10% (when the database file usage is 100% ). The disadvantage is that regular backup can only use its backup format, that is, the software must be installed during recovery.

In other words, Winrar is used to increase the compression ratio of database backup files, but it takes a lot of time.

　　

　　

　(2) database comparison-SQL Compare 6

Function: compares all objects in two databases, including tables, stored procedures, views, and roles.

Comments:

An absolutely useful tool, especially when multiple users modify the database at the same time in the project, can be used to check whether your version is the same as that of others, and the software provides a detailed description, create tables, views, and stored procedure statements to facilitate version synchronization.

　　

　　

　　(3) Data comparison ---- SQL Data Compare 6

Function: To compare the data of all tables in two databases, you need to set the primary key, and there are multiple display modes, all/only on the Left/only on the right/exist on the two, there are also two display modes. Allows you to view all database backup and recovery records and create a scheduled database backup and recovery plan.

Comments:

The data comparison tool is also used in non-synchronous databases, but it may not be useful in database comparison. It is only useful in comparison of configuration tables, and different entries cannot generate update statements, this is inconvenient to use. For auto-increment columns, if compared by PK, it is likely that this is not smart enough.