MS SQL Data Migration Utility

I need a lightweight utility that can connect to two Microsoft SQL Server instances and move both transactional and historical data—roughly 1 GB up to 100 GB in total—from a source database to a target one. The goal is a smooth, one-click (or one-command) migration that preserves table structures, relationships, constraints, and identity values without forcing a full backup/restore cycle.

Core needs
• Point the tool at source and destination connection strings and let it handle the rest.
• Migrate every row in every selected table, then re-run later to catch any new or updated rows without duplicating what’s already in place.
• Produce clear logs of start/end time, tables processed, rows moved, and any errors.
• Resume intelligently after an interruption instead of starting over.
• Run from a simple console command or Windows Service; no heavy installers.

Deliverables
1. Compiled executable (C#, PowerShell, or another .NET-friendly language is fine—open to ideas).
2. Full source code with brief build instructions.
3. README covering prerequisites, configuration settings, and a quick “getting started” example.
4. A short test report proving the utility can migrate a 1-10 GB sample database in my environment.

Acceptance criteria
• All data—both historical (archive tables) and current transactional data—arrives intact.
• Two successive runs migrate only the delta.
• No blocking locks or noticeable performance hit on the live source during migration.

If you’ve built similar SQL Server sync or ETL tools, please send a quick note outlining your approach and any technologies you’d leverage (e.g., SqlBulkCopy, SSIS, EF Core, or custom T-SQL). I’m ready to get started right away and will be responsive to questions.