SQL2DB v0.9.1
XML-based MSSQL data migration solution with interactive interface and standalone executable support
Key Features
Interactive Interface (v0.8.4)
User-friendly menu system for easy data migration operations
- Select query files by number - no full path needed
- Multilingual support (English/Korean)
- Menu-driven task selection (validate, test, execute, monitor)
- Real-time progress display with color coding
Standalone Executable (v0.8.4)
Complete package ready to run without Node.js installation
- No Node.js required - extract and run immediately
- Single executable file (sql2db.exe) included
- ~50MB complete package (all dependencies included)
- English/Korean launcher scripts (run.bat / 실행하기.bat)
JSON Mapping Fix (v0.8.7 NEW)
Fixed JSON-based column override mapping to work correctly based on actual data values
- Maps values based on actual source data, not just first JSON value
- Preserves original value when no mapping is found (instead of using first value)
- Auto-trims whitespace in values for accurate matching
- Proper null/undefined/empty string handling
Enhanced Column Override Logging (v0.8.6)
Accurate logging showing only columns that are actually overridden
- Display only columns that exist in actual data and were overridden
- Two-stage filtering: applyGlobalColumns attribute → data existence check
- Case-insensitive column matching (Created_By, created_by, CREATED_BY all recognized)
- Clear and precise log output for better debugging and tracking
Global Timezone System (v0.8.5)
Support for 22 timezones worldwide with flexible date/time variables
- 22 global timezones: UTC, GMT, KST, JST, CST, SGT, PHT, AEST, ICT, IST, GST, CET, EET, EST, AST, CST_US, MST, PST, AKST, HST, BRT, ART
- Timezone-specific format: ${DATE.TIMEZONE:format}
- Local time support: ${DATE:format}
- Use in table names, column overrides, WHERE conditions, pre/post processing
Unified Language Configuration (v0.8.4)
More convenient usage with environment variable-based language settings
- Control language uniformly via LANGUAGE environment variable
- Automatic environment variable setup in batch files
- Use environment variables instead of command-line parameters
- Default to English ('en') for consistency
Enhanced Security (v0.8.3)
Enhanced security features to protect sensitive information
- Automatic password masking in logs
- Sensitive data protection (password, pwd, passwd fields)
- 5-level log system
- Secure data migration process
Case-Insensitive Column Matching (v0.8.3)
No need to worry about column name case
- identityColumns automatic case correction
- globalColumnOverrides case-insensitive
- applyGlobalColumns case-insensitive
- Automatic column name matching with warnings
Large Dataset Support (v0.8.3)
Automatically handles SQL Server parameter limits
- SQL Server 2100 parameter limit auto-resolved
- deleteBeforeInsert large data processing
- Automatic batch splitting (chunking)
- Large-scale data migration optimization
Enhanced Debugging (v0.8.3)
Detailed diagnostics for delete operations
- Explicit target DB display
- Automatic diagnosis of delete failures
- Sample data comparison feature
- Detailed debug logs
Intelligent SQL Processing
Advanced SQL parsing with automatic SELECT * expansion and pre/post-processing column override
- SELECT * auto-expansion to actual column names
- Table alias and JOIN clause support
- Pre/post-processing column override automation
- INSERT/UPDATE statement auto-enhancement
Enhanced Dynamic Variables
Extract values from database in real-time with advanced processing and key-value pairs support
- column_identified and key_value_pairs types
- Pre-execution variable processing and caching
- Debug mode for variable substitution verification
- Error handling and empty result replacement
Resume Migration
Resume interrupted migrations from the last completed point with progress tracking
- Automatic progress tracking and checkpointing
- Network error recovery
- Migration ID-based resume functionality
- Progress verification before resume
Flexible Configuration
XML based configuration with environment variable support and validation
- XML configuration formats
- Environment variable substitution
- Built-in configuration validation
- Global and query-specific settings
Transaction Support
Ensure data consistency with transaction support and batch processing
- Configurable batch sizes
- Transaction rollback on errors
- Delete before insert options
- Data integrity protection
Technical Specifications
Platform & Deployment
- Standalone Executable: No Node.js required
- Node.js Source: Node.js 14.0+ (for developers)
- Database: Microsoft SQL Server 2012+
- OS Support: Windows 7+ (64-bit)
- Package Size: ~50MB (all dependencies included)
User Interface
- Interactive Menu: Number-based file selection
- Multilingual: English/Korean support
- Progress Display: Real-time color-coded display
- History View: Recent 3/full history toggle
- Detailed Info: Query-level progress/error tracking
Configuration & Variables
- Format: XML
- Validation: Built-in configuration validation
- Environment: Environment variable support
- Dynamic Variables: Real-time data extraction
SQL Processing
- SELECT * Expansion: Automatic column name resolution
- Pre/Post Processing: Column override automation
- Transaction Support: Configurable batch processing
- Error Handling: Comprehensive error recovery
Security
- Authentication: SQL Server authentication
- Encryption: TLS/SSL support
- Input Validation: SQL injection prevention
- Access Control: Database permission management
Use Cases
Enterprise Data Migration
Large-scale data migration between different SQL Server instances with real-time monitoring and error handling.
- Legacy system modernization
- Database consolidation
- Cloud migration projects
Data Warehouse ETL
Extract, transform, and load processes for data warehouse construction with advanced data transformation capabilities.
- Data transformation
- Aggregation processing
- Incremental loading
System Integration
Integration between different systems with data synchronization and transformation requirements.
- API data synchronization
- Third-party system integration
- Data format conversion
Development & Testing
Development environment setup and testing data management with flexible configuration options.
- Test data generation
- Environment synchronization
- Development workflow automation