All posts by Omelchenko Alexander

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

MySQL DBMS – /bin/sh: 1: /usr/bin/mysql: not found

If you get one of the following error messages during the setting up of SqlBak on Linux or during the execution of a backup job:

MySQL DBMS – /bin/sh: 1:/usr/bin/mysql: not found
or
MySQL DBMS – /bin/sh: 1:/usr/bin/mysqldump: not found

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

MS SQL Server DBMS – /bin/sh: 1: /opt/mssql-tools/bin/sqlcmd

If you get the following error message during SqlBak set up on Linux or during a backup job:

MS SQL Server DBMS – /bin/sh: 1: /opt/mssql-tools/bin/sqlcmd

it means that SqlBak app could not find the path to the msql executables. By default, SqlBak searches for mssql files in the /opt/mssql-tools/bin/sqlcmd directory. Continue reading MS SQL Server DBMS – /bin/sh: 1: /opt/mssql-tools/bin/sqlcmd

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