How to run .bat or script file in SQL server for creating database?

Create SQL Database by Running Script File (.bat File)

STEP 1

Open Command Prompt. Go to Start -> Run -> cmd now Enter.

STEP 2

Run command cd\ on command prompt.

STEP 3

Copy DATABASENAME.bat file folder path.

STEP 4

Type following command on command prompt and hit Enter.
cd "Folder path location"

STEP 5

Now type DATABASE.bat file name and Enter.

Type following command on command prompt:

Batch File Path >> Server Name >> Database Name

Hit Enter.

A new database into SQL Server will be created.

Most Frequently Asked