How to Copy SQL Server Database from Windows to Linux

After Microsoft has launched SQL Server for Linux, even if your main tech stack is tied to Windows Server you may need to copy the database to another SQL Server located on a Linux computer.

For example, this can come in handy if you want to provide developers with a database for testing without buying a Windows Server license. 

There are a few ways to tackle this task. This article examines the following methods to copy SQL Server database from Windows to Linux:

  1. Using T-SQL’s BACKUP DATABASE and RESTORE DATABASE commands;
  2. Generation of T-SQL database script (such as mysqldump);
  3. Creating BACPAC;
  4. SqlBak service.

Continue reading How to Copy SQL Server Database from Windows to Linux

How to automate MySQL databases backups to S3

If you have a database, then you need to back it up regularly, and preferably not manually. To perform regular backups is only half the battle, you also have to consider where to store them. Saving the backups on the same server where MySQL Server is installed isn’t safe, because if it crashes, you will lose everything. Continue reading How to automate MySQL databases backups to S3

How to Automate MySQL Database Backups in Linux

Automated backup of MySQL databases can be a serious task. The proper way to automate backups involves the following steps:

  1. Create a database backup
  2. Zip the backup
  3. Encrypt the compressed file
  4. Send the backup to storage over the Internet, FTP, Dropbox, AWS, Google Drive, etc.
  5. Receive email notifications concerning backup results
  6. Create a backup schedule
  7. Delete old backups

Continue reading How to Automate MySQL Database Backups in Linux