How to Batch Execute SQL files in batches using osql/ocmd in sqlserver

We created dozens of tables in the test environment last week and saved them. SQL files are too lazy to open and create them one by one when they are ready to be rebuilt in the formal environment. I searched the internet and found a simple method.

We created dozens of tables in the test environment last week and saved them. SQL files are too lazy to open and create them one by one when they are ready to be rebuilt in the formal environment. I searched the internet and found a simple method.

Execute SQL files in batches using osql/ocmd

Note: osql does not support all functions of SQL Server 2008. If you need to use all functions of SQL Server 2008, you can use the ocmd command.

With the osql/ocmd command, you must write a command to execute SQL files in batches. For example, you can write the following statement in txt when executing the preceding SQL file:
The Code is 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"

Save SQL. bat to the same file as above. 1. SQL and 2. SQL. Double-click SQL. bat during execution.