SQLServer --> MySql migration
I'm trying to do a migration from SQLServer to MySQL and during the stepped process I got this log with errors.
I'm not a tech guy so I'm not able to understand which could be problem.
What is the issue and how to fix it ?
Bye
Starting...
Connect to source DBMS...
- Connecting...
Connecting to Mssql@EOS TRACK GARE...
Opening ODBC connection to DSN=EOS TRACK GARE;DATABASE=;UID=sa;PWD=XXXX...
Connected to Mssql@EOS TRACK GARE, 10.50.2500.0
Connect to source DBMS done
Reverse engineer selected schemas....
Reverse engineering dbo from EOSTrack2
- Reverse engineering catalog information
- Reverse engineering User Data Types...
- Preparing...
- Gathered stats for dbo
Reverse engineering 23 tables from dbo
- Retrieving table dbo.ClientiVetaaaa...
- Retrieving table dbo.Parametri...
- Retrieving table dbo.Gare...
- Retrieving table dbo.ClientiVet...
- Retrieving table dbo.Gare-AltriDoc...
- Retrieving table dbo.Gare-Persone...
- Retrieving table dbo.Gare-Articoli...
- Retrieving table dbo.ClientiVet-Articoli...
- Retrieving table dbo.CatMerceol...
- Retrieving table dbo.Anagrafica...
- Retrieving table dbo.AnagrFiliali...
- Retrieving table dbo.Aziende...
- Retrieving table dbo.Autorizzazioni...
- Retrieving table dbo.sec_users...
- Retrieving table dbo.sec_apps...
- Retrieving table dbo.sec_groups...
- Retrieving table dbo.sec_users_groups...
- Retrieving table dbo.sec_groups_apps...
- Retrieving table dbo.Zone...
- Retrieving table dbo.Tipo_Gare...
- Retrieving table dbo.Stato_Gara...
- Retrieving table dbo.Uffici...
- Retrieving table dbo.Articoli...
- First pass of table reverse engineering for schema dbo completed!
Reverse engineering 0 views from dbo
- Reverse engineering of views for schema dbo completed!
Reverse engineering 0 routines from dbo
- Finished reverse engineering of procedures for the dbo schema.
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_grt.py", line 420, in reverseEngineer
reverseEngineerFunctions(connection, schema)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_grt.py", line 1045, in reverseEngineerFunctions
execute_query(connection, 'USE %s' % quoteIdentifier(schema.owner.name)) # catalog
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_mssql_grt.py", line 62, in execute_query
return get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.Error: ('01000', '[01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()). (65534) (SQLExecDirectW); [08S01] [Microsoft][ODBC SQL Server Driver][DBNETLIB]Errore di rete generico. Controllare la documentazione della rete. (11)')
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_selection.py", line 175, in task_reveng
self.main.plan.migrationSource.reverseEngineer()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\migration.py", line 369, in reverseEngineer
self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
SystemError: Error("('01000', '[01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()). (65534) (SQLExecDirectW); [08S01] [Microsoft][ODBC SQL Server Driver][DBNETLIB]Errore di rete generico. Controllare la documentazione della rete. (11)')"): error calling Python module function DbMssqlRE.reverseEngineer
ERROR: Reverse engineer selected schemas: Error("('01000', '[01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()). (65534) (SQLExecDirectW); [08S01] [Microsoft][ODBC SQL Server Driver][DBNETLIB]Errore di rete generico. Controllare la documentazione della rete. (11)')"): error calling Python module function DbMssqlRE.reverseEngineer
Failed