Change Local Usernames in compare script?

Brian DonahueBrian Donahue Posts: 6,590 New member
edited November 25, 2005 11:39AM in SQL Compare Previous Versions
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 [email protected].

Thanks!

Regards,

Brian Donahue
Red Gate Technical Support

"dan foxley" <[email protected]> wrote in message
news:R3%[email protected]
> 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
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
This discussion has been closed.