Search code examples
sql-serversqlcmd

How to use sqlcmd to create a database

I have a .sql script and I want to build a database from it. How to do it in sqlcmd? I know it's like:

CREATE DATABASE dbName
GO

But how to specify the .sql script and location to build the database?

Solution

  • Use @Jeremiah Peschka's answer to supply the sqlcmd utility with the script to execute.

    As for the location for the newly created database, it can be specified as part of the CREATE DATABASE command:

    CREATE DATABASE dbName
ON (
  NAME = dbName_dat,
  FILENAME = 'D:\path\to\dbName.mdf'
)
LOG ON (
  NAME = dbName_log,
  FILENAME = 'D:\path\to\dbName.ldf'
)

    As you can see from the linked article, you can specify other properties as well, like initial size, maximum size etc.