How alienoro/test works
LIA_HistorySync is a small SQL Server history-sync prototype. Its executable connects to AdventureWorks2022 and VersionChecker, transfers Person and Product data, then runs update-checking and pending-update procedures for both domains. The Person path stages rows and computes hashes in its insert; the Product path bulk-copies rows directly. SQL procedure implementations and schema contents were not sampled, so their internal behavior and any links to the listed TransferData procedures are not inferred.
Main entry points: TestInsert.cs Procedure runner · Program.cs Program entry · Person/Schema.sql Person schema · Product/Schema.sql Product schema
Components 15
Sync runtime
- Program entry
C# files/Program.cs - Person transfer
C# files/TestInsert.cs - Product transfer
C# files/TestInsert.cs - Procedure runner
C# files/TestInsert.cs
Database objects
- Person schema
Database files/Schemas/Person/Schema.sql - Product schema
Database files/Schemas/Product/Schema.sql - Person update check
Database files/Schemas/Person/Procedures/CheckForUpdates.sql - Person pending process
Database files/Schemas/Person/Procedures/ProcessPendingUpdates.sql - Person SQL transfer
Database files/Schemas/Person/Procedures/TransferData.sql - Product update check
Database files/Schemas/Product/Procedures/CheckForUpdates.sql - Product pending process
Database files/Schemas/Product/Procedures/ProcessPendingUpdates.sql - Product SQL transfer
Database files/Schemas/Product/Procedures/TransferData.sql
SQL databases
- AdventureWorks2022
- VersionChecker
Other components
- Operator
Connections 14
- Operator → Program entry: starts
- Program entry → Person transfer: calls
- Program entry → Product transfer: calls
- Program entry → Procedure runner: calls
- Person transfer → AdventureWorks2022: reads Person
- Person transfer → VersionChecker: stages and inserts
- Product transfer → AdventureWorks2022: reads Product
- Product transfer → VersionChecker: bulk-copies
- Procedure runner → Person update check: executes
- Procedure runner → Person pending process: executes
- Procedure runner → Product update check: executes
- Procedure runner → Product pending process: executes
- Person schema → VersionChecker: defines schema
- Product schema → VersionChecker: defines schema