There isn't any problem at all. You are simply comparing data between one source and another, and then performing a sync.
You may wish to run WHERE clauses to filter the data you are searching more (more information from the link below) but other than that there are no issues at all:
Comments
You may wish to run WHERE clauses to filter the data you are searching more (more information from the link below) but other than that there are no issues at all:
http://www.red-gate.com/supportcenter/Content?c=SQL_Data_Compare%5chelp%5c9.0%5cSDC_ApplyingConditions.htm&p=SQL%20Data%20Compare
HTH!
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569