How gustavohennig/simpledatabasereplicator works
Main Components
A. User Interface Layer
• Windows Forms UI components
• Main forms (Main.cs, ReplicationTaskEdit.cs, ConnectionStringSetup.cs)
• Use a rectangle with "UI" label at the top layer
B. Core Replication Engine
• Central component (Replicator folder)
• MessageHandler, TableComparator, and ReplicationTaskInfo
• Use a hexagon or circle to represent the core engine
C. Database Abstraction Layer
• Database type implementations (SQL/Databases folder)
• Supported databases: SQL Server, Firebird, SQLite, MySQL, PostgreSQL
D. Data Access Layer
• DB folder components
• DbSchemaLoader, DbTableDataLoader, DbSyncRunner
• Use rectangles with rounded corners
E. Data Objects
• Data model (DataObjects folder)
• Table, TableColumn, TableRow classes
• Use UML-style class representation
Component Relationships
UI Layer → Core Replication Engine (User actions)
Core Replication Engine → Database Abstraction Layer (Database operations)
Database Abstraction Layer → Data Access Layer (Concrete implementations)
Data Access Layer ↔ External Databases (Data flow)
Data Objects ← → All Layers (Used throughout the system)
Important Architectural Patterns to Highlight
A. Abstraction Layers
• Clear separation between UI, business logic, and data access
• Database abstraction layer that enables multi-database support
B. Plugin Architecture
• How different database types are pluggable
• BaseDbType class and its implementations
Key Technical Details
• .NET 8 Platform (framework information)
• One-way synchronization flow
• Database agnostic architecture
• Simple query-based approach