Ask Your Question

When will SQL Server Change Tracking origin allow non-numeric primary keys?

asked 2020-07-30 03:36:30 -0600

paulu gravatar image

updated 2020-07-30 05:51:14 -0600

I see from the SDC documentation that the SQL Server Change Tracking Origin only allows simple numeric keys.


The origin can process data from tables with simple numeric primary keys. The origin cannot process data from tables with compound or non-numeric primary keys.

This is a very severe limitation. I am looking to stream changes from a SQL Server database that uses the uniqueidentifier (guid) data type for it's primary keys. Is there anything on your roadmap to enhance this origin any time soon? I can see tickets on JIRA that suggest there might be. E.g. Any update on this?

Many thanks

edit retag flag offensive close merge delete


Any update on this question? I have tested and the SQL Server Change Tracking origin seems to work even with non-numeric primary keys. Is the documentation correct?

paulu gravatar imagepaulu ( 2020-08-05 08:14:06 -0600 )edit

You're saying the documentation says otherwise, but you've tried it and it actually works?

iamontheinet gravatar imageiamontheinet ( 2020-08-05 21:20:04 -0600 )edit

Yes, the documentation explicitly says that the origin cannot process data from tables with non-numeric primary keys. As a test, I used it on a table with a primary key of uniqueidentifier data type. There were no failures and it processed inserts, updates and deletes fine.

paulu gravatar imagepaulu ( 2020-08-06 03:24:26 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2020-08-06 22:26:27 -0600

iamontheinet gravatar image


According the docs the only operations that can be performed against a uniqueidentifier value are comparisons (=, <>, <, >, <=, >=), it is considered "numeric" by SQL Server Change Tracking origin and that's why it seems to work :)

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-30 03:36:30 -0600

Seen: 250 times

Last updated: Aug 06 '20