I need to alter a database using a batch file, for a simple example, drop a table. I´m using local SQL Express (SQL Server 2008 R2) with user sa
and its password.
How would the bat file be?
How can I specify in the script the password and that I use in SQL Express?
This question is related to
sql
sql-server
batch-file
command-line
scripting
Feedback Guys, first create database example live; before execute sql file below.
sqlcmd -U SA -P yourPassword -S YourHost -d live -i live.sql
You can do like this
sqlcmd -S <server Name> -U sa -P sapassword -i inputquery_file_name -o outputfile_name
From your command prompt run sqlcmd /?
to get all the options you can use with sqlcmd
utility
If you use Integrated Security, you might want to know that you simply need to use -E
like this:
sqlcmd -S Serverinstance -E -i import_file.sql
If you want to run the script file then use below in cmd
sqlcmd -U user -P pass -S servername -d databasename -i "G:\Hiren\Lab_Prodution.sql"
Source: Stackoverflow.com