Create batch file to copy contents of one SQL Server database to another

Question

I need to create a batch file (script) to copy entire content of one SQL Server database to another. Source database is local for the machine. What command line tools and commands therein I could use? Destination database can be dropped entirely.

Also, I need to run a pair of SQL queries afterwards, also from batch file.

Thanks in advance!

kleinohad · Accepted Answer · 2012-11-22 17:28:44Z

1

you can read about Run Transact-SQL Script Files Using sqlcmd from here: http://msdn.microsoft.com/en-us/library/ms170572.aspx

answered Nov 22, 2012 at 17:28

kleinohad

5,9202 gold badges29 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

NEO · Accepted Answer · 2012-11-22 17:08:18Z

1

first u need to create your sql queries then u can use this command to run it via batch file

sqlcmd -S %computername%\%SName% -U %UName% -P %Pwd%  -i SQL_DB.sql >> _Deploy.txt 2>&1

this command gets computer name and sqlserver instance name and user name and password and run SQL_DB.sql file near batch file that contains our queries and save the result in a text file named _deploy.txt

answered Nov 22, 2012 at 17:08

NEO

2132 silver badges9 bronze badges

Collectives™ on Stack Overflow

Create batch file to copy contents of one SQL Server database to another

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related