To execute a SQL file using the command line

When importing SQL Server database with Navicat, there was an out of memory exception, Baidu has no fruit, think of the command line imported before, again try a success

Usage:

Open the Execute command:

Sqlcmd-s localhost-u sa-p 1-d yanan-i yanan.sql

-S server address- u user name- p password - D database name-I script file path

Note: In some cases,-p must be 1, otherwise it will error, enter the password after entering. The mechanism is unclear.

To execute a SQL file using the command line