最新版 SQLBackup And FTP 12.7.24 更新於 2024/7/3
SQL Backup And FTP 是MS SQL Server的備份軟體，並可以依照排程運行備份。可以對SQL Server或SQL Server Express資料庫運行文件/資料夾備份、壓縮和加密備份，並將它們儲存在網絡上或FTP伺服器上，其刪除舊的備份以及發送電子郵件確認以工作的成功或失敗。SQLBackupAndFTP也可以使用指令以進行遠端資料庫的備份。
- 簡單：SQLBackupAndFTP使用簡單，整個設置工作可以使用單一的形式並在兩分鐘內完成。
- 所有功能集於一身：從備份、壓縮，傳輸到FTP一體成型。
- 可信度：開發公司為擁有許多.NET和SQL Server經驗的美國軟體公司。
What can SQLBackupAndFTP do?
There is a lot more to SQLBackupAndFTP than meets the eye. Below is a feature list for the tool.
- Run scheduled backup of MySQL databases as well as local files and folders
- Compress and encrypt backups
- Store backups on a network folder, FTP server or in the cloud (Amazon S3, Google Drive, Dropbox, Box, OneDrive)
- Remove old backups
- Send an email notification to confirm backup success or failure
- Restore any backup directly from within the program
- Make backup history available for viewing online
- Notify you if your MySQL server is down
What's unique about this MySQL backup tool?
- Not all hosting platforms allow database administrators to connect to the hosted database via TCP/IP. If you cannot connect to your MySQL server through TCP/IP, you can still backup MySQL through phpMyAdmin Export. All you need is a URL for you to login to your phpMyAdmin
- You can view MySQL backup results for multiple servers. The results are available through the web log
- This tool has a free version that is fully functional. It is the ideal solution if all you need are ad hoc MySQL backups or scheduled backups for 1 or 2 databases
How does it backup MySql databases?
SQLBackupAndFTP runs on Windows machines, and can backup both remote and local MySQL databases. Two database connection methods are available: via a TCP/IP (SSH) connection or by using phpMyAdmin Export. In both cases, it creates MySQL scripts that can be run later to restore the MySQL databases. When TCP/IP connection is used, the backup is performed using the mysqldump utility.
How does this tool relate to MySQLBackupFTP?
Previously, SQLBackupAndFTP and MySQLBackupFTP were two different products. MySQLBackupFTP has since been deprecated. Now SQLBackupAndFTP includes all the functionality of MySQLBackupFTP and more. SQLBackupAndFTP can restore MySQL backups. In addition, it can also notify you if something goes wrong with your MySQL servers.
| Professional Lifetime | Professional | Standard | Lite | Free | |
| Schedule SQL Server, MySQL, and PostgreSQL Backups without interrupting database services | V | V | V | V max 5 db |
V max 2 db |
| Backup unlimited number of databases via "Run Now" button without scheduling | V | V | V | V | V |
| Send backups to FTP, SFTP, FTPS, NAS, local, network folder, OneDrive Personal, Box, Backblaze B2, Yandex.Disk | V | V | V | V | V |
| Send email confirmation on job success or failure | V | V | V | V | V |
| Restore backups in one click with backup chain automatically restored in correct sequence | V | V | V | V | V |
| Backup remote SQL Databases | V | V | V | V | V |
| Backup Azure SQL Databases | V | V | V | V | V |
| Backup Amazon RDS SQL Server Databases | V | V | V | V | V |
| Log Shipping | V | V | V | V | V |
| Backup files & folders | V | V | V | V | V |
| Send backups to Google Drive, Dropbox | V | V | V | V | |
| Run Differential and Transaction log backup (for Local SQL Server only); Full backups are available in all editions | V | V | V | ||
| Send backups to Amazon S3 (and any S3-Compatible storage), Azure Storage, OneDrive for Business | V | V | |||
| AES encryption | V | V | |||
| Full-Service subscription | Lifetime | Optional | Optional | Optional |
Requirements: .NET Framework version 4.7.2 or above