From the course: Automating SQL Server with dbatools

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Simple database migrations

Simple database migrations - SQL Server Tutorial

From the course: Automating SQL Server with dbatools

Start my 1-month free trial Buy for my team

Simple database migrations

“

- [Narrator] Previously we looked at Big Bang migrations basically taking everything we possibly could from one instance over to another. In the real world that's not always what we want and the beauty of how that start DBA Migration Command is written is that it's basically a rapid script around a whole bunch of copy commands. Let's take a look at just migrating our databases with copy DBA database. The databases are usually the most complex part of our migrations and it makes sense. All of our important data is in there so we need to make sure we can minimize the downtime window but also have confidence that all the data is going to get from one instance to another. Let's first remind ourselves of which databases are aware in our environment. Looking at the results from GET DBA database you can see we have three databases on DBA tools one. And there are currently none on DBA tools two. We can migrate all three of these…

Contents