How to use sqlcmd to create a database

sql-server sqlcmd
Cobold picture Cobold · Jan 1, 2012 · Viewed 52.5k times · Source

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?

Answer

Andriy M picture Andriy M · Jan 1, 2012

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.

Related questions

How to export data as CSV format from SQL Server using sqlcmd?

I can quite easily dump data into a text file such as: sqlcmd -S myServer -d myDB -E -Q "select col1, col2, col3 from SomeTable" -o "MyData.txt" However, I have looked at the help files for SQLCMD but have …

Read More
How do I grant myself admin access to a local SQL Server instance?

I installed SQL Server 2008 R2 to my local machine. But, I can't create a new database because of rights (or lack of). "CREATE DATABASE PERMISSION DENIED" So, I tried to assign the admin privileges to my current login "User does …

Read More
How to export SQL Server 2005 query to CSV

I want to export some SQL Server 2005 data to CSV format (comma-separated with quotes). I can think of a lot of complicated ways to do it, but I want to do it the right way. I've looked at bcp, but …

Read More