Maitiro ekuisa SQL Server mune yedu Ubuntu

Kuuya kweMicrosoft SQL Server kwakaita kuti vashandisi vazhinji vasashivirire uye vade kuyedza Microsoft nyowani yeUbuntu asi usakanganwa kuti ichiri mukuvandudza uye kwete yekushandisa mukugadzira michina.

Chero zvazvingava zviripo mukana wekuisa SQL Server muUbuntu hwedu pasina kuita zvinhu zvisinganzwisisike, isu tinongoda kuve neUbuntu pakombuta yedu neInternet kubatana kuisa Microsoft SQL Server.

Kuisirwa SQL Server

Microsoft maseva achiri eimba, saka mune ino kesi kuisa SQL Server yatinayo kutanga kuve nezvitupa zvekutora mafaera, saka tinovhura terminal muUbuntu uye toita zvinotevera:

sudo su

Kupinda nemvumo yemubati wechikwata.

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

Nezve izvi tinokumbira gwaro rekugona dhawunirodha mafaera kubva kuMicrosoft repository. Iye zvino tinonyora zvinotevera:

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

Uye neizvi isu tichawedzera iro repositi reMicrosoft kumatunhu edu.list saka Ubuntu ichagara ichigadzirisa software iyi.

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

SQL Server Kugadziriswa

Izvi zvichatanga iyo SQL Server kuisirwa. Asi ikozvino isu tinofanirwa kuigadzirisa. Kune izvi isu toshandisa chinyorwa chakagadzirwa neMicrosoft nekuda kwechinangwa ichi. Saka tinonyora zvinotevera:

sudo /opt/mssql/bin/sqlservr-setup

Kana tangopedza, isu tinofanirwa chete mhanyisa sevhisi kuitira kuti SQL Server itange muchikamu cheUbuntu, kunyangwe pese patinotanga Ubuntu inotanga otomatiki, saka tinonyora zvinotevera kuti titange sevha:

systemctl status mssql-server

Mhedziso

Sezvauri kuona, maitiro ekumisikidza ari nyore, maitiro ari nyore atinogona kushandisa tese, asi yeuka kuti SQL Server ichiri kuvandudzwaIyo vhezheni yekutarisa uye inogona kukonzera matambudziko, saka tinokurudzira kuti zviitwe mumuchina chaiwo uye kana uchikwanisa nemasevhisi mashoma, zvirinani, sezvo zvichikonzera kutadza kwakakomba. Usakanganwa izvozvo.