This converter handles common data type and syntax transformations.
`NVARCHAR`, `NCHAR` are mapped to `VARCHAR`, `CHAR` - ensure your MySQL database uses `utf8mb4` charset for full Unicode.
`IDENTITY` is converted to `AUTO_INCREMENT`.
`GETDATE()` is converted to `NOW()`. `NEWID()` is converted to `UUID()` with a comment, but consider application-side UUID generation for better control.
**Output Format:** `CREATE TABLE` statements are separated from `ALTER TABLE` (Foreign Key) statements for easier import.
**CSV Import Format:** Expects `TableName,ColumnName,Type,Length,IsPrimary,IsNullable,IsUnique,DefaultValue,ForeignKey` (or similar headers) with comma, semicolon, or tab delimiters.
Advanced MSSQL features (e.g., specific functions, triggers, stored procedures, complex constraints) are **not** fully converted and may require manual adjustment.
Always review the converted SQL before executing it in your MySQL database.
**For Large Imports (e.g., "query exceeds maximum length" errors):**
**Increase MySQL `max_allowed_packet`:** This is a crucial server setting. Edit `my.cnf` (Linux) or `my.ini` (Windows) and set `max_allowed_packet = 128M` (or higher, e.g., 256M). Restart MySQL.
**Use `mysql` command-line client:** For very large files, clients like MySQL Workbench might struggle. It's often more reliable to import via the command line: `mysql -u your_user -p your_database < your_file.sql`