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

Options: ReplyQuote


Subject
Written By
Posted
mssql to MySql Migration failed
October 12, 2017 09:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.