@manhnguyenv

Welcome to my blog!

Run Big Sql Server File

December 31, 2019 09:40

Run Big Sql Server File (edit)

https://docs.microsoft.com/en-us/sql/tools/sqlcmd-utility?view=sql-server-ver15&viewFallbackFrom=sql-server-previousversions

You have to install the Client SDK Tools

Folder: C:\Program Files\Microsoft SQL Server\110\Tools\Binn\

File: SQLCMD.EXE

SQLCMD.EXE -S (local) -U myusername -P mypassword -d DBNAME_HERE -i "D:\3.sql"
"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE" -S Localhost -U SAAccount -P YourPassword -d DEV -i "D:\1.sql"
"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE" -S Localhost -U SAAccount -P YourPassword -d DEV -i "D:\2.sql"

Categories

Recent posts