#sqlcmd

Quick Tip 12 – Como Instalar o SQLCMD no MacOS

Olá PessoALL! O SQLCMD é instalado através do gerenciador de pacotes HomeBrew,.Se você não tem instalado veja o link: https://brew.sh/  Atualizada e Instala – #Registra o caminho do GitHub #Atualiza a biblioteca local e instala brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release brew update brew install mssql-tools Sabemos que na maioria dos casos, ao iniciar…

SQL Server TCP and UDP Ports

SQL Server is a complex application that can be difficult to allow access to through a firewall. The subsystems and features that Microsoft has added—and continues to add—to SQL Server have significantly increased the network connections that the platform uses. Sometime it’s difficult to figure out which firewall ports to open for each SQL Server feature. To help you, here’s a rundown of…

SQLCMD variables for input SQL file

In short, this is an example of how you do it. Set a couple of variables, use -v parameter sqlcmdVariable=”%batVariable%”.

The following contains more details on how to use SQLCMD variables for an input SQL file. Note, I am not advising you to you use this as your routine backup method. If you’re looking for a backup process, there are much better methods.

0.Run.bat

REM cmd /K "cd /d…

Getting started with SQL Server Tools

This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques to build applications using SQL Server tools. The first article of the series covers the rudimentary DevOps concepts and discusses on a high level, the overview of SQL Server tools that can be piped for DevOps operations.

In this article, I will explore various SQL tools. I will…

SQL Server DevOps Tools

This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques to build applications using SQL Server tools. The first article of the series covers the rudimentary DevOps concepts and discusses on a high level, the overview of SQL Server tools that can be piped for DevOps operations. In this article, I will explore various SQL tools. I will…

bcp Utility

Microsoft® ODBC Driver 13 for SQL Server

https://www.microsoft.com/en-us/download/details.aspx?id=50420

には、sqlcmdとbcpは入ってない。

sqlcmdとbcpは別パッケージ、何故かリンクは無い。

Microsoft® Command Line Utilities 13 for SQL Server

SQL Server TCP and UDP Ports

SQL Server is a complex application that can be difficult to allow access to through a firewall. The subsystems and features that Microsoft has added—and continues to add—to SQL Server have significantly increased the network connections that the platform uses. Sometime it’s difficult to figure out which firewall ports to open for each SQL Server feature. To help you, here’s a rundown of…