SqlServer linux - Ubuntu

Post date: Nov 20, 2016 1:49:08 PM

sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent sudo firewall-cmd --reload

Creare nuovo database per SqlServer linux

USE master ; GO CREATE DATABASE Sales ON ( NAME = Sales_dat, FILENAME = '/var/opt/mssql/data/saledat.mdf',

SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ) LOG ON ( NAME = Sales_log, FILENAME = '/var/opt/mssql/data/saledat.ldf',

SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB ) ; GO

RESTORE DATABASE [AdventureWorks] FROM DISK = N‘/var/opt/mssql/data/AdventureWorks2014.bak' WITH MOVE 'AdventureWorks2014_Data' TO N'/var/opt/mssql/data/AdventureWorks2014_Data.mdf', MOVE 'AdventureWorks2014_Log' TO N'/var/opt/mssql/data/AdventureWorks2014_Log.ldf';