Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

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

Posted on by 9
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.
  • Preetham theGP Profile Picture
    Preetham theGP 9 on at
    Dynamics GP : Can we turn on CDC on GP SQL Server tables ?
    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.
  • Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,992 on at
    Dynamics GP : Can we turn on CDC on GP SQL Server tables ?
    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans