SQL2DB v0.8.1
XML-based MSSQL data migration solution with interactive interface and standalone executable support
Key Features
Interactive Interface (v0.8.1)
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.1)
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)
Progress Monitoring (v0.8.1)
Detailed migration history and progress tracking
- Quick view of recent 3 migrations
- Full history access with 'A' toggle
- Query-level detailed progress and error logs
- Color-coded status (completed/failed/running)
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