What are the challenges you face when working across database platforms? Take the survey

Change Local Usernames in compare script?

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
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 support@red-gate.com.



Brian Donahue
Red Gate Technical Support

"dan foxley" <dfoxley@nospampacificdatavision.com> wrote in message
> 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.
> I doing this correctly, is there a simplier or automated way to do this
> SQL Compare?
> Thanks,
> Dan Foxley


  • Options
    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.