Bii o ṣe le Fi sii ati Lo MS SQL Server lori Lainos

Ni ọdun 2016, Microsoft ṣe iyalẹnu aye IT pẹlu ikede ti awọn ero wọn lati mu MS SQL Server si Linux.

Labẹ itọsọna Satya Nadella, omiran Redmond ti ṣe ilọsiwaju pataki si lilo anfani awọn agbegbe nibiti Linux ṣe ṣakoso ile-iṣẹ naa (gẹgẹbi awọn imọ-ẹrọ ti o ni agbara awọsanma). Gbe lati ṣe Server SQL wa ni Lainos jẹ itọkasi miiran ti ọna yii.

Ohunkohun ti awọn iwuri ti ile-iṣẹ lẹhin ipilẹṣẹ yii, o ṣeeṣe ki awọn alakoso eto Lainos nilo lati kọ bi a ṣe le fi sori ẹrọ, ṣetọju, ati lo MS SQL Server - ni pataki ni imọran pe awọn idii ẹya awotẹlẹ ti wa tẹlẹ fun Red Hat Enterprise Linux 7.3+ (pẹlu CentOS 7.3 + bakanna) ati awọn ege Ubuntu Server 16.04 (binu - ko si ẹya 32-bit ti o wa!).

Ibeere eto\"fancy" nikan ti ikede awotẹlẹ ni pe eto nibiti o ti fi sii gbọdọ ni o kere ju 2 GB ti Ramu.

Fifi MS SQL Server sori Linux

Ninu nkan iyara yii, a yoo ṣalaye bi a ṣe le fi awotẹlẹ SQL Server 2019 sori ẹrọ lori awọn idasilẹ RHEL/CentOS 7.3 + ati Ubuntu 16.04.

1. Lati fi SQL Server sori awọn idasilẹ RHEL/CentOS 7.3+, ṣe igbasilẹ Microsoft SQL Server 2019 awotẹlẹ awọn faili iṣeto Red Hat ibi ipamọ, eyiti yoo fi sori ẹrọ package mssql-server ati awọn irinṣẹ mssql nipa lilo awọn ofin ọmọ-atẹle wọnyi.

# 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. Lẹhinna fi SQL Server ati mssql-irinṣẹ sori ẹrọ pẹlu ohun elo Olùgbéejáde unixODBC nipa lilo oluṣakoso package yum, bi o ti han.

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

3. Nigbati fifi sori ba pari, iwọ yoo leti lati ṣiṣe iwe afọwọkọ iṣeto (/ opt/mssql/bin/mssql-conf) lati gba awọn ofin iwe-aṣẹ, ṣeto ọrọ igbaniwọle fun olumulo SA, ati yan àtúnse rẹ.

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

4. Lọgan ti iṣeto naa ti pari, ṣayẹwo pe iṣẹ SQL Server n ṣiṣẹ.

# systemctl status mssql-server

5. Ṣi ibudo 1433/tcp lori ogiri ogiri rẹ lati gba awọn alabara ita laaye lati ṣe ibasọrọ pẹlu olupin data:

Ti o ba nlo firewalld:

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

Bibẹẹkọ (lilo awọn iptables):

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

1. Ni ibere fun Ubuntu lati gbẹkẹle awọn idii lati awọn ibi ipamọ MS SQL Server, gbe awọn bọtini GPG wọle nipa lilo pipaṣẹ wget atẹle.

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

2. Ṣafikun ibi ipamọ Ubuntu Server Microsoft SQL fun awotẹlẹ 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. Tun awọn faili atọka package ṣiṣẹ pọ ki o mu imudojuiwọn akopọ koko ati awọn irinṣẹ afikun pọ:

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

4. Ṣiṣe iwe afọwọkọ iṣeto bi ninu ọran iṣaaju:

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

5. Yan\"Bẹẹni" nigbati o ba ṣetan lati gba awọn ofin iwe-aṣẹ fun Awọn irinṣẹ MS SQL:

Idanwo MS SQL Server lori Linux

A yoo buwolu wọle si olupin naa ki o ṣẹda ipilẹ data ti a npè ni Awọn aṣọ. Yipada -P gbọdọ wa ni atẹle nipasẹ ọrọ igbaniwọle ti o yan nigbati o fi sori ẹrọ package tẹlẹ:

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

Ti o ba nlo Lainos, o le tẹsiwaju lilo laini aṣẹ bi o ti han loke. Bibẹkọkọ, fi sori ẹrọ Studio Express Management Management SQL ti o ba wa lori Windows.

Lọgan ti o ti ṣe, tẹ IP ti olupin data (192.168.0.200 ninu ọran yii) ati awọn ẹrí iwọle (orukọ olumulo = sa, ọrọigbaniwọle = YourPasswordHere):

Lori ibuwolu wọle aṣeyọri, ibi ipamọ data Awọn aṣọ yẹ ki o han ni apa osi-ọwọ-ọwọ:

Nigbamii, tẹ Ibeere Tuntun lati ṣii window ibeere tuntun nibiti iwọ yoo fi sii awọn akoonu ti iwe afọwọkọ lati Codeproject.com, lẹhinna tẹ Ṣiṣẹ.

Ti o ba ṣaṣeyọri, iwọ yoo wo iwe afọwọkọ ti o ṣẹda awọn tabili 5 ati nọmba awọn igbasilẹ ni ọkọọkan:

Lati fi ipari si, ṣiṣe ibeere atẹle lati gba awọn igbasilẹ akọkọ 5 akọkọ lati tabili Awọn onibara:

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

Awọn abajade yẹ ki o jẹ aami kanna si iṣẹjade ni aworan atẹle:

Oriire! O ti fi sori ẹrọ daradara ati idanwo MS SQL Server lori Linux!

Ninu nkan yii, a ti ṣalaye bi o ṣe le fi MS SQL Server sori RHEL/CentOS ati Ubuntu Server.

Nitori isunmọ tuntun ti Microsoft ati Lainos, awọn alakoso eto Linux yoo nilo lati ni oye lori MS SQL Server ti wọn ba fẹ lati duro ni oke ere wọn.

Ni aarin-ọdun 2017, awọn ẹda SQL Server kanna ni yoo funni lori Linux bi oni lori Windows: Idawọlẹ, Standard, Web, Express, ati Olùgbéejáde. Awọn meji ti o kẹhin jẹ ọfẹ ṣugbọn itọsọna Express nikan ni yoo ni iwe-aṣẹ fun lilo iṣelọpọ (ṣugbọn pẹlu awọn opin awọn orisun).

Gẹgẹbi igbagbogbo, ni ọfẹ lati lo fọọmu asọye ni isalẹ lati sọ akọsilẹ wa silẹ ti o ba ni ibeere eyikeyi. A n reti lati gbọ lati ọdọ rẹ!