Having problem sync a db from an other DOMAIN

guyhoch

I'm trying to syn schema from a SQL SERVER1 and he is from an other domain:
im useing the XML file:

<?xml version="1.0"?>
<commandline>
<database1>db1a</database1>
<server1>SQL_SERVR1</server1>
<username1>db_user</username1>
<password1>db_user_password</password1>
<database2>db2</database2>
<server2>SQL_SERVER2</server2>
<exclude>user:[DOMAIN\username]</exclude>
<exclude>user:sa</exclude>
<synchronize/>
</commandline>

And still geting the ERROR:

Error: Error Comparing SQL_SERVER1/db1 vs SQL_SERVER2/db2 :
Windows NT user or group 'DOMAIN\username' not found. Check the name again.
ERRORLEVEL-126

chris.buckingham

The error seems to be happening when you run the <synchronize/>

A fix might be to remove roles when doing the compare. When the synchronization is done now, the user will be created automatically if there is a difference in role membership.