Otu esi etinye SQL Server na RHEL, Rocky Linux na AlmaLinux

Na Machị 7, 2016, Microsoft kwupụtara mwepụta nke sava MS SQL na sistemụ Linux. Ebumnobi a bụ iwepụtakwu mgbanwe maka ndị ọrụ yana iwepụ mkpọchi ndị na-ere ahịa na ebumnuche nke ịkwalite nnabata nke sava nchekwa data SQL. Ọ bụrụ na ịmabeghịrịrị, MS SQL bụ ihe nkesa nchekwa data nwere mmekọrịta nke Microsoft mepụtara.

Ụdị kwụsiri ike ugbu a bụ MS SQL 2019, nke ewepụtara azụ na Nọvemba 2019. A na-akwado SQL Server na foto RHEL, SUSE, Ubuntu, na Docker.

N'ime ntuziaka a, anyị ga-ejegharị gị site na ntinye nke Microsoft SQL Server na RHEL, CentOS, Rocky Linux, na AlmaLinux.

Ị ga-enwerịrị nkesa Linux nke RHEL nwere opekata mpe 2 GB nke ebe nchekwa yana 10 GB nke ohere diski ike.

Kwụpụ 1: Tinye Microsoft SQL Server Repository

Nzọụkwụ mbụ bụ ịhazi ebe nchekwa Microsoft SQL Server. Ebe nchekwa ahụ na-eweghachite mssql-sava, ngwungwu engine nchekwa data, yana ngwungwu sava SQL ndị ọzọ.

Enwere ụdị nchekwa 2 sara mbara: mkpokọta na GDR.

Mmelite mkpokọta – Nchịkọta Mmelite (CU) nwere ngwungwu maka ntọhapụ nkesa SQL ntọala, nkwalite, na ndozi ahụhụ kemgbe ewepụtara ya. Ndị a bụ kpọmkwem maka ntọhapụ (dịka ọmụmaatụ SQL Server 2019) ma na-ewepụta ya na usoro okirikiri.
GDR: Ebe nchekwa a nwere naanị mmelite nchekwa yana ndozi ahụhụ dị egwu nke a ga-etinyekwa na mwepụta nkesa MS SQL na-esote.

Ka ịgbakwunye ebe nchekwa, gbaa iwu:

$ sudo curl https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo -o /etc/yum.repos.d/mssql-server-2019.repo 
$ sudo curl https://packages.microsoft.com/config/rhel/8/prod.repo -o /etc/yum.repos.d/msprod.repo

Kwụpụ 2: Wụnye Microsoft SQL Server na Ngwaọrụ

Ozugbo agbakwunyere ebe nchekwa ahụ, wụnye Microsoft SQL Server site na iji njikwa ngwugwu DNF dị ka enyere ya.

$ sudo dnf install mssql-server

Mgbe nke ahụ gasịrị, wụnye Microsoft SQL ngwaọrụ akara iwu.

$ sudo dnf install mssql-tools unixODBC-devel

N'ụzọ, nabata Usoro ikike site na ịpị 'Ee'.

Mgbe emechara nrụnye, gosi na arụnyere Microsoft SQL Server site na iji iwu rpm:

$ rpm -qi mssql-server

Mwepụta ahụ na-enye ọtụtụ ozi gụnyere ụdị, Mwepụta, na ụkpụrụ ụlọ n'etiti nkọwa ndị ọzọ.

Kwụpụ 3: Malite MS SQL Database Engine na Linux

Ruo ugbu a, anyị etinyela Microsoft SQL Server yana ngwa ahịrị ahịrị niile dị mkpa. Anyị kwesịrị ịmalite igwe nchekwa data tupu anyị abanye wee malite imekọrịta ya.

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

Ị ga-achọrọ ka ịhọrọ otu mbipụta nke SQL Server. Maka ịdị mma, họrọ nhọrọ nke abụọ [ 2 ] nke na-enye mbipụta Mmepụta nke bụ n'efu mana enweghị ikike nrụpụta.

Mgbe nke ahụ gasịrị, nabata Usoro ikike wee kọwaa paswọọdụ onye nchịkwa.

Ntọlite ahụ ga-emecha nke ọma na ihe nkesa SQL ga-amalite.

Iji nyochaa ọkwa nkesa MS SQL na-agba ọsọ, gbaa iwu a:

$ sudo systemctl status mssql-server.service

Ị nwere ike ime ka ọ malite na oge buut dị ka ndị a.

$ sudo systemctl enable mssql-server.service

Mgbe nke ahụ gasịrị, bupụ ụzọ /opt/mssql/bin/ dị ka egosiri.

$ echo 'export PATH=$PATH:/opt/mssql/bin:/opt/mssql-tools/bin' | sudo tee /etc/profile.d/mssql.sh

Mgbe ahụ gbanye faịlụ /etc/profile.d/mssql.sh.

$ source /etc/profile.d/mssql.sh

MS SQL na-ege ntị na ọdụ ụgbọ mmiri 1433 na ndabara. Iji nye ndị ọrụ mpụga ohere ịnweta sava ahụ, anyị kwesịrị imepe ọdụ ụgbọ mmiri a n'ofe firewall.

$ sudo firewall-cmd --add-port=1433/tcp  --permanent
$ sudo firewall-cmd --reload

Zuru oke! Ka anyị nweta ugbu a ma nwalee ihe nkesa.

Kwụpụ 4: Nbanye wee nwalee ihe nkesa MS SQL na Linux

Tupu anwale, hụ na ịlele ụdị MS SQL arụnyere, jiri sqlcmd utility mee ajụjụ SQL.

$ sqlcmd -S localhost -U SA -Q 'select @@VERSION'

Chọpụta wee pịa ENTER. Ị ga-enweta ihe egosipụtara.

Ka ịpụọ kpọọ iwu ahụ.

$ exit

Banye ọzọ wee mee iwu a:

$ sqlcmd -S localhost -U SA

Wepụta paswọọdụ gị wee pịa ENTER. Ị nwere ike depụta aha ndị ọrụ na tebụl nke na-echekwa nzere ndị ọrụ.

1> SELECT name FROM sys.sysusers;
2> GO

Ka imepụta nchekwa data wee depụta ọdụ data niile na-agba iwu.

CREATE DATABASE tecmint_db;
SELECT name FROM sys.databases;
GO

Ị nwere ike idobe nchekwa data site na-agba ọsọ:

DROP DATABASE tecmint_db;
GO

Iwu a hichapụ ma ọ bụ dobe nchekwa data niile.

Ọ bụ ya. Anyị etinyela ihe nkesa MS SQL nke ọma na RHEL, CentOS, Rocky Linux, na AlmaLinux. ma nwalee iwu ole na ole.