MySQL Forums
Forum List  »  Microsoft SQL Server

SQLServer --> MySql migration
Posted by: Giovanni Chiozza
Date: October 17, 2016 02:07AM

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

Options: ReplyQuote


Subject
Written By
Posted
SQLServer --> MySql migration
October 17, 2016 02:07AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.