Feature Request: Selective Synchronization
BrienKing
Posts: 30 Bronze 3
Right now, SQL Compare will syncronize the entire object, however, sometimes I only want to syncronize PART of the object.
The reason for this, is I have two versions of a database and I want to add a new feature to BOTH but the schema and data is not 100% identical.
For Example:
Now I want to add Field5 to both so they would look like:
Syncing A --> B would result in Field3 being copied to Table B, which I don't want.
Syncing B --> A would result in Field3 being removed, which I don't want.
It would be nice if you allowed me to turn off the syncing of Field3.
The reason for this, is I have two versions of a database and I want to add a new feature to BOTH but the schema and data is not 100% identical.
For Example:
Table A Table B ====== ========== ID ID Field1 Field1 Field2 Field2 Field3 Field4 Field4
Now I want to add Field5 to both so they would look like:
Table A Table B ====== ========== ID ID Field1 Field1 Field2 Field2 Field3 Field4 Field4 Field5 Field5Right now the way it works, if I was to Sync in either direction, I wouldn't get the result I wanted.
Syncing A --> B would result in Field3 being copied to Table B, which I don't want.
Syncing B --> A would result in Field3 being removed, which I don't want.
It would be nice if you allowed me to turn off the syncing of Field3.
Comments
David Atkinson
Product Manager
Red Gate Software
Product Manager
Redgate Software
Any plans to add it in the future? (I see that the original posts in this thread were written three years ago...)
/Mattias
David Atkinson
Red Gate Software
Product Manager
Redgate Software