Yadda ake Sanya SQL Server a RHEL, Rocky Linux da AlmaLinux

A ranar 7 ga Maris, 2016, Microsoft ya sanar da ƙaddamar da uwar garken MS SQL a cikin tsarin Linux. Manufar ita ce a sadar da ƙarin sassauci ga masu amfani da kuma kawar da kulle-kulle mai siyarwa tare da manufar haɓaka karɓar sabar bayanan SQL. Idan ba ku sani ba tukuna, MS SQL sabar bayanai ce mai alaƙa da Microsoft ta haɓaka.

Sigar kwanciyar hankali na yanzu shine MS SQL 2019, wanda aka sake shi a watan Nuwamba 2019. Ana tallafawa SQL Server akan RHEL, SUSE, Ubuntu, da hoton Docker.

A cikin wannan jagorar, za mu bi ku ta hanyar shigar da Microsoft SQL Server akan RHEL, CentOS, Rocky Linux, da AlmaLinux.

Dole ne ku sami rarrabawar Linux na tushen RHEL tare da aƙalla 2 GB na ƙwaƙwalwar ajiya da 10 GB na sararin faifai.

Mataki 1: Ƙara Ma'ajiya ta Microsoft SQL Server

Mataki na farko shine saita ma'ajin ajiyar sabar Microsoft SQL Server. Wurin ajiya yana dawo da uwar garken mssql, fakitin injin bayanai, da sauran fakitin sabar SQL.

Akwai manyan nau'ikan ma'ajin ajiya guda 2: Tara da GDR.

Sabunta Tara - Ma'ajiyar Sabuntawa (CU) ta ƙunshi fakiti don sakin sabar SQL na tushe, haɓakawa, da gyaran kwaro tun lokacin da aka saki. Waɗannan su ne keɓaɓɓu ga fitarwa (misali SQL Server 2019) kuma ana fitar da su akan takamaiman zagayowar.
GDR: Wannan ma'ajiyar ta ƙunshi sabuntawar tsaro kawai da gyare-gyaren kwari masu mahimmanci waɗanda kuma za a haɗa su a cikin sakin uwar garken MS SQL na gaba.

Don ƙara wuraren ajiya, gudanar da umarni:

$ 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

Mataki 2: Shigar da Microsoft SQL Server da Tools

Da zarar an ƙara ma'ajiyar, shigar da Microsoft SQL Server ta amfani da mai sarrafa fakitin DNF kamar yadda aka bayar.

$ sudo dnf install mssql-server

Bayan haka, shigar da kayan aikin layin umarni na Microsoft SQL.

$ sudo dnf install mssql-tools unixODBC-devel

A kan hanya, Karɓa da Sharuɗɗan lasisi ta buga 'YES'.

Lokacin da aka gama shigarwa, tabbatar da cewa an shigar da Microsoft SQL Server ta amfani da umarnin rpm:

$ rpm -qi mssql-server

Fitowar tana ba da ɗimbin bayanai da suka haɗa da sigar, Saki, da gine-gine a tsakanin sauran cikakkun bayanai.

Mataki 3: Ƙaddamar da Injin Database MS SQL a cikin Linux

Ya zuwa yanzu, mun shigar da Microsoft SQL Server da duk mahimman kayan aikin layin umarni. Muna buƙatar fara injin bayanai kafin mu shiga mu fara hulɗa da shi.

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

Za a buƙaci ka zaɓi bugu na SQL Server. Don saukakawa, zaɓi zaɓi na biyu [ 2 ] wanda ke ba da Haɗin Haɓakawa wanda kyauta ne amma ba tare da haƙƙin samarwa ba.

Bayan haka, karɓi Sharuɗɗan lasisi kuma saka kalmar wucewa ta Mai gudanarwa.

Saitin zai kammala cikin nasara kuma za a fara sabar SQL.

Don tabbatar da halin gudu na uwar garken MS SQL, gudanar da umarni:

$ sudo systemctl status mssql-server.service

Kuna iya kunna shi don farawa akan lokacin taya kamar haka.

$ sudo systemctl enable mssql-server.service

Bayan haka, fitar da hanyar /opt/mssql/bin/ kamar yadda aka nuna.

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

Sannan kunna fayil ɗin /etc/profile.d/mssql.sh.

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

MS SQL yana sauraron tashar jiragen ruwa 1433 ta tsohuwa. Don ba da damar masu amfani da waje damar shiga uwar garken, muna buƙatar buɗe wannan tashar jiragen ruwa a fadin Tacewar zaɓi.

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

Cikakku! Yanzu bari mu isa kuma gwada uwar garken.

Mataki na 4: Shiga kuma Gwada uwar garken MS SQL a cikin Linux

Kafin gwaji, tabbatar da duba sigar MS SQL da aka shigar, yi amfani da aikin sqlcmd don yin tambayar SQL.

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

Tabbatar kuma latsa ENTER. Ya kamata ku sami fitarwa da aka nuna.

Don fita kira umarni.

$ exit

Da sake shiga kuma gudanar da umarni mai zuwa:

$ sqlcmd -S localhost -U SA

Tabbatar da kalmar wucewa kuma latsa ENTER. Kuna iya lissafin sunayen masu amfani a cikin tebur wanda ke adana bayanan masu amfani.

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

Don ƙirƙirar bayanan bayanai da jera duk bayanan bayanai suna gudanar da umarni.

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

Kuna iya sauke bayanan bayanai ta hanyar gudu:

DROP DATABASE tecmint_db;
GO

Umurnin yana share ko jefar da dukkan bayanan.

Shi ke nan. Mun sami nasarar shigar da uwar garken MS SQL akan RHEL, CentOS, Rocky Linux, da AlmaLinux. kuma sun gwada 'yan umarni.