Options
Having problem sync a db from an other DOMAIN
guyhoch
Posts: 2
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
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
Comments
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.
Red-Gate support