Kei te tautokohia te SQL Server i runga i te Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), me te Ubuntu. Ka tautokohia ano he ahua Docker, ka taea te whakahaere i runga i te Docker Engine i runga i te Linux, i te Docker ranei mo Windows/Mac.
Me pehea te whakauru i te Microsoft SQL Server ki Linux?
Me pehea te whakauru i te SQL Server i runga i te Linux
- Tāutahia te Tūmau SQL ki Ubuntu. Hipanga 1: Taapirihia te Kī Pupuri. Hipanga 2: Taapirihia te Putaka Tūmau SQL. Hipanga 3: Tāuta Tūmau SQL. Hipanga 4: Whirihorahia te SQL Server.
- Tāutahia te Tūmau SQL i runga i te CentOS 7 me te Red Hat (RHEL) Hipanga 1: Taapirihia te Putaka Tūmau SQL. Hipanga 2: Tāuta Tūmau SQL. Hipanga 3: Whirihorahia te SQL Server.
Ko tehea putanga o SQL Server e hototahi ana ki te Linux?
Tūmau SQL 2017 (RC1) kei te tautokohia i runga i te Red Hat Enterprise Linux (7.3), SUSE Linux Enterprise Server (v12 SP1), Ubuntu (16.04 me 16.10), me te Docker Engine (1.8 me te teitei ake). Ko te SQL Server 2017 e tautoko ana i nga punaha konae XFS me ext4—kaore e tautokona etahi atu punaha konae.
Kei te pumau te SQL Server i runga i te Linux?
Kei a Microsoft i hanga he putanga pumau e mahi pai ana i runga i te Linux pera i runga i te Matapihi (a, i etahi wa, he pai ake). Kei te ngawari a Microsoft ki te heke i o raraunga ki tana papaahi me te whainga ki te manaaki i o raraunga ki Azure.
Me pehea taku hono atu ki te SQL Server i Linux?
Hei hono ki tetahi tauira ingoa, whakamahia te whakahōputu ingoa mihini instancename . Hei hono atu ki tetahi tauira SQL Server Express, whakamahia te whakahōputu ingoa miihini SQLEXPRESS. Hei hono atu ki tetahi tauira SQL Server kaore i te whakarongo ki te tauranga taunoa (1433), whakamahia te whakahōputu ingoa mihini :port .
Me pehea taku whakahaere i tetahi patai SQL i Linux?
Waihangahia he tauira raraunga
- I runga i to miihini Linux, whakatuwherahia he huihuinga tauranga bash.
- Whakamahia te sqlcmd ki te whakahaere i tetahi tono Transact-SQL CREATE DATABASE. Tārua Bash. /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -Q 'HAI WHAI PARANGA TAUira SampleDB'
- Manatokohia kua hangahia te papaaarangi ma te whakaraarangi i nga papaarangi i runga i to tuumau. Tārua Bash.
He kore utu a Microsoft SQL Server?
Ko te SQL Server 2019 Express he putanga kore utu o SQL Server, he pai mo te whanaketanga me te hanga mo te papamahi, tukutuku, me nga tono tūmau iti.
Me pehea taku mohio mena kua whakauruhia a SQL Server ki Linux?
Hei manatoko i to putanga me to putanga o te SQL Server i runga i te Linux, whakamahia te tikanga e whai ake nei:
- Mena kaore ano kia whakauruhia, whakauruhia nga taputapu raina whakahau SQL Server.
- Whakamahia te sqlcmd hei whakahaere i tetahi tono Transact-SQL e whakaatu ana i to putanga me to putanga SQL Server. Tārua Bash. sqlcmd -S localhost -U SA -Q 'tīpako @@VERSION'
He aha te rereketanga i waenga i te mysql me te SQL Server?
Ko te SQL he reo patai, engari ko MySQL he papaunga paaunga e whakamahi ana i te SQL ki te uiui a pātengi raraunga. Ka taea e koe te whakamahi i te SQL ki te uru atu, ki te whakahou, ki te raweke i nga raraunga kua penapena ki roto i te papaa raraunga. Heoi ano, ko MySQL he putunga raraunga e penapena ana i nga raraunga o naianei ki roto i te papaaarangi i runga i nga tikanga whakarite.
Me pehea taku kimi i te putanga Linux?
Tirohia te putanga os i Linux
- Whakatūwherahia te tono kāpeka (bash shell)
- Mo te takiuru tūmau mamao ma te whakamahi i te ssh: ssh user@server-name.
- Patohia tetahi o nga whakahau e whai ake nei kia kitea te ingoa os me te putanga ki Linux: cat /etc/os-release. lsb_release -a. hostnamectl.
- Patohia te whakahau e whai ake nei kia kitea te putanga kernel Linux: uname -r.
Ka taea e SQL Server te whakahaere i runga i te Ubuntu?
Ka tautokohia te Ubuntu 18.04 me te timata Tūmau SQL 2017 CU20. Mena kei te hiahia koe ki te whakamahi i nga tohutohu mo tenei tuhinga me te Ubuntu 18.04, kia mohio koe kei te whakamahi koe i te huarahi rokiroki tika, 18.04 hei utu mo te 16.04. Mena kei te whakahaere koe i te SQL Server i runga i te putanga iti, ka taea te whirihoranga me nga whakarereketanga.
He aha nga ahuatanga kaore i tautokohia i runga i te SQL Server 2019 i runga i te Linux?
Nga here o te tūmau SQL i runga i te Linux:
- Pūkaha pātengi raraunga. * Rapu Kuputuhi-katoa. * Tukurua. * Totoro DB. …
- Te waatea teitei. * I nga wa katoa kei runga i nga roopu waatea. * Whakaata Raraunga Raraunga.
- Haumarutanga. * Motuhēhēnga Active Directory. * Motuhēhēnga Windows. * Whakahaerenga Matua Whakawhanui. …
- Ratonga. * Kaiwhakahaere Tūmau SQL. * Pūtirotiro Tūmau SQL.
Me pehea taku tango i te SQL Server i Linux?
Tāutahia te SQL Server 2019 ki runga i nga ipu Windows, Linux me Docker
- Matapihi. Whakahaerehia te SQL Server ki Windows, hei Miihini Mariko ranei i Azure. Whiriwhiria to tautuhinga whakaurunga.
- Linux. Whakahaerehia te SQL Server 2019 i runga i te Linux. Whiriwhiria to tautuhinga whakaurunga.
- Docker. Whakahaerehia te ahua ipu a SQL Server 2019 me Docker. Whiriwhiria to tautuhinga whakaurunga.