I need to back up 100s of databases and restore them to 20 different servers, and different data file locations for destination servers.

Are there any tool that allows me to copy 1 database/all databases easily?

Thanks for any suggestions.

  • Look for dbatools .. powershell based. – Kin Shah Sep 4 '18 at 17:51
  • Thanks! I never realize it exists. Looks like a very powerful tool, hope it is reliable. – James Sep 5 '18 at 16:18

I agree with Kin dbatools you can either use Start-DbaMigration or Copy-DbaDatabase depending on your needs.

Update: Now, you can migrate from one server to many. This applies to both Start-DbaMigration and all of the Copy-Dba* commands, including Copy-DbaDatabase and Copy-DbaLogin - see https://dbatools.io/migration-enhancements/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.