syncing-diva-sql

Run xwin7 -action synchroauto with the same project and profile as the buildall, from the working directory C:\divalto\sys. The compilation must have finished with 0 errors, otherwise the compiled objects are inconsistent and the synchronization is invalid.

Run parse_synchro.py --path on the report file. It extracts the [TOTAL_ERRORS] marker and error lines with context, returning JSON with success, total_errors, and errors fields. Exit code 0 means success, 1 means errors found, 2 means the report is unreadable.

No, xwin7 synchroauto has no native dry-run option such as synchroscript or -noexec. A preview is possible programmatically via the ModeAudit mechanism, and the parse_synchro.py --changes mode provides an after-the-fact schema delta per table.

Error code 3 means the working directory was not C:\divalto\sys when xwin7 was called. Use Set-Location to switch to C:\divalto\sys before running synchroauto, and restore the original directory afterward.

Buildall reports use the marker Erreur(s)=N, while synchroauto reports use [TOTAL_ERRORS]N. The two formats require different parsers, so do not reuse the buildall parsing logic on a synchronization report.

It extracts the real schema delta grouped by table: added and dropped columns, created and dropped indexes, created and dropped tables, plus procedures and functions. It filters noise such as *_oldcolumns backup tables, INSERT statements, sp_addextendedproperty, and regenerated ERASE_* procedures.