x Want to participate? Join the group to interact
  • Replies 8 replies
  • Subscribers 139 subscribers
  • Views 1934 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
210
topics
416
replies
Sage Intelligence Reporting
121
topics
322
replies
RobertNelson

FYI: Turn off table auditing before doing a migration

Posted By

Creating a new folder on a new server for the purpose of doing a migration?  Do yourself a favor and turn off the auditing on all of your tables before you click that validation button, or you will pay for it when it comes time to run the sequencing monitor for the conversion to the next version.

Parents

  • Hi Robert, 

    Would you be able to provide some examples of issue that might be encountered if table audits are not turned off? 

    Also, is there a way to turn off the audits after the data has been extracted and copied over to the new server? [ in SQL or ?] 

    Thank you

Reply

  • Hi Robert, 

    Would you be able to provide some examples of issue that might be encountered if table audits are not turned off? 

    Also, is there a way to turn off the audits after the data has been extracted and copied over to the new server? [ in SQL or ?] 

    Thank you

Children
  • in reply to KendallCyr

    I only figured it out because the sequencing monitor wasn't moving and I put a profiler trace on it.  This is when I found that it was creating all of those AUDITH records.  The only issue that it causes is a huge waste of time, and you can turn it back on after you have finished with your migration.

*Community Hub is the new name for Sage City