Upgrade MSSQL Server 2017 to 2019 (Ubuntu 18.04) #2

Langkah upgrade MSSQL Server 2017 to 2019

1. Hapsu repository MSSQL Server 2017

Cek repo MSSQL existing

grep -R "packages.microsoft.com" /etc/apt

Output:

Hapus repo

Edit `/etc/apt/sources.list`

sudo nano /etc/apt/sources.list

Cari dan HAPUS / COMMENT baris ini:

deb-src https://packages.microsoft.com/ubuntu/18.04/mssql-server-2017 bionic main

Comment dengan # (lebih aman):

#deb-src https://packages.microsoft.com/ubuntu/18.04/mssql-server-2017 bionic main

Simpan → CTRL+O → Enter → CTRL+X

Edit /etc/apt/sources.list.save (PENTING)

File ini sering bikin repo muncul lagi diam-diam

sudo nano /etc/apt/sources.list.save

Comment / hapus baris:

deb-src https://packages.microsoft.com/ubuntu/18.04/mssql-server-2017 bionic main

Update daftar paket dan versi terbaru yang tersedia dari repositori perangkat lunak sistem

sudo apt update

2. Tambahkan Microsoft Gpg Key

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

3. Tambahkan Repo MSSQL Server 2019

wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list \
| sudo tee /etc/apt/sources.list.d/mssql-server-2019.list

Penjelasan:

Menambahkan repo resmi SQL Server 2019
Khusus untuk Ubuntu 18.04
File repo disimpan di sources.list.d

Update index:

sudo apt update

4. Install MSSQL Server 2019

sudo apt install -y mssql-server

Penjelasan:

Menginstall SQL Server 2019
Service belum aktif sebelum setup

5. Setup MSSQL Server 2019

Sebelum melakukan setup pastikan service Mssql-server sudah stop. Secara default service akan berhenti saat kita install versi terbaru,tetapi dibeberapa kondisi service ini tetap active jadi pastikan service Mssql server berhenti.

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

Pilih:

Edition: 8 → Enterprise
Product Key (Mssql-server 2019 En):
TDKQD-PKV44-PJT4N-TCJG2-3YJ6B

Penjelasan:

Mengaktifkan service SQL Server
Menentukan edition & credential admin

# Langkah upgrade MSSQL Server 2017 to 2019 ## 1. Hapsu repository MSSQL Server 2017 ### Cek repo MSSQL existing ``` grep -R "packages.microsoft.com" /etc/apt ``` Output: ![image](/attachments/9b356b64-17f1-4243-a8e8-8edd90e33e8e) ### Hapus repo #### Edit ``/etc/apt/sources.list`` ``` sudo nano /etc/apt/sources.list ``` Cari dan HAPUS / COMMENT baris ini: ``` deb-src https://packages.microsoft.com/ubuntu/18.04/mssql-server-2017 bionic main ``` Comment dengan # (lebih aman): ``` #deb-src https://packages.microsoft.com/ubuntu/18.04/mssql-server-2017 bionic main ``` Simpan → CTRL+O → Enter → CTRL+X #### Edit /etc/apt/sources.list.save (PENTING) File ini sering bikin repo muncul lagi diam-diam ``` sudo nano /etc/apt/sources.list.save ``` Comment / hapus baris: ``` deb-src https://packages.microsoft.com/ubuntu/18.04/mssql-server-2017 bionic main ``` #### Update daftar paket dan versi terbaru yang tersedia dari repositori perangkat lunak sistem ``` sudo apt update ``` ## 2. Tambahkan Microsoft Gpg Key ``` wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - ``` ## 3. Tambahkan Repo MSSQL Server 2019 ``` wget -qO- https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list \ | sudo tee /etc/apt/sources.list.d/mssql-server-2019.list ``` Penjelasan: * Menambahkan repo resmi SQL Server 2019 * Khusus untuk Ubuntu 18.04 * File repo disimpan di sources.list.d Update index: ``` sudo apt update ``` ## 4. Install MSSQL Server 2019 ``` sudo apt install -y mssql-server ``` Penjelasan: * Menginstall SQL Server 2019 * Service belum aktif sebelum setup ## 5. Setup MSSQL Server 2019 Sebelum melakukan setup pastikan service Mssql-server sudah stop. Secara default service akan berhenti saat kita install versi terbaru,tetapi dibeberapa kondisi service ini tetap active jadi pastikan service Mssql server berhenti. ``` sudo /opt/mssql/bin/mssql-conf setup ``` Pilih: * Edition: 8 → Enterprise * Product Key (Mssql-server 2019 En): TDKQD-PKV44-PJT4N-TCJG2-3YJ6B Penjelasan: * Mengaktifkan service SQL Server * Menentukan edition & credential admin

image.png

26 KiB

image.png

194 KiB