O'Reilly logo

Introducing SQL Server by Mike McQuillan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 6

image

Automating Deployment with SQLCMD

So far, we’ve created nine scripts: one to create the database, and eight more containing tables and foreign key relationships. You don’t want to ask your DBAs to load and execute each script individually. This is where the SQLCMD tool comes in—you can create a simple script that will allow users to execute all of your scripts with a simple press of F5.

You can also use SQLCMD to roll back your changes if necessary, so once you’ve created the apply SQLCMD script, we’ll look at creating some rollback scripts.

What Is SQLCMD?

You were very briefly introduced to SQLCMD way back in Chapter 1. It’s a tool, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required