Change Local Usernames in compare script?

Brian Donahue

Hi Dan,

If I understand correctly, SQL Compare should create the user for you
correctly, including the domain name. Can you post the bit of the script
that creates the user and point out what seems to be missing? If I can find
anything wrong that we can fix, we'll add that to the upcoming release. If
you don't want to post it here, please email it to support@red-gate.com.

Thanks!

Regards,

Brian Donahue
Red Gate Technical Support

"dan foxley" <dfoxley@nospampacificdatavision.com> wrote in message
news:R3%23YF$hUEHA.3088@server53...
> We use local NT Users in our DB's. When I do a SQL Compare I have to
> manually change the NT User name in the script by doing a Find/Replace.
Am
> I doing this correctly, is there a simplier or automated way to do this
with
> SQL Compare?
>
> Thanks,
> Dan Foxley
>
>

Brian Donahue

We will be adding an option to 'ignore user differences' in version 4 of SQL Compare. This should solve the problem of NT users existing in both databases, but having different logins because the machine name is different. In the current version of SQL Compare, the different NT user domains are picked up as a difference and a new login is scripted, but the synchronization fails with a 'user already exists in the database' error when the synchronization is run in these circumstances.