Transfer DB using Powershell

  • 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?


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

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

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