• Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle

SEARCH BY TAGS: 

Please reload

RECENT POSTS: 

FOLLOW ME:

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle

Use DBATools Powershell module for Migrations

November 21, 2017

 

 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.

 

 

Share on Facebook
Share on Twitter
Please reload