How to Add a Changelog in a Separate Database

 

Instructions

The changelog can really increase the size of your database. If you'd like, you can set up the changelog as a separate database by following these steps.

1. In the database, right-click on Databases and select New Database.

2. Enter your Database Name (for example, I chose FlightVectorChangeLog).

3. From the Server Settings.ini file, copy the information from Driver= into a notepad and change the Database name to the one you used in Step 2 (just a reminder, don’t put the changelog database name in the settings.ini file; this is just to get the ODBC string for the CAD setting).

Driver={SQL Server Native Client 11.0};Server=DESKTOP-VLLLORT\sqlexpress;Database=FlightVectorChangelog;Trusted_Connection=yes;MARS_Connection=yes

4. Copy and paste the string above into the CAD in Settings -> Change Log ODBC String.

We also have a setting for Change Log Maximum Days of Age.

• Change log rows older than this many days will be deleted.
• This is designed to delete data gradually over time to prevent slowdowns.