CODEWITHSUNDEEP
azure-sql-databasechange-tracking
Anatolii Gabuza
Anatolii Gabuza

Reputation: 6260

SQL Azure. Change tracking

After some time googling I've found that Change Data Capture functionality is not supported on SQL Azure. This is frustrating for me because I'd like to implement change tracking without significant code changes, which are needed in case of implementing it.

Is there any built-in functionality for changes tracking in SQL Azure?

In case it really cannot be used in SQL Azure - what libraries or products can provide this functionality for enterprise scale project?

Upvotes: 4

Views: 2761

Answers (2)

Afroz
Afroz

Reputation: 1092

As of v12, SQL Azure supports Change Tracking(NOT Change Data Capture). Which is better than using Triggers and adding extra columns to track changes.

Upvotes: 3

Mike Asdf
Mike Asdf

Reputation: 2319

I stumbled on this, which describes the workaround of adding a "Local Data Cache" item to a VS project. Apparently this merely adds some datetime columns to your DB tables and populates them with triggers, which seems like a shoddy alternative in my opinion. (In particular: I'd be cautious about whether that datetime is set as the transaction commit time or as the insertion time, which could cause changes to be missed in concurrency scenarios depending on how you're handling updates.)

Upvotes: 2

Related Questions