{"id":4271,"date":"2017-02-22T08:10:46","date_gmt":"2017-02-22T11:10:46","guid":{"rendered":"https:\/\/blog.clusterweb.com.br\/?p=4271"},"modified":"2017-02-22T08:10:46","modified_gmt":"2017-02-22T11:10:46","slug":"como-instalar-microsoft-sql-server-no-opensuse-linux","status":"publish","type":"post","link":"https:\/\/blog.clusterweb.com.br\/?p=4271","title":{"rendered":"COMO INSTALAR MICROSOFT SQL SERVER NO OPENSUSE LINUX"},"content":{"rendered":"

INTRODU\u00c7\u00c3O<\/h1>\n

Autor: Alessandro de Oliveira Faria (A.K.A. CABELO) <cabelo at opensuse.org>
\nData: 06\/02\/2017<\/p>\n

MS SQL Server<\/em> voltando as origens (*NIX), pois foi criado em parceria com SYBASE. At\u00e9 a vers\u00e3o 4.X (se n\u00e3o me engano), os dois banco de dados era praticamente id\u00eanticos. Utilizei muito o SYBASE<\/em> no Conectiva<\/em> Linux<\/a> em 1998.<\/p>\n

Agora o MS SQL est\u00e1 voltando ao ambiente Linux, baseado no SQL Server 2016, o pacote SQL Server for Linux proporciona todos os recursos para criar e desenvolver em uma \u00fanica plataforma Linux produtos de acesso em banco de dados, al\u00e9m do gerenciamento de dados e an\u00e1lise de neg\u00f3cios.<\/p>\n

Satya Nadella<\/em>, o CEO da Microsoft assumiu prover uma maior abertura ao GNU\/Linux<\/a>, e assim est\u00e1 acontecendo. Pois o produto SQL Server, uma das pe\u00e7as mais populares de software na estante Microsoft, foi disponibilizado para Linux, e veremos neste artigo como utiliz\u00e1-lo.<\/p>\n

\nPaula Bellizia e Alessandro Faria (Cabelo)<\/div>\n

O SQL Server for Linux<\/em> apresenta todas as principais caracter\u00edsticas que os usu\u00e1rios esperam deste produto. Depois de tornar open source o framework .NET para lev\u00e1-lo ao Linux e OS X, al\u00e9m de ter criado uma funda\u00e7\u00e3o para promover software de c\u00f3digo aberto, acredito que a decis\u00e3o de disponibilizar este banco de dados no ambiente GNU\/Linux \u00e9 um marco. Muitas m\u00e1quinas poder\u00e3o sair da ilegalidade com o Windows Server e utilizar a plataforma Linux junto ao servidor MSSQL.<\/p>\n<\/div>\n

<\/p>\n

M\u00c3O NA MASSA<\/h1>\n

 <\/p>\n

O ambiente utilizado neste documento foi o openSUSE Leap 42.2 64 bits<\/em>, estou elaborando uma imagem Linux<\/a> openSUSE (CLARO) para facilitar a vida de pessoas que n\u00e3o est\u00e3o acostumadas com as plataformas *NIX e derivados.<\/p>\n

Para iniciar, adicione o reposit\u00f3rio MS SQL Server conforme os comandos no exemplo a abaixo:<\/p>\n

<\/i> su<\/strong> # zypper ar https:\/\/packages.microsoft.com\/config\/sles\/12\/mssql-server.repo<\/strong>
\nAdicionando o reposit\u00f3rio ‘packages-microsoft-com-mssql-server’ …………..[conclu\u00eddo]
\nReposit\u00f3rio ‘packages-microsoft-com-mssql-server’ adicionado com sucesso
\nHabilitado\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Sim
\nAtualiza\u00e7\u00e3o autom\u00e1tica : N\u00e3o
\nVerifica\u00e7\u00e3o GPG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: Sim
\nPrioridade\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 99
\nURI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: https:\/\/packages.microsoft.com\/sles\/12\/mssql-server<\/samp><\/p>\n

<\/i> su
\n# zypper ar https:\/\/packages.microsoft.com\/config\/sles\/12\/mssql-server.repo<\/strong>
\nAdicionando o reposit\u00f3rio ‘packages-microsoft-com-mssql-server’ …………..[conclu\u00eddo]
\nReposit\u00f3rio ‘packages-microsoft-com-mssql-server’ adicionado com sucesso
\nHabilitado\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Sim
\nAtualiza\u00e7\u00e3o autom\u00e1tica : N\u00e3o
\nVerifica\u00e7\u00e3o GPG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: Sim
\nPrioridade\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 99
\nURI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: https:\/\/packages.microsoft.com\/sles\/12\/mssql-server<\/samp><\/p>\n

Ap\u00f3s adicionar o reposit\u00f3rio, utilize o comando refresh para atualiz\u00e1-lo:<\/p>\n

# zypper ref<\/strong>
\nBaixando os metadados do reposit\u00f3rio ‘packages-microsoft-com-mssql-server’ ———–[|]
\nChave de assinatura de novo reposit\u00f3rio ou pacote recebida:
\nReposit\u00f3rio:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 packages-microsoft-com-mssql-server
\nNome da chave:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Microsoft (Release signing) <gpgsecurity@microsoft.com>
\nImpress\u00e3o digital da chave:\u00a0\u00a0BC528686 B50D79E3 39D3721C EB3E94AD BE1229CF
\nChave criada em:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Qua 28 Out 2015 21:21:48 BRST
\nChave expira em:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 (n\u00e3o expira)
\nNome do RPM:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 gpg-pubkey-be1229cf-5631588c<\/p>\n

Voc\u00ea quer rejeitar a chave, confiar temporariamente ou confiar sempre? [r\/t\/s\/? exibe todas as op\u00e7\u00f5es] (r): s<\/strong>
\nBaixando os metadados do reposit\u00f3rio ‘packages-microsoft-com-mssql-server’ …[conclu\u00eddo]
\nConstruindo o cache do reposit\u00f3rio ‘packages-microsoft-com-mssql-server’ …..[conclu\u00eddo]
\nTodos os reposit\u00f3rios foram atualizados.<\/samp><\/p>\n

Com o reposit\u00f3rio atualizado, instale o pacote MS SQL SERVER conforme o comando abaixo:<\/p>\n

# zypper install mssql-server<\/strong>
\nCarregando dados do reposit\u00f3rio…
\nLendo os pacotes instalados…
\nResolvendo depend\u00eancias de pacote…<\/p>\n

O seguinte pacote NOVO ser\u00e1 instalado:<\/p>\n

mssql-server<\/p>\n

1 novo pacote a ser instalado.
\nTamanho total do download: 141,4 MiB. J\u00e1 em cache: 0 B. Ap\u00f3s a opera\u00e7\u00e3o, 669,3 MiB adicionais ser\u00e3o utilizados.
\nContinuar? [s\/n\/? exibe todas as op\u00e7\u00f5es] (s):
\nBaixando pacote mssql-server-14.0.200.24-2.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(1\/1), 141,4 MiB (669,3 MiB descompactado)
\nBaixando: mssql-server-14.0.200.24-2.x86_64.rpm ……………..[conclu\u00eddo (44,4 KiB\/s)]
\nVerificando por conflito de arquivos: ………………………………….[conclu\u00eddo]
\n(1\/1) Instalando: mssql-server-14.0.200.24-2.x86_64 ……………………..[conclu\u00eddo]<\/p>\n

Ao t\u00e9rmino do download e instala\u00e7\u00e3o, execute o comando sqlservr-setup, LEIA e se estiver de acordo, aceite o termo de licenciamento digitando “YES” precedido da tecla ENTER. Para terminar defina a senha do administrador do Banco de Dados e confirme a cria\u00e7\u00e3o dos link simb\u00f3licos para o init.d.<\/samp><\/p>\n

# \/opt\/mssql\/bin\/sqlservr-setup<\/strong>
\nMicrosoft(R) SQL Server(R) Setup<\/p>\n

You can abort setup at anytime by pressing Ctrl-C. Start this program
\nwith the –help option for information about running it in unattended
\nmode.<\/p>\n

The license terms for this product can be downloaded from
\nhttp:\/\/go.microsoft.com\/fwlink\/?LinkId=746388 and found
\nin \/usr\/share\/doc\/mssql-server\/LICENSE.TXT.<\/p>\n

Do you accept the license terms? If so, please type “YES”: YES
\nPlease enter a password for the system administrator (SA) account:
\nThe specified password does not meet SQL Server password policy requirements
\nbecause it is not complex enough. The password must be at least 8 characters
\nlong and contain characters from three of the following five sets: uppercase
\nletters, lowercase letters, numbers, non-alphanumeric characters, or unicode
\ncharacters that are categorized as alphabetic characters, but are not
\nuppercase or lowercase.<\/p>\n

Please enter a password for the system administrator (SA) account:
\nPlease confirm the password for the system administrator (SA) account:<\/p>\n

Setting system administrator (SA) account password…<\/p>\n

Do you wish to start the SQL Server service now? [y\/n]: y<\/strong>
\nDo you wish to enable SQL Server to start on boot? [y\/n]: y<\/strong>
\nCreated symlink from \/etc\/systemd\/system\/multi-user.target.wants\/mssql-server.service to \/usr\/lib\/systemd\/system\/mssql-server.service.<\/p>\n

Setup completed successfully.<\/samp><\/p>\n

Para verificar que o servidor MS SQL est\u00e1 funcionando corretamente, utilize o comando systemctl conforme o exemplo:<\/p>\n

# systemctl status mssql-server<\/strong>
\n\u25cf mssql-server.service – Microsoft(R) SQL Server(R) Database Engine
\nLoaded: loaded (\/usr\/lib\/systemd\/system\/mssql-server.service; enabled; vendor preset: disabled)
\nActive: active (running) since Seg 2017-01-23 17:51:28 BRST; 53s ago
\nMain PID: 3239 (sqlservr)
\nCGroup: \/system.slice\/mssql-server.service
\n\u251c\u25003239 \/opt\/mssql\/bin\/sqlservr
\n\u2514\u25003244 \/opt\/mssql\/bin\/sqlservr<\/p>\n

Jan 23 17:51:31 lenovo02.intel sqlservr[3239]: 2017-01-23 17:51:31.21 spid17s\u00a0\u00a0\u00a0\u00a0 A self-generated certificate was successfully loaded for encryption.
\nJan 23 17:51:31 lenovo02.intel sqlservr[3239]: 2017-01-23 17:51:31.22 spid17s\u00a0\u00a0\u00a0\u00a0 Server is listening on [ 0.0.0.0 <ipv4> 1433].
\nJan 23 17:51:31 lenovo02.intel sqlservr[3239]: 2017-01-23 17:51:31.22 Server\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Server is listening on [ 127.0.0.1 <ipv4> 1434].
\nJan 23 17:51:31 lenovo02.intel sqlservr[3239]: 2017-01-23 17:51:31.22 Server\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Dedicated admin connection support was established for listening locally on port 1434.
\nJan 23 17:51:31 lenovo02.intel sqlservr[3239]: 2017-01-23 17:51:31.22 spid17s\u00a0\u00a0\u00a0\u00a0 SQL Server is now ready for client connections. This is an informational message; no user ac…is required.
\nJan 23 17:51:31 lenovo02.intel sqlservr[3239]: 2017-01-23 17:51:31.35 spid7s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0The tempdb database has 1 data file(s).
\nJan 23 17:51:31 lenovo02.intel sqlservr[3239]: 2017-01-23 17:51:31.35 spid20s\u00a0\u00a0\u00a0\u00a0 The Service Broker endpoint is in disabled or stopped state.
\nJan 23 17:51:31 lenovo02.intel sqlservr[3239]: 2017-01-23 17:51:31.35 spid20s\u00a0\u00a0\u00a0\u00a0 The Database Mirroring endpoint is in disabled or stopped state.
\nJan 23 17:51:31 lenovo02.intel sqlservr[3239]: 2017-01-23 17:51:31.36 spid20s\u00a0\u00a0\u00a0\u00a0 Service Broker manager has started.
\nJan 23 17:51:31 lenovo02.intel sqlservr[3239]: 2017-01-23 17:51:31.43 spid5s\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Recovery is complete. This is an informational message only. No user action is required.
\nHint: Some lines were ellipsized, use -l to show in full.<\/samp><\/p>\n<\/div>\n

 <\/p>\n

INSTALANDO AS FERRAMENTAS CLIENTES E UTILIT\u00c1RIOS<\/h1>\n

 <\/p>\n

Para instalar as ferramentas clientes, devemos adicionar o reposit\u00f3rio da Microsoft conforme o exemplo abaixo. N\u00e3o esque\u00e7a de utilizar o comando zypper ref para atualizar o reposit\u00f3rio rec\u00e9m adicionado.<\/p>\n

# zypper ar https:\/\/packages.microsoft.com\/config\/sles\/12\/prod.repo<\/strong>
\nAdicionando o reposit\u00f3rio ‘packages-microsoft-com-prod’ ………………….[conclu\u00eddo]
\nReposit\u00f3rio ‘packages-microsoft-com-prod’ adicionado com sucesso
\nHabilitado\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Sim
\nAtualiza\u00e7\u00e3o autom\u00e1tica : N\u00e3o
\nVerifica\u00e7\u00e3o GPG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: Sim
\nPrioridade\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 99
\nURI\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0: https:\/\/packages.microsoft.com\/sles\/12\/prod<\/samp><\/p>\n

Utilize o comando zypper com os respectivos nomes dos pacotes MSSQL-TOOLS e unixODBC-devel para instalar os pacotes clientes e utilit\u00e1rios. Lembre-se de ler, e somente se estiver de acordo,aceite os termos de Licenciamento.<\/p>\n

# zypper install mssql-tools unixODBC-devel<\/strong>
\nCarregando dados do reposit\u00f3rio…
\nLendo os pacotes instalados…
\nResolvendo depend\u00eancias de pacote…<\/p>\n

Os seguintes 3 pacotes NOVOS ser\u00e3o instalados:
\nmsodbcsql mssql-tools unixODBC-devel<\/p>\n

3 novos pacotes a serem instalados.
\nTamanho total do download: 4,8 MiB. J\u00e1 em cache: 0 B. Ap\u00f3s a opera\u00e7\u00e3o, 17,2 MiB adicionais ser\u00e3o utilizados.
\nContinuar? [s\/n\/? exibe todas as op\u00e7\u00f5es] (s):
\nBaixando pacote msodbcsql-13.1.3.0-1.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(1\/3),\u00a0\u00a0 3,5 MiB ( 15,8 MiB descompactado)
\nBaixando: msodbcsql-13.1.3.0-1.x86_64.rpm …………………..[conclu\u00eddo (52,8 KiB\/s)]
\nBaixando pacote mssql-tools-14.0.2.0-1.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(2\/3),\u00a0\u00a0 1,2 MiB (\u00a0\u00a01,2 MiB descompactado)
\nBaixando: mssql-tools-14.0.2.0-1.x86_64.rpm …………………[conclu\u00eddo (47,2 KiB\/s)]
\nBaixando pacote unixODBC-devel-2.3.4-1.5.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(3\/3),\u00a0\u00a040,5 KiB (192,1 KiB descompactado)
\nBaixando: unixODBC-devel-2.3.4-1.5.x86_64.rpm …………………………..[conclu\u00eddo]
\nVerificando por conflito de arquivos: ………………………………….[conclu\u00eddo]
\n(1\/3) Instalando: msodbcsql-13.1.3.0-1.x86_64 —————————————-[|]The license terms for this product can be downloaded from
\nhttp:\/\/go.microsoft.com\/fwlink\/?LinkId=746838 and found in
\n\/usr\/share\/doc\/msodbcsql\/LICENSE.TXT . By entering ‘YES’,
\nyou indicate that you accept the license terms.<\/p>\n

Do you accept the license terms? (Enter YES or NO)
\nYES
\n(1\/3) Instalando: msodbcsql-13.1.3.0-1.x86_64 …………………………..[conclu\u00eddo]
\n(2\/3) Instalando: mssql-tools-14.0.2.0-1.x86_64 ————————————–[-]The license terms for this product can be downloaded from
\nhttp:\/\/go.microsoft.com\/fwlink\/?LinkId=746949 and found in
\n\/usr\/share\/doc\/mssql-tools\/LICENSE.txt . By entering ‘YES’,
\nyou indicate that you accept the license terms.<\/p>\n

Do you accept the license terms? (Enter YES or NO)
\nYES
\n(2\/3) Instalando: mssql-tools-14.0.2.0-1.x86_64 …………………………[conclu\u00eddo]
\n(3\/3) Instalando: unixODBC-devel-2.3.4-1.5.x86_64 ……………………….[conclu\u00eddo]<\/samp><\/p>\n

Crie os links simb\u00f3licos na pasta \/usr\/bin como super-usu\u00e1rio:<\/p>\n

# ln -sfn \/opt\/mssql-tools\/bin\/sqlcmd-13.0.1.0 \/usr\/bin\/sqlcmd
\n# ln -sfn \/opt\/mssql-tools\/bin\/bcp-13.0.1.0 \/usr\/bin\/bcp<\/strong><\/p>\n

Para acessar o servidor utilizando o comando SQLCMD, deixo alguns exemplos de manipula\u00e7\u00e3o e uso desta servi\u00e7o\/ferramenta.<\/p>\n

<\/i> sqlcmd -S [IP-SERVIDOR] -U SA -P [SENHA DO ADMINISTRATIVA]<\/strong>
\n1><\/p>\n

Testando consultas SQL no console:<\/p>\n

1> SELECT Name from sys.Databases;<\/strong>
\n2> GO<\/strong>
\nName
\n—————————-
\nmaster
\ntempdb
\nmodel
\nmsdb
\n(4 rows affected)<\/samp><\/p>\n

Criando banco de dados:<\/p>\n

1> CREATE DATABASE testdb;<\/strong>
\n2> GO<\/strong>
\n1><\/p>\n

Utilizando\/abrindo o banco de dados desejado:<\/p>\n

1> USE testdb;<\/strong>
\n2> GO<\/strong>
\nChanged database context to ‘testdb’.<\/p>\n

Criando tabelas:<\/p>\n

1> CREATE TABLE inventory (id INT, name NVARCHAR(50), quantity INT);<\/strong>
\n2> GO<\/strong>
\n1>
\n(1 rows affected)<\/p>\n

Inserindo dados na tabela:<\/p>\n

1> INSERT INTO inventory VALUES (1, ‘banana’, 150);<\/strong>
\n2> INSERT INTO inventory VALUES (2, ‘orange’, 154);<\/strong>
\n3> GO<\/strong> (1 rows affected)<\/p>\n

Consultando dados:<\/p>\n

1> SELECT * FROM inventory WHERE quantity > 152;<\/strong>
\n2> GO<\/strong><\/p>\n

id          name                                               quantity   \r\n----------- -------------------------------------------------- -----------\r\n          2 orange                                                     154\r\n(1 rows affected)\r\n<\/pre>\n
1>
\n1> QUIT<\/strong><\/p>\n
Para remover o servi\u00e7o, use o comando zypper com o par\u00e2metro rm e exclus\u00e3o da pasta \/var\/opt\/mssql\/:<\/p>\n
# zypper remove mssql-server<\/strong>
\nCarregando dados do reposit\u00f3rio…
\nLendo os pacotes instalados…
\nResolvendo depend\u00eancias de pacote…<\/p>\n
O seguinte pacote ser\u00e1 REMOVIDO:
\nmssql-server<\/p>\n
1 pacote para remover.
\nAp\u00f3s a opera\u00e7\u00e3o, 669,3 MiB ser\u00e1 liberado.
\nContinuar? [s\/n\/? exibe todas as op\u00e7\u00f5es] (s):
\n(1\/1) Removendo mssql-server-14.0.200.24-2.x86_64 ……………………….[conclu\u00eddo]<\/samp><\/p>\n
# rm -rf \/var\/opt\/mssql\/<\/strong><\/div>\n","protected":false},"excerpt":{"rendered":"
INTRODU\u00c7\u00c3O Autor: Alessandro de Oliveira Faria (A.K.A. CABELO) <cabelo at opensuse.org> Data: 06\/02\/2017 MS SQL Server voltando as origens (*NIX), pois foi criado em parceria com SYBASE. At\u00e9 a vers\u00e3o 4.X (se n\u00e3o me engano), os dois banco de dados era praticamente id\u00eanticos. Utilizei muito o SYBASE no Conectiva Linux em 1998. Agora o MS […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[730,1,830,42,51,495],"tags":[803,378,699,14,1028,361,1029,759,161],"class_list":["post-4271","post","type-post","status-publish","format-standard","hentry","category-clusterweb","category-viazap","category-debian","category-leitura-recomendada","category-linux-linuxrs","category-profissional-de-ti","tag-clusterweb","tag-como","tag-instalar","tag-linux","tag-microsoft","tag-no","tag-opensuse","tag-server","tag-sql"],"_links":{"self":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/4271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4271"}],"version-history":[{"count":1,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/4271\/revisions"}],"predecessor-version":[{"id":4272,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=\/wp\/v2\/posts\/4271\/revisions\/4272"}],"wp:attachment":[{"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.clusterweb.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}