Efficiently copy, migrate, and transform table data across your SQL Server databases. Automatically manages relationships (foreign keys) and supports complex transformations, all easily configured using JSON. Significantly reduce migration effort and minimize errors with built-in dry-run capability and transaction-safe execution.

This advanced, yet user-friendly tool is designed to simplify complex data migration scenarios.

• Universal Table Copying:
  Copy and migrate entire tables between SQL Server databases effortlessly.
• Automatic Relationship Migration: Dynamically detects and copies related data across tables (foreign key dependencies). 
• Flexible JSON-Based Configuration: Easily specify table filters, value overrides, and complex column expressions via structured JSON parameters. 
• Expression & Transformation Support: Apply custom SQL expressions and transformations during migration for seamless data modifications.
• Comprehensive Filtering: Include or exclude data precisely using detailed column-based and expression-based filters. 
• Dry-Run Mode (Simulation): Preview the exact migration outcomes safely, ensuring accuracy before actual execution. 
• Transaction-Safe Execution: Execute migrations within transactions, automatically rolling back in case of errors to preserve data integrity. 
• Automatic Audit Logging: Track migration actions clearly, including inserted, updated, and filtered records. 
• Identity and Cross-Code Management: Automatically handle identity columns and cross-referenced codes during data copying.

• SQL Server 2016 or newer.
• Basic knowledge of SQL and JSON syntax.

1. Setup Your JSON Configuration 
   1. Specify source table, columns to copy, forced values, filters, and custom expressions.
   2. Example provided clearly demonstrates structure and syntax.
2. Run the Stored Procedure
3. Check Migration Logs
4. Execute Actual Migration
5. Verify the Results