SQL Server as Target

SQL Server is a fully supported migration target. MigratorXpress creates the target schema, streams data via FastTransfer, and can apply Clustered Columnstore Index (CCI) or archive compression based on row-count thresholds.

For the complete connection reference, authentication modes (classic / ODBC / connection string), and troubleshooting, see the canonical SQL Server page.

Target-specific Permissions

-- Grant permissions for schema creation and data loading
GRANT CREATE TABLE TO migratorxpress_user;
GRANT ALTER ON SCHEMA::dbo TO migratorxpress_user;
GRANT INSERT ON SCHEMA::dbo TO migratorxpress_user;
GRANT UPDATE ON SCHEMA::dbo TO migratorxpress_user;
GRANT DELETE ON SCHEMA::dbo TO migratorxpress_user;

Target-specific CLI Options

Option	Purpose
--cci_threshold N	Create a Clustered Columnstore Index when a table has more than N rows
--aci_threshold N	Apply archive compression when a table has more than N rows
--fk_mode {disabled,untrusted,trusted}	Foreign-key enforcement strategy after copy_fk

Example Auth Entry

{
  "mssql_target": {
    "ds_type": "mssql",
    "auth_mode": "classic",
    "info": {
      "username": "$env{MSSQL_USER}",
      "password": "$env{MSSQL_PASSWORD}",
      "server": "sql-target.company.com",
      "port": 1433,
      "database": "TargetDB"
    }
  }
}

Reference it on the command line with --target_db_auth_id mssql_target.

See Also

• SQL Server -- full connection reference
• Database Connections -- auth file format and security