Migrating from sql server 2016 to 2017

  • I would like to move 100+ DBs which equates to around 13 TB in size. Is there an easier approach to migrating these DBs off of old version to new version and new server instead of say doing it through log shipping, DB Mirroring etc. else the better would be to do drive level replication to copy the files over but this would incur downtime on the prod box. I am a little unsure on how to work with a methodology that is faster to reduce the overall downtime etc.

  • Hi,
    if you like Powershell, try this page:
    https://dbatools.io/
    With  this set of tools you are able to move a complete database from server A to B, with logins, etc. pp.
    Kind regards,
    Andreas

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply