Skip to main content

SQL Server on Linux Backup & Maintenance

Category: Uncategorized

How to Backup and FTP SQL Server On Linux

December 5, 2017February 4, 2020 mike 6 Comments

If you are looking for a custom way to backup SQL Server on Linux local database and send the backup to FTP server we can present you the following python-script. If you prefer SAAS solutions try SqlBak that will do everything for you. Read More

How to Install the Microsoft ODBC Driver 13 for SQL Server on Linux (Ubuntu)

December 5, 2017December 5, 2017 mike 3 Comments

If you face “Microsoft ODBC Driver 13 for SQL Server: Data source name not found, and no default driver specified.” error while trying to access your SQL Server on Linux then most probably you are missing Microsoft ODBC Driver 13 for SQL Server on your machine. Here is how to install this driver. Read More

How to Get Microsoft Azure SQL Server on Linux (Ubuntu) with Free License

November 30, 2017December 4, 2017 Alexander Omelchenko 2 Comments

This is a step-by-step procedure to help a Microsoft Azure user to create Azure Virtual Linux Machine with SQL Server onboard with no charge for license.

Read More

Working with MS SQL Server in Python on Linux

July 24, 2017July 24, 2017 Robert Ludwig 7 Comments

Today we’re turning our attention to Python, and looking at how you can connect to a Microsoft SQL Server database running on Linux using Python. In this tutorial, we’ll look at establishing a connection and running a few sample queries.

Read More

Configuring MS SQL Server on Linux

July 16, 2017July 16, 2017 Robert Ludwig Leave a comment

Once you’ve installed Microsoft SQL Server on Linux, you’ll want to make sure it’s configured as you’d like it to be. There are a few ways to do this, and today we’ll look at two: environment variables and the mssql-conf binary.
Read More

Connecting to Microsoft SQL Server in Node.js on Linux

July 10, 2017July 17, 2017 Robert Ludwig Leave a comment

Today we’re going to look at connecting to Microsoft SQL Server for Linux through Node.js similar to how we connected in PHP earlier. Just as before, our goal is to enable web application development by connecting to an existing MS SQL Server running on our local host. This time, we’ll do so using Node, and the popular Node library Tedious.

Read More

Connecting to Microsoft SQL Server in PHP on Linux

July 2, 2017July 2, 2017 Robert Ludwig 8 Comments

PHP and SQL Server work together wonderfully! Once you’ve gotten MS SQL Server installed on your Linux machine, it’s time to start running some real applications on it. Today we’ll look at querying SQL Server from PHP to enable your web applications.

Read More

Migrating SQL Server Data from Windows to Linux

June 25, 2017June 26, 2017 Robert Ludwig Leave a comment

Migrating a SQL server database from Windows to Linux is not that difficult! The recommended method is a three-step process of 1) backing up the database to a file on the Windows machine, 2) moving that file over to the Linux machine and 3) using the restore feature to import the data in Linux. Each of these steps is very straightforward. Read More

How to Backup SQL Server on Linux

June 21, 2017February 4, 2020 mike 5 Comments

You can back up your SQL Server databases on Linux using at least one of the following approaches:

  • by using SqlBak that will do everything for you
  • by running the sqlcmd client directly on your Linux machine (this will be described in this post below)
  • by running a custom python script Read More

sqlcmd: command not found on Ubuntu. How to fix it?

March 1, 2017February 1, 2021 mike 44 Comments

If after installing Sql Server on Ubuntu you can’t run sqlcmd getting “sqlcmd: command not found” error then you need to check some things out.
Read More

Posts navigation

1 2 Older posts

Recent Posts

  • How to Backup and FTP SQL Server On Linux
  • How to Install the Microsoft ODBC Driver 13 for SQL Server on Linux (Ubuntu)
  • How to Get Microsoft Azure SQL Server on Linux (Ubuntu) with Free License
  • Working with MS SQL Server in Python on Linux
  • Configuring MS SQL Server on Linux

Recent Comments

  • Damir on Connecting to Microsoft SQL Server in PHP on Linux
  • whoiscall on How to Backup and FTP SQL Server On Linux
  • Nora Tenorio on How to Install MS SQL Server on Linux
  • Working at Walmart on How to Backup and FTP SQL Server On Linux
  • Alexander Omelchenko on How to Backup and FTP SQL Server On Linux
sparkling Theme by Colorlib Powered by WordPress