From the course: DevOps for the Database with TFS 2018

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Local deployments

Local deployments

From the course: DevOps for the Database with TFS 2018

Start my 1-month free trial

Local deployments

- [Instructor] At this point, we've worked with our database project very quickly offline. But one of the things we noticed is that we were making changes to some text files on our hard drive. It wasn't changing SQL Server. What we want to be able to do then is take our changes and get 'em into SQL Server and see the results of our work. To do that, we're going to do an F5. F5 being the default shortcut key of Visual Studio to build and run. With SSDT, that effectively means doing a deployment or publishing our project into an SQL Server instance. This allows up to deploy and validate our work and possibly do tests. I typically recommend that people use a local SQL Server Developer Edition copy for their private F5 deployments. And then later, we're going to do deployments again in a shared dev environment, but we're going to do it with Team Build. So let's take a look at how we can do F5 deployments to a local copy of SQL Server.

Contents