No tags yet.
Use DBATools Powershell module for Migrations
Happy Thanksgiving!
If you're not familiar with DBAtools.io I suggest you head over to the site and see what you're missing. The amount of cmdlets is just staggering. These cmdlets can be used for so much more than migrations. But i'm going to share just a tiny fraction of what you can do.
For me, this is like the "easy" button of migrations. I was looking to migrate a large database from one server to another. There are enough considerations to make when handling large amounts of data, I was glad that I was able to use DBATools to create a simple script to handle the migrations of logins and Agent jobs.
Feel free to use the below script as a template (see parameters) to create a migration script of your own.
Remember to go to DBAtools.io to get a hold of the module and import it.