domingo, 27 de novembro de 2016

SQL Server on Linux

 I'm working on this..


https://www.youtube.com/watch?time_continue=8&v=oEpJB87Xg9U


https://www.microsoft.com/en-us/sql-server/sql-server-vnext-including-Linux
3


  25  cool-retro-term
   26  curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
    28  sudo apt install curl
    30  curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql-server.list
   31  sudo apt-get update
   32  sudo apt-get install -y mssql-server
   33  sudo /opt/mssql/bin/sqlservr-setup
   34  curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
   35  curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
   36  sudo apt-get update
   37  sudo apt-get install mssql-tools
   38  sqlcmd -S localhost -U SA -P ''







Funny, still NTFS style...
 

1> select name,filename from master..sysdatabases
2> go
name                                                                                                                             filename                                                                                                                                                                                                                                                           
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
master                                                                                                                           C:\var\opt\mssql\data\master.mdf                                                                                                                                                                                                                                   
tempdb                                                                                                                           C:\var\opt\mssql\data\tempdb.mdf                                                                                                                                                                                                                                   
model                                                                                                                            C:\var\opt\mssql\data\model.mdf                                                                                                                                                                                                                                    
msdb                                                                                                                             C:\var\opt\mssql\data\MSDBData.mdf                                                                                                                                                                                                                                 
Topazio                                                                                                                          C:\var\opt\mssql\data\Topazio


Postar um comentário