Method of batch execution of SQL files through Osql/ocmd batches in SQL Server _mssql

batch execution of SQL files with Osql/ocmd batch

Note: In the above illustration we can see that osql does not support all the features of SQL Server 2008, and if you need to use all of the features of SQL Server 2008, you can use the Ocmd command.

With the Osql/ocmd command to bulk Execute SQL files, of course, you need to write a batch command, such as we execute the above SQL file can be written in txt the following statement:

Copy Code code as follows:

Osql-s "127.0.0.1"-u "sa"-P "sa"-D "Northwind"-i "%cd%/1.sql"
Osql-s "127.0.0.1"-u "sa"-P "sa"-D "Northwind"-i "%cd%/2.sql"

Then save into Sql.bat with the top 1.sql and 2.sql placed under the same file, double-click Sql.bat on execution.