How can we help you today? How can we help you today?

Feature Request: Selective Synchronization

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: 
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                        Field5
Right 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.
BrienKing
0

Comments

3 comments

Sort by
  • David Atkinson
    We've had other requests for this. The problem at the moment is that SQL Compare treats columns as part of the table definition rather than entities in their own right. However, your feedback has been noted and we'll hopefully work out how to solve this in a future version.

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    0
  • swinghouse
    This would be a very welcome addition to the SQL Compare feature set!

    Any plans to add it in the future? (I see that the original posts in this thread were written three years ago...)

    /Mattias
    swinghouse
    0
  • David Atkinson
    We're improving the handling of columns in the next release by allowing renamed columns to be mapped to each other. But other than the existing behavior of ignoring columns in comparison, there are no further improvements planned for the immediate future.

    David Atkinson
    Red Gate Software
    David Atkinson
    0

Add comment

Please sign in to leave a comment.