DEV Community: Seffu Kioi Nyambura

Restore database to SQL Server in ubuntu

Seffu Kioi Nyambura — Wed, 27 Apr 2022 09:41:48 +0000

After successful installation of SQL Server, sometimes there is need to restore a database. Below we will look at how to do that using terminal.
For this, we will use AdventureWorks2019 sample database which is a publicly provided by microsoft.
You can download it using this link AdventureWorks2019

Prerequisites:

Successfully installed SQL Server in Ubuntu
File of database to be restored in .bak format

Procedure:

Step 1: Open terminal
Use the shortcut Ctrl + alt + t to open the terminal
Step 2: Ensure the database file is in the present directory

ls

Step 2: Connect to SQL Server
Replace 'YourPassword' with the password you set during installation

sqlcmd -S localhost -U SA -P '<YourPassword>'

Step 3: Restore the Database
Replace /home/skn/Downloads/ with the path to where you have your database file.
NB:You can use the pwd command in the terminal to get your present working directory.

USE [master]
RESTORE DATABASE [AdventureWorks2019]
FROM DISK = '/home/skn/Downloads/AdventureWorks2019.bak'
WITH MOVE 'AdventureWorks2017' TO '/var/opt/mssql/data/AdventureWorks2019.mdf',
MOVE 'AdventureWorks2017_log' TO '/var/opt/mssql/data/AdventureWorks2019_log.ldf',
FILE = 1,  NOUNLOAD,  STATS = 5
GO

Congratulations, restoration successful

Install SQL Server command-line tools

Seffu Kioi Nyambura — Tue, 26 Apr 2022 09:46:02 +0000

After successful installation of SQL Server in ubuntu, we need a way to access it trough the terminal. This post illustrates steps you can take to make this possible

Prerequisites:

Account with sudo privileges
Successful installation of SQL Server in Ubuntu

Procedure:

Step 1: Open terminal
Use the shortcut Ctrl + alt + t to open the terminal
Step 2: Update and install curl (Optional)

sudo apt update && sudo apt install curl

Step 3: Import the public repository GPG keys

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

Step 4: Register the Microsoft Ubuntu repository

curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

Step 5: Update the sources list and install mssql-tools and odbc drivers

sudo apt update 
sudo apt install mssql-tools unixodbc-dev

Step 6: Add mssql-tools to your PATH environment variable

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc

Step 7: Connect local
Replace 'YourPassword' with the password you set during installation

sqlcmd -S localhost -U SA -P '<YourPassword>'

Congratulations you can now access mssql server in ubuntu

Install SQL Server in Ubuntu

Seffu Kioi Nyambura — Tue, 26 Apr 2022 09:42:35 +0000

Microsoft SQL Server is one of the most prominent databases in the industry today. In this post, I will show you how to install it on Ubuntu.

Prerequisites

Account with sudo privileges

Procedure:

Step 1: Open terminal
Use the shortcut Ctrl + alt + t to open the terminal

Step 2: Import the public repository GPG keys

wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

Step 3: Register the Microsoft SQL Server Ubuntu repository for SQL Server 2019

sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2019.list)"

Step 4: Install SQL Server

sudo apt update && sudo apt install -y mssql-server

Step 5: Follow the prompts to choose your edition, accept license terms and set the SA password.

sudo /opt/mssql/bin/mssql-conf setup

Step 6: Verify that the service is running

systemctl status mssql-server --no-pager

Next Step:

Install SQL Server command-line tools

2 or 3 Easy steps to install Virtualbox in Ubuntu

Seffu Kioi Nyambura — Sat, 23 Apr 2022 04:52:58 +0000

Virtualization is the process of running a virtual instance of a computer system in a layer abstracted from the actual hardware.It allows for simultaneous running of multiple operating systems on a single computer system.
Oracle VM VirtualBox is a type-2 hypervisor that allows for virtualization and is supported by multiple operating systems including but not limited to Windows based OS's,Linux and Mac OS.
Lets get started, shall we,
Prerequisites:

Virtualization enabled computer
An account with sudo privileges
Stable internet
Open Terminal (Ctrl+alt+t)

Step 1: Update package list
Use the command below to get a list of packages that might need to be updated. Ensure to input the correct password when prompted.

sudo apt update

Step 2: Upgrade packages (Optional)
Use the command below to upgrade any packages that appear from the first step.

sudo apt upgrade

Step 3: Install Virtualbox
The command below is used to install virtualbox and its accompanying extensions. Ensure that you agree to accept the agreements and terms of license.

sudo apt install virtualbox virtualbox-ext-pack

Below are some of the prompts and windows you will see during the installation.

Step 4: Confirmation(Optional)
Finally to confirm that VirtualBox was successfully installed, use the command below

virtualbox

#This is the sign of victory

Congratulations, you have successfully installed VirtualBox

Next Step

Installing an OS in VirtualBox