SQL version: SQL Server 2019
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/20.04/mssql-server-2019.list)"
apt update
apt install -y mssql-server
/opt/mssql/bin/mssql-conf setup
systemctl status mssql-server --no-pager
apt update
apt install curl
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
apt update
apt install mssql-tools unixodbc-dev
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
create database test;
go
select name from sys.databases;
go
use test;
go
create table tab1(col1 int);
insert into tab1 values(1);
select * from tab1;
go
(10)
https://linux-tips.com/t/installing-microsoft-sql-server-on-debian-linux/476
SQL version: SQL Server 2019
apt install -y curl gnupg2
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/18.04/mssql-server-2019.list | \sudo tee /etc/apt/sources.list.d/mssql-server.list
apt update
apt install -y mssql-server
/opt/mssql/bin/mssql-conf setup
systemctl status mssql-server --no-pager
curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
apt update
apt install mssql-tools unixodbc-dev
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
sqlcmd -S localhost -U SA
create database test;
go
select name from sys.databases;
go
use test;
go
create table tab1(col1 int);
insert into tab1 values(1);
select * from tab1;
go
SQL version: SQL Server 2019
alternatives --config python
dnf install python2
dnf install compat-openssl10
alternatives --config python
curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo
dnf install -y mssql-server
/opt/mssql/bin/mssql-conf setup
systemctl status mssql-server
curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/8/prod.repo
dnf remove unixODBC-utf16 unixODBC-utf16-devel
dnf install -y mssql-tools unixODBC-devel
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
create database test;
go
select name from sys.databases;
go
use test;
go
create table tab1(col1 int);
insert into tab1 values(1);
select * from tab1;
go
- Windows Server
(2019)
https://docs.microsoft.com/ja-jp/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver15
https://docs.microsoft.com/ja-jp/sql/database-engine/install-windows/install-sql-server-using-a-configuration-file?view=sql-server-ver15
https://docs.microsoft.com/ja-jp/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
SQL version: SQL Server 2019
cd c:\
notepad a.ini
[OPTIONS]
IAcceptSQLServerLicenseTerms="True"
IACCEPTPYTHONLICENSETERMS="False"
ACTION="Install"
IACCEPTROPENLICENSETERMS="False"
SUPPRESSPRIVACYSTATEMENTNOTICE="False"
ENU="False"
QUIET="True"
UpdateEnabled="False"
USEMICROSOFTUPDATE="False"
SUPPRESSPAIDEDITIONNOTICE="True"
FEATURES=SQLENGINE
HELP="False"
INDICATEPROGRESS="False"
X86="False"
INSTANCENAME="MSSQLSERVER"
INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"
INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"
INSTANCEID="MSSQLSERVER"
SQLTELSVCACCT="NT Service\SQLTELEMETRY"
SQLTELSVCSTARTUPTYPE="Automatic"
INSTANCEDIR="C:\Program Files\Microsoft SQL Server"
AGTSVCACCOUNT="NT Service\SQLSERVERAGENT"
AGTSVCSTARTUPTYPE="Manual"
COMMFABRICPORT="0"
COMMFABRICNETWORKLEVEL="0"
COMMFABRICENCRYPTION="0"
MATRIXCMBRICKCOMMPORT="0"
SQLSVCSTARTUPTYPE="Automatic"
FILESTREAMLEVEL="0"
SQLMAXDOP="2"
ENABLERANU="False"
SQLCOLLATION="Japanese_CI_AS"
SQLSVCACCOUNT="NT Service\MSSQLSERVER"
SQLSVCINSTANTFILEINIT="True"
SQLSYSADMINACCOUNTS="MMM063\Administrator"
SQLTEMPDBFILECOUNT="2"
SQLTEMPDBFILESIZE="8"
SQLTEMPDBFILEGROWTH="64"
SQLTEMPDBLOGFILESIZE="8"
SQLTEMPDBLOGFILEGROWTH="64"
ADDCURRENTUSERASSQLADMIN="False"
TCPENABLED="1"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Disabled"
USESQLRECOMMENDEDMEMORYLIMITS="True"
cd e:\
.\setup.exe /ConfigurationFile="C:\a.ini"
-- SSMSのインストール
start "" /w .\SSMS-Setup-JPN.exe /Quiet SSMSInstallRoot=C:\SSMS
-- データベース作成
mkdir C:\DATA
USE master;
GO
CREATE DATABASE test
CONTAINMENT = NONE
ON PRIMARY
( NAME = test_dat,
FILENAME = 'C:\DATA\test_dat.mdf',
SIZE = 8MB,
FILEGROWTH = 64MB )
LOG ON
( NAME = test_log,
FILENAME = 'C:\DATA\test_log.ldf',
SIZE = 8MB,
FILEGROWTH = 64MB ) ;
GO
