AccdbMerge can do a lot of database diff and merge tasks without user interaction. It has its own scripting language, designed to automate the most common tasks.
For example, you need to create a continuous integration (CI) nightly build that checks for data changes between your Dev and Staging database instances. Such a report could be easily generated using AccdbMerge GUI: we just need to open and run the Batch data diff (see Data changes summary use case). Then using the toolbar we need to apply a 'New and Changed' filter and then do Export. But all these actions should be done by someone, that's not applicable for our task that should be done without user interaction.
Let's automate this task. Open Script Editor application:
As recommended in the sample script comments, 1 update database, script log and report file paths. Script sample already contains required command to generate data summary report, if you need some other actions - please check the documentation. Then 2 choose which command line tool to use - 32 or 64 bit (should correspond to your MS Access), click 3 to check the script and make sure the Result panel has no errors. If so, click 4 to run the script and check its execution result:
5 'EXIT CODE: 0' and missing errors means successful execution. Note that now 6 log file and 7 report file paths are changed into hyperlinks, and you can click those links to open these files.
For many typical diff & merge tasks such a script can be generated automatically. For example, you can the Batch data diff tool (see Data changes summary use case), 8 setup parameters and generate schema changes summary report script using 9'Generate automation script stub' toolbar button:
This button generates script for the current tab, it already contains your database names and all you have to do is 10setup log and report file paths:
Once your script is ready, select and copy text of your script, paste it into some text editor and save as file with *.ksdms extension. Now, assuming that you have AccdbMerge installed on CI server, you can create a task in your CI pipeline that would run the following command:
"c:\Program Files (x86)\AccdbMerge\AccdbMergeCmd64.exe" "c:\temp\schemaDiff.ksdms"
where AccdbMergeCmd64.exe argument should be a real path to your *.ksdms file.
