Is support for alternative comparison keys for static data in the works?

SQL Data Compare allows the user to select alternative comparison keys besides just the primary key. Most of our tables use identities as the primary key but have separate natural unique keys as well. We need to use the natural keys as the comparison keys.

Is there anything in the works soon to allow SQL Source Control to choose comparison keys other than the primary key for tables?

JimBurnell October 08, 2018 20:25

Comments

4 comments

@JimBurnell

Do you mean choosing comparison keys for tables with static data in SQL Source Control or all tables?

Tianjiao_Li October 10, 2018 11:23

0
For tables with static data in SQL Source Control. I want to source control static data but I want to compare it in other databases using an alternate key. We use identities as primary keys but we use natural keys for comparison.

JimBurnell October 12, 2018 22:44

0
@JimBurnell

Thanks for clarifying it. It's unfortunately not possible at the moment. Can you please kindly cast your vote on this feature request post: https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/4432462-custom-comparison-key-in-sql-source-control

Tianjiao_Li October 15, 2018 10:06

0
Thanks for the link. I voted. Not too hopeful considering how long that request has been open.

JimBurnell October 16, 2018 13:38

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Is support for alternative comparison keys for static data in the works?

Comments

Add comment