web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dynamics GP : Can we t...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Dynamics GP : Can we turn on CDC on GP SQL Server tables ?

(1) ShareShare
ReportReport
Posted on by Preetham theGP 17
Hello GP world,
 
We are currently using GP 18.5 . We have a business requirement which can be executed efficiently if we can turn on CDC on 5 of heavily used GP subledger tables (AP and AR). We discussed this with our DBA but we are not sure what would be impact if we turn on CDC on GP tables. Anyone turned on CDC ? If yes can you please share your comments/concerns or points to noted. 
 
Thanks in advance for your response.
I have the same question (0)
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 1,028 Super User 2026 Season 1 on at
    I haven't turned on CDC for a GP database but do have many instances where triggers on specific tables (to track changes) are in place.

    Other than the small performance hit and the additional disk space, the process works well but testing (and a recovery plan!) would be important.  In addition to testing for basic processing, I would include some heaving testing of posting and other actions that move records from tables (for example moving AP transactions from open to history during check posting) to confirm there aren't issues with locks.
  • Preetham theGP Profile Picture
    Preetham theGP 17 on at
    Thank you Lisa for your response. We already have lots of triggers in place but now we are trying to use it even more so planning to turn on CDC but thanks again for your comments.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 509 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 375

#3
Adis Profile Picture

Adis 268 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans