GEM Automation 3.4.1.0 – SQL Change Data Capture PowerShell Collector Update

I’ve released a new version GEM Automation that contains several updates to the PowerShell CDC collector that I’ve blogged about here.

Here’s what’s included in version 3.4.1.0:

libSqlServerCDC.psm1

  • Optimizations
    • Refined CDC polling query, now only selecting tracked columns
    • New function Get-DataCollectorCDCQuery to generate CDC query based on tracked columns and required joins to enrich the data
    • Added the capability to choose whether a CDC change is collected when any columns (collectionType=All) on the row is touched or only when one of the tracked column is touched (collectionType=TrackedColumnsOnly) using the CDC update mask
    • Optimized Set-DataCollectorCDCTrackedTableLSN to reuse opened connection
  • Manageability enhancements
    • Added the ability to enable/disable table in the DataCollector config database
  • Usability enhancements
    • Added the capability to get multiple reference columns while joining with another table
  • Other
    • Updated Set-DataCollectorCDCConfiguration with latest schema information
    • Renamed column TargetDescriptiveColumnName to TargetReferenceColumnName

Version 3.4.1.0 DownloadVersion 3.4.1.0 Download

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s