Makon da ya gabata mun sami damar haɗuwa samfurin samfoti na SQL Server don Gnu / Linux, sigar da duk da cewa tana cikin gwaji ana iya sanya ta akan kowace kwamfutar Linux. Wannan sigar ta shirya ta yadda yana da sauƙin girkawa a cikin Ubuntu amma ana iya girka ta a cikin kowane irin rarraba kamar Fedora.
A cikin wannan ƙaramin koyawa Muna gaya muku yadda ake yin sa cikin sauƙi da sauri Ba tare da samun cikakken ilimi game da rumbunan adana bayanai ba, amma don aiki yadda ya kamata da shi, dole ne mu san wani abu game da rumbunan adana bayanai.
SQL Server kafuwa
Kamar yadda yake tare da shirye-shirye da yawa na kwanan nan, Ba za a iya samun SQL Server a cikin wuraren ajiya na Fedora ba, don haka da farko dole ne mu sanya su cikin wuraren ajiya ta hanyar rubuta waɗannan a cikin tashar mota:
sudo su - curl https://packages.microsoft.com/config/rhel/7/mssql-server.repo & /etc/yum.repos.d/mssql-server.repo curl https://packages.microsoft.com/config/rhel/7/prod.repo & /etc/yum.repos.d/msprod.repo exit
Da zarar mun ƙara waɗannan wuraren, yanzu dole ne mu girka bayanan Microsoft a cikin rarraba kuma muna yin shi kamar haka:
sudo dnf -y install mssql-server mssql-tools
Kanfigareshan Server na SQL akan Fedora
Sannan dole ne mu fara rubutun daidaitawa, amma saboda wannan dole ne mu fara bude tashar da SQL Server zai yi amfani da ita, don wannan za mu rubuta mai zuwa:
sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent sudo firewall-cmd --reload
Kuma bayan wannan, yanzu zamu iya fara daidaita bayanan bayanai:
sudo /opt/mssql/bin/sqlservr-setup
Yanzu ga fara sabis lokacin da muka fara Fedora mun rubuta masu zuwa:
sudo systemctl enable mssql-server mssql-server-telemetry
Kuma idan muna son fara sabis ɗin SQL Server a cikin zaman da muke gudana, to dole ne muyi haka:
sudo systemctl start mssql-server mssql-server-telemetry
Kuma wannan shine duk abin da yakamata kayi don samun SQL Server a cikin Fedora, duk da haka dole ka tuna cewa Preview ne, wato, ba tabbatacce bane, don haka ya zama dole kuyi taka tsan-tsan da aikin da muka bari wannan sabon software yayi a Gnu / Linux.
Zai zama dacewa don sanya madaidaicin suna: Sabar MS sql, saboda "sql server" duk sune: oracle, postgresql, firebird, mysql, interbase, da dai sauransu.