Uyifaka njani i-SQL Server kwi-Ubuntu bethu

Ukufika kwe-Microsoft SQL Server kwenze abasebenzisi abaninzi baphelelwa ngumonde kwaye bafuna ukuzama iMicrosoft entsha ye-Ubuntu kodwa ungalibali ukuba isaphuhlisiwe kwaye ayisetyenziselwa izixhobo zemveliso.

Ngayiphi na imeko kukho ukubakho kokufaka iSQL Server ku-Ubuntu bethu Ngaphandle kokwenza izinto ezingaqhelekanga, kufuneka kuphela ukuba sibe no-Ubuntu kwikhompyuter yethu kunye nonxibelelwano lwe-Intanethi ukufaka iSQL Server yeMicrosoft.

Ukufakwa kwe-SQL Server

Iiseva zikaMicrosoft zisesekunini, ke kule meko ukufaka iSQL Server esinayo okokuqala ukuba neziqinisekiso zokukhuphela iifayile, ke sivula i-terminal ku-Ubuntu kwaye senze oku kulandelayo:

sudo su

Ukungena ngemvume yomlawuli weqela.

curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

Ngale nto sicela ubungqina ukuze sikwazi khuphela iifayile kwindawo yokugcina iMicrosoft. Ngoku sibhala oku kulandelayo:

curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list & /etc/apt/sources.list.d/mssql-server.list

Kwaye ngale nto siza kuyongeza Indawo yokugcina yeMicrosoft kwimithombo yethu yolwazi ke Ubuntu iya kuhlala ihlaziya le software.

exit
sudo apt-get update
sudo apt-get install -y mssql-server

Uqwalaselo lwe-SQL Server

Oku kuyakuqala ukufakelwa kweServer SQL Kodwa ngoku kufuneka siyiqwalasele. Ngale nto siza kuyisebenzisa Isicatshulwa esenziwe nguMicrosoft ukulungiselela le njongo. Ke sibhala oku kulandelayo:

sudo /opt/mssql/bin/sqlservr-setup

Nje ukuba sigqibe, kufuneka nje sebenzisa inkonzo ukuze iSQL Server iqale kwiseshoni Ubuntu, nangona nanini na xa siqala Ubuntu iya kuqala ngokuzenzekelayo, ke sibhala oku kulandelayo ukuqala iserver:

systemctl status mssql-server

Isiphelo

Njengoko ubona, inkqubo yokufaka ilula, inkqubo elula esinokuyisebenzisa sonke, kodwa khumbula ukuba i-SQL Server isephantsi kophuhlisoInguqulelo yokujonga kuqala kwaye inokubangela iingxaki, ke sicebisa ukuba yenziwe kumatshini obonakalayo kwaye ukuba unako ngeenkonzo ezimbalwa, ngcono, njengoko inokubangela ukusilela okubalulekileyo. Ungalibali.