Post reply

Transfer DB using Powershell

  • January 11, 2011 at 1:07 pm

    #243468

    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!

  • January 17, 2011 at 9:23 am

    #1274293

    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