Yadda ake Shigar da Amfani da MS SQL Server akan Linux

A cikin shekara ta 2016, Microsoft ya ba wa duniyar IT mamaki tare da sanarwar shirin su na kawo MS SQL Server zuwa Linux.

A karkashin jagorancin Satya Nadella, giant Redmond ya sami ci gaba mai mahimmanci don cin gajiyar wuraren da Linux ke mamaye masana'antar (kamar fasahar da ke sarrafa girgije). Yunkurin samar da SQL Server a cikin Linux har yanzu wata alama ce ta wannan hanyar.

Ko menene dalilin da ya sa kamfani ke bayan wannan yunƙurin, masu gudanar da tsarin Linux na iya buƙatar koyon yadda ake girka, kulawa, da amfani da MS SQL Server - musamman la’akari da cewa fakitin samfoti sun riga sun kasance don Red Hat Enterprise Linux 7.3+ (ya haɗa da CentOS 7.3). + da) da Ubuntu Server 16.04 bits (yi hakuri - babu sigar 32-bit!).

Abinda kawai ake buƙata na tsarin \mafi kyau na sigar samfoti shine cewa tsarin da aka shigar dole ne ya kasance yana da aƙalla 2 GB na RAM.

Shigar da MS SQL Server akan Linux

A cikin wannan labarin farawa mai sauri, zamuyi bayanin yadda ake shigar da samfoti na SQL Server 2019 akan sakewar RHEL/CentOS 7.3+ da Ubuntu 16.04.

1. Don shigar da SQL Server akan sakewar RHEL/CentOS 7.3+, zazzage samfurin Microsoft SQL Server 2019 preview Repository repository files na Hat, wanda zai shigar da kunshin mssql-server da mssql-tools ta amfani da umarnin curl masu zuwa.

# curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-preview.repo
# curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo

2. Sa'an nan kuma shigar da SQL Server da mssql-tools tare da unixODBC developer package ta amfani da yum package manager, kamar yadda aka nuna.

# yum install -y mssql-server mssql-tools unixODBC-devel

3. Lokacin da shigarwa ya cika, za a tunatar da ku don gudanar da rubutun daidaitawa (/opt/mssql/bin/mssql-conf) don karɓar sharuɗɗan lasisi, saita kalmar wucewa don mai amfani da SA, kuma zaɓi bugun ku.

# /opt/mssql/bin/mssql-conf setup

4. Da zarar an gama daidaitawa, tabbatar da cewa sabis ɗin SQL Server yana gudana.

# systemctl status mssql-server

5. Bude tashar jiragen ruwa 1433/tcp akan Tacewar zaɓinku don ba da damar abokan ciniki na waje suyi sadarwa tare da uwar garken bayanan:

Idan kana amfani da firewalld:

# firewall-cmd --add-port=1433/tcp --permanent
# firewall-cmd --reload

In ba haka ba (ta amfani da iptables):

# iptables -A INPUT -p tcp --dport 1433 -j ACCEPT
# iptables-save > /etc/sysconfig/iptables

1. Domin Ubuntu ya amince da fakitin daga ma'ajiyar MS SQL Server, shigo da maɓallan GPG ta amfani da umarnin wget mai zuwa.

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

2. Ƙara maajiyar Microsoft SQL Server Ubuntu don samfoti na SQL Server 2019.

$ sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-preview.list)"
$ curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

3. Sake daidaita fayilolin fihirisar fakiti kuma sabunta ainihin fakitin da ƙarin kayan aikin:

$ sudo apt-get update
$ sudo apt-get install mssql-server mssql-tools unixodbc-dev -y

4. Gudanar da rubutun sanyi kamar yadda yake a cikin yanayin da ya gabata:

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

5. Zaɓi \Ee lokacin da aka sa ka karɓi sharuɗɗan lasisi na Kayan aikin MS SQL:

Gwajin MS SQL Server akan Linux

Za mu shiga cikin uwar garken kuma mu ƙirƙiri bayanan bayanai mai suna Fabrics. Maɓallin -P dole ne ya kasance ta hanyar kalmar sirri da kuka zaɓa lokacin da kuka shigar da fakitin a baya:

$ sqlcmd -S localhost -U SA -P 'YourPasswordHere'
CREATE DATABASE Fabrics
exit

Idan kuna amfani da Linux, zaku iya ci gaba da amfani da layin umarni kamar yadda aka nuna a sama. In ba haka ba, shigar da SQL Server Management Studio Express idan kuna kan Windows.

Da zarar an yi, shigar da IP na uwar garken bayanai (192.168.0.200 a cikin wannan yanayin) da kuma bayanan shiga (sunan mai amfani=sa, kalmar sirri=PasswordHere):

Bayan shiga cikin nasara, bayanan Fabrics ya kamata ya bayyana a gefen hagu:

Na gaba, danna Sabuwar Tambaya don buɗe sabuwar taga ta tambaya inda zaku saka abubuwan da ke cikin rubutun Fabrics daga Codeproject.com, sannan danna Execute.

Idan an yi nasara, za ku ga rubutun da aka ƙirƙira teburi 5 da adadin bayanai a kowane:

Don gamawa, gudanar da tambaya mai zuwa don dawo da bayanai 5 na farko daga teburin abokan ciniki:

USE Fabrics
SELECT TOP 5 FirstName, LastName,
DateOfBirth FROM Client
GO

Sakamakon yakamata ya zama daidai da abin da aka fitar a cikin hoto mai zuwa:

Taya murna! Kun yi nasarar shigar da gwada MS SQL Server akan Linux!

A cikin wannan labarin, mun bayyana yadda ake shigar MS SQL Server akan RHEL/CentOS da Ubuntu Server.

Saboda sabon kusancin Microsoft da Linux, masu gudanar da tsarin Linux za su buƙaci su kasance masu ilimi akan MS SQL Server idan suna son zama a saman wasan su.

A tsakiyar 2017, za a ba da bugu na SQL Server iri ɗaya akan Linux kamar yau akan Windows: Enterprise, Standard, Web, Express, and Developer. Biyu na ƙarshe kyauta ne amma bugu na Express kawai za a ba da lasisi don amfanin samarwa (amma tare da iyakokin albarkatu).

Kamar koyaushe, jin kyauta don amfani da fom ɗin sharhi da ke ƙasa don sauke mana bayanin kula idan kuna da tambayoyi. Muna jiran ji daga gare ku!