Usando el Shell instalaremos Microsoft SQL SERVER 2019 en Linux Microsoft Azure
Implementaremos con línea de comandos usando el Shell el Microsoft SQL Server 2019 en Linux Centos.
Link de descarga: https://docs.microsoft.com/en-us/sql/...
Comandos usados:
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config...
sudo yum install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup
1
yes
systemctl status mssql-server
sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config...
sudo yum install -y mssql-tools unixODBC-devel
yes
yes
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' ~/.bashrc
source ~/.bashrc
sqlcmd -S localhost -U sa -P 'Pruebaadministrador123'
Create database TestDB
go
Select Name from Sys.Databases
go
Use TestDB
go
Create table inventario(id INT, nombre NVARCHAR(50),Cantidad INT)
go
Insert into inventario vallues(1,'Platano', 150)
go
Insert into inventario vallues(2,'Naranja', 154)
go
Insert into inventario vallues(1,'Manzana', 160)
go
select *from inventario
-----------------------------------------
-----------------------------------------
Donwload SQL ServerManagement Studio
https://docs.microsoft.com/en-us/sql/...
SELECT * FROM SYS.DATABASES
-----------------------------------------
-----------------------------------------
sqlcmd -S localhost -U sa -P 'Pruebaadministrador123'
select fname from sys.databases
go