MSSQL Server 2019 (upgrade Ubuntu 18.04 to 20.04 to 22.04) #3

https://www.cyberciti.biz/faq/upgrade-ubuntu-20-04-lts-to-22-04-lts/

ubuntu LTS release :

no	Ubuntu Version	code name
1	Ubuntu 6.06 LTS	Dapper Drake
2	Ubuntu 8.04 LTS	Hardy Heron
3	Ubuntu 10.04 LTS	Lucid Lynx
4	Ubuntu 12.04 LTS	Precise Pangolin
5	Ubuntu 14.04 LTS	Trusty Tahr
6	Ubuntu 16.04 LTS	Xenial Xerus
7	Ubuntu 18.04 LTS	Bionic Beaver
8	Ubuntu 20.04 LTS	Focal Fossa
9	Ubuntu 22.04 LTS	Jammy Jellyfish
10	Ubuntu 24.04 LTS	Noble Numbat

Exsisting ubuntu 18.04.6
- ubuntu version
- applcation exisiting
  - SQL Server 2019
upgrade ubuntu 18.04.6 to 20.04
upgradee ubuntu via step by step version

Preparation

Preparation proses
- Upgrade the all packages to the latest versions
```
apt-get update -y
apt-get upgrade -y
```
- Open TCP port 1022
```
sudo ufw allow 1022/tcp
```
- install update manager core
```
apt-get install update-manager-core
```
- edit file /etc/update-manager/release-upgrades
```
nano /etc/update-manager/release-upgrades
```
In above file you can use the option to upgrade either to LTS or normal release upgrade, the upgrade you want just put that in Prompt=lts As we want LTS update so I chooses it.
- find all packages that are on hold, type the apt-mark command:
```
sudo apt-mark showhold
```
- Upgrade the all packages to the latest versions
```
apt-get update -y
apt-get upgrade -y
```
- reboot
```
sudo reboot
```

Upgrade Prosess

Upgrade Proses
- cekl ubuntu release before upgrade
```
uname -mrs
lsb_release -a
```
- upgrade command help
```
do-release-upgrade -h
```
- upgrade command
```
do-release-upgrade
```

Upgrade Finish

Upgrade Proses
- ubuntu version (before)
- ubuntu version (after)
- applcation exisiting
  - SQL Server 2019

![image](/attachments/c603e5b2-6408-4938-baea-62f5d1141096) https://www.cyberciti.biz/faq/upgrade-ubuntu-20-04-lts-to-22-04-lts/ - ubuntu LTS release : |no |Ubuntu Version |code name | |--- |--- |--- | |1 |Ubuntu 6.06 LTS |Dapper Drake | |2 |Ubuntu 8.04 LTS |Hardy Heron | |3 |Ubuntu 10.04 LTS |Lucid Lynx | |4 |Ubuntu 12.04 LTS |Precise Pangolin | |5 |Ubuntu 14.04 LTS |Trusty Tahr | |6 |Ubuntu 16.04 LTS |Xenial Xerus | |7 |Ubuntu 18.04 LTS |Bionic Beaver | |8 |Ubuntu 20.04 LTS |Focal Fossa | |9 |Ubuntu 22.04 LTS |Jammy Jellyfish | |10 |Ubuntu 24.04 LTS |Noble Numbat | | | | | - Exsisting ubuntu 18.04.6 - ubuntu version ![image](/attachments/e14e836a-ee82-4a71-808d-a10ada487932) - applcation exisiting - SQL Server 2019 - upgrade ubuntu 18.04.6 to 20.04 upgradee ubuntu via step by step version ![image](/attachments/94c40219-0ebd-42fa-a56c-009bbf5b39e9) -------- #### Preparation - Preparation proses - Upgrade the all packages to the latest versions ``` apt-get update -y apt-get upgrade -y ``` - Open TCP port 1022 ``` sudo ufw allow 1022/tcp ``` - install update manager core ``` apt-get install update-manager-core ``` - edit file /etc/update-manager/release-upgrades ``` nano /etc/update-manager/release-upgrades ``` ![image](/attachments/0745f4e7-70a1-40f7-bf4b-d96ee1dc8e46) In above file you can use the option to upgrade either to LTS or normal release upgrade, the upgrade you want just put that in Prompt=lts As we want LTS update so I chooses it. - find all packages that are on hold, type the apt-mark command: ``` sudo apt-mark showhold ``` - Upgrade the all packages to the latest versions ``` apt-get update -y apt-get upgrade -y ``` - reboot ``` sudo reboot ``` -------- #### Upgrade Prosess - Upgrade Proses - cekl ubuntu release before upgrade ``` uname -mrs lsb_release -a ``` - upgrade command help ``` do-release-upgrade -h ``` - upgrade command ``` do-release-upgrade ``` -------- #### Upgrade Finish - Upgrade Proses - ubuntu version (before) ![image](/attachments/445ee99e-66df-438a-8564-3cd9700bb3ac) ![image](/attachments/ded7ad44-643d-4735-ab92-7e76804167ef) - ubuntu version (after) ![image](/attachments/4febce1c-c7f7-4b0d-90a6-8ff9a67ac8b1) ![image](/attachments/d8bb6e7d-ff6e-42e5-98ef-4548213deba4) - applcation exisiting - SQL Server 2019 ![image](/attachments/6737d735-ebf9-40a0-bc9c-442600dea2f8)

image.png

49 KiB

image.png

141 KiB

image.png

40 KiB

image.png

36 KiB

image.png

156 KiB

image.png

316 KiB