Category Archives: SqlBak

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

PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found

If during setting up of SqlBak on Linux or during a backup job one of the following errors occurs:

PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found
or
PostgreSQL DBMS – /bin/sh: 1: /usr/bin/pgdump: not found

it means that SqlBak app could not find the path to postgresql executables. By default, SqlBak looks for postgresql files in the /usr/bin/psql directory.  Continue reading PostgreSQL DBMS – /bin/sh: 1: /usr/bin/psql: not found

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