mssql to MySql Migration failed
Posted by:
Chan Patel
Date: October 12, 2017 09:50AM
Hey Everyone,
I have been trying the migration from mssql to mysql from MySql Workbench as i have seen it's the most popular tool to migrate from mssql, but i am encountering a error, i also saw many other users are also facing the same issue, at one of the thread i have seen the issue can be resolved by using freeTDS ODBC Driver for the migration, I have also attached the message log which i have, i think it's something related to the ODBC driver or something is not compatible with mssql to mysql.
Starting...
Migrate Selected Objects....
- Migrating...
- Migrating schema EVEREST_ROBI...
- Migrating schema contents for schema EVEREST_ROBI
- Table EVEREST_ROBI.FORM_SETTINGS_DETAILS migrated
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.py", line 442, in migrateCatalog
return instance.migrateCatalog(state, sourceCatalog)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.py", line 186, in migrateCatalog
targetSchema = self.migrateSchema(state, sourceSchema, target_catalog)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.py", line 222, in migrateSchema
self.migrateSchemaContents(state, targetSchema, sourceSchema)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.py", line 238, in migrateSchemaContents
target_table = self.migrateTableToMySQL(state, source_table, targetSchema)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.py", line 165, in migrateTableToMySQL
targetTable = super(MSSQLMigration, self).migrateTableToMySQL(state, sourceTable, targetSchema)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.py", line 275, in migrateTableToMySQL
targetColumn = self.migrateTableColumnToMySQL(state, sourceColumn, targetTable)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.py", line 407, in migrateTableColumnToMySQL
target_column = GenericMigration.migrateTableColumnToMySQL(self, state, source_column, targetTable)
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_generic_migration_grt.py", line 378, in migrateTableColumnToMySQL
if not self.migrateDatatypeForColumn(state, source_column, target_column):
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_migration_grt.py", line 277, in migrateDatatypeForColumn
target_column.precision = source_column.simpleType.numericPrecision
AttributeError: 'NoneType' object has no attribute 'numericPrecision'
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration_object_migration.py", line 113, in task_migrate
self.main.plan.migrate()
File "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\migration.py", line 513, in migrate
self.migrationTarget.catalog = self.migrationSource.migration.migrateCatalog(self.state, self.migrationSource.catalog)
SystemError: AttributeError("'NoneType' object has no attribute 'numericPrecision'"): error calling Python module function DbMssqlMigration.migrateCatalog
ERROR: Migrate Selected Objects: AttributeError("'NoneType' object has no attribute 'numericPrecision'"): error calling Python module function DbMssqlMigration.migrateCatalog
Failed