Transfer DB using Powershell

  • schleep

    SSChampion

    Points: 12549

    I'm trying to copy objects and data using the PS Transfer object.

    I keep getting an error on sp_grantdbacces to a user-group which already exists in the destination. I don't want to transfer users/groups at all. Just the DB roles.

    I have the following settings:

    $xfr.CopyAllRoles = $true

    $xfr.CopyAllLogins = $false

    $xfr.CopyAllUsers = $false

    Why am I getting this error?

    Thanks!

  • schleep

    SSChampion

    Points: 12549

    Solved: had to set CopyAllObjects = $false, and enumerate each of the object categories and set them to $true.

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

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