Ask Your Question
0

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

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

paulu gravatar image

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

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

See https://streamsets.com/documentation/...

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. https://issues.streamsets.com/browse/.... Any update on this?

Many thanks

edit retag flag offensive close merge delete

Comments

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 -0500 )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 -0500 )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 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted
0

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

iamontheinet gravatar image

Hi!

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

Stats

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

Seen: 241 times

Last updated: Aug 06