Re: MySQL Migration Toolkit Connection Error

[maziyar khorrami dastjerdi]

Hi Mike,
That worked really nice. Thanks for the video. But in the next section Reverse Engineering Failed ! Do you have any Idea about it ?
Here is the Log :

Starting...

Connect to source DBMS...

- Connecting...

Connecting to Mssql@DRIVER=SQL Server;SERVER=mayz-PC...

Opening ODBC connection to DRIVER={SQL Server};SERVER=mayz-PC;DATABASE={};UID=underprivildged;PWD=XXXX;...

Connected

Connect to source DBMS done

Reverse engineer selected schemata....

Reverse engineering dbo from JRSDB

- Reverse engineering catalog information

- Reverse engineering User Data Types...

- Preparing...

- Gathered stats for dbo

Reverse engineering 63 tables from dbo

- Retrieving table dbo.AdressAktionen...

- Retrieving table dbo.AdressAktionenVerweise...

- Retrieving table dbo.Adressen...

- Retrieving table dbo.AdressenDruck...

- Retrieving table dbo.AdressGruppen...

- Retrieving table dbo.AdressGruppenVerweise...

- Retrieving table dbo.AdressVerbindungen...

- Retrieving table dbo.Aktionen...

- Retrieving table dbo.Anschriften...

- Retrieving table dbo.BankeinzugAuswertung...

- Retrieving table dbo.Bankverbindungen...

- Retrieving table dbo.Benutzer...

- Retrieving table dbo.BenutzerGruppen...

- Retrieving table dbo.Briefe...

- Retrieving table dbo.Buchungen...

- Retrieving table dbo.BuchungenGebührenVerweise...

ERROR: Migration: reverseEngineerTablePK: Reverse engineer of table dbo.BuchungenGebührenVerweise was attempted but the table has no columns attribute

ERROR: Migration: reverseEngineerTableIndices: Reverse engineer of table dbo.BuchungenGebührenVerweise was attempted but the table has no columns attribute

- Retrieving table dbo.Differenz...

- Retrieving table dbo.EinAUS...

- Retrieving table dbo.EinGebuehren...

- Retrieving table dbo.ExportVorschriften...

- Retrieving table dbo.Fachbelegung...

- Retrieving table dbo.Filter...

- Retrieving table dbo.GebuchteKurse...

- Retrieving table dbo.Gebühren...

ERROR: Migration: reverseEngineerTablePK: Reverse engineer of table dbo.Gebühren was attempted but the table has no columns attribute

ERROR: Migration: reverseEngineerTableIndices: Reverse engineer of table dbo.Gebühren was attempted but the table has no columns attribute

- Retrieving table dbo.GruppenGebühren...

ERROR: Migration: reverseEngineerTablePK: Reverse engineer of table dbo.GruppenGebühren was attempted but the table has no columns attribute

ERROR: Migration: reverseEngineerTableIndices: Reverse engineer of table dbo.GruppenGebühren was attempted but the table has no columns attribute

- Retrieving table dbo.Honorare...

- Retrieving table dbo.Instrumente...

- Retrieving table dbo.InstrumentenVerweise...

- Retrieving table dbo.Interessen...

- Retrieving table dbo.InteressenVerweise...

- Retrieving table dbo.Kategorien...

- Retrieving table dbo.Kontakte...

- Retrieving table dbo.Konten...

- Retrieving table dbo.Kurse...

- Retrieving table dbo.KursGruppen...

- Retrieving table dbo.KursLehrerVerweise...

- Retrieving table dbo.SchülerInformationen...

ERROR: Migration: reverseEngineerTablePK: Reverse engineer of table dbo.SchülerInformationen was attempted but the table has no columns attribute

ERROR: Migration: reverseEngineerTableIndices: Reverse engineer of table dbo.SchülerInformationen was attempted but the table has no columns attribute

- Retrieving table dbo.LehrerKürzel...

ERROR: Migration: reverseEngineerTablePK: Reverse engineer of table dbo.LehrerKürzel was attempted but the table has no columns attribute

ERROR: Migration: reverseEngineerTableIndices: Reverse engineer of table dbo.LehrerKürzel was attempted but the table has no columns attribute

- Retrieving table dbo.Rabatte...

- Retrieving table dbo.Rechnungen...

- Retrieving table dbo.Schulabschluss...

- Retrieving table dbo.SchulabschlussVerweise...

- Retrieving table dbo.SchülerInaktivZeiten...

ERROR: Migration: reverseEngineerTablePK: Reverse engineer of table dbo.SchülerInaktivZeiten was attempted but the table has no columns attribute

ERROR: Migration: reverseEngineerTableIndices: Reverse engineer of table dbo.SchülerInaktivZeiten was attempted but the table has no columns attribute

- Retrieving table dbo.SchülerListe...

ERROR: Migration: reverseEngineerTablePK: Reverse engineer of table dbo.SchülerListe was attempted but the table has no columns attribute

ERROR: Migration: reverseEngineerTableIndices: Reverse engineer of table dbo.SchülerListe was attempted but the table has no columns attribute

- Retrieving table dbo.Semester...

- Retrieving table dbo.SonstigeHonorare...

- Retrieving table dbo.SQL...

- Retrieving table dbo.Staatsangehörigkeit...

ERROR: Migration: reverseEngineerTablePK: Reverse engineer of table dbo.Staatsangehörigkeit was attempted but the table has no columns attribute

ERROR: Migration: reverseEngineerTableIndices: Reverse engineer of table dbo.Staatsangehörigkeit was attempted but the table has no columns attribute

- Retrieving table dbo.StaatsVerweise...

- Retrieving table dbo.StandardHonorare...

- Retrieving table dbo.t_HonorarAbrechnungen...

- Retrieving table dbo.t_HonorarAbrechnungenPos...

- Retrieving table dbo.Tarif...

- Retrieving table dbo.Tarifbeträge...

ERROR: Migration: reverseEngineerTablePK: Reverse engineer of table dbo.Tarifbeträge was attempted but the table has no columns attribute

ERROR: Migration: reverseEngineerTableIndices: Reverse engineer of table dbo.Tarifbeträge was attempted but the table has no columns attribute

- Retrieving table dbo.Turnus...

- Retrieving table dbo.UnterrichtsTypen...

- Retrieving table dbo.UnterrichtsVertraege...

- Retrieving table dbo.Verbindungen...

- Retrieving table dbo.Verweildauer...

- Retrieving table dbo.WochenStunden...

- Retrieving table dbo.ZahlungsArten...

- Retrieving table dbo.ZahlungsWeisen...

- Retrieving table dbo.sysdiagrams...

- First pass of table reverse engineering for schema dbo completed!

Reverse engineering 0 views from dbo

- Reverse engineering view dbo.sp_upgraddiagrams

- Reverse engineering view dbo.sp_helpdiagrams

- Reverse engineering view dbo.sp_helpdiagramdefinition

- Reverse engineering view dbo.sp_creatediagram

- Reverse engineering view dbo.sp_renamediagram

- Reverse engineering view dbo.sp_alterdiagram

- Reverse engineering view dbo.sp_dropdiagram

- Reverse engineering view dbo.fn_diagramobjects

- Reverse engineering of views for schema dbo completed!

Reverse engineering 8 routines from dbo

- Reverse engineering procedure dbo.sp_upgraddiagrams

- Reverse engineering procedure dbo.sp_helpdiagrams

- Reverse engineering procedure dbo.sp_helpdiagramdefinition

- Reverse engineering procedure dbo.sp_creatediagram

- Reverse engineering procedure dbo.sp_renamediagram

- Reverse engineering procedure dbo.sp_alterdiagram

- Reverse engineering procedure dbo.sp_dropdiagram

- Finished reverse engineering of procedures for the dbo schema.

- Reverse engineering function dbo.fn_diagramobjects

- Finished reverse engineering of functions for the dbo schema.

- Reverse engineering of routines for schema dbo completed!

Reverse engineering 0 triggers from dbo

- Finished reverse engineering of triggers for the dbo schema.

- Reverse engineering of triggers for schema dbo completed!

Reverse engineering foreign keys for tables in schema dbo

- Reverse engineering of foreign keys in table dbo.AdressAktionen completed

- Reverse engineering of foreign keys in table dbo.AdressAktionenVerweise completed

- Reverse engineering of foreign keys in table dbo.Adressen completed

- Reverse engineering of foreign keys in table dbo.AdressenDruck completed

- Reverse engineering of foreign keys in table dbo.AdressGruppen completed

- Reverse engineering of foreign keys in table dbo.AdressGruppenVerweise completed

- Reverse engineering of foreign keys in table dbo.AdressVerbindungen completed

- Reverse engineering of foreign keys in table dbo.Aktionen completed

C:\Program Files (x86)\MySQL\MySQL Workbench 6.0 CE\modules\db_mssql_grt.py:71: UnicodeWarning: Unicode equal comparison failed to convert both arguments to Unicode - interpreting them as being unequal

if obj.name == name:

- Reverse engineering of foreign keys in table dbo.Anschriften completed

- Reverse engineering of foreign keys in table dbo.BankeinzugAuswertung completed

- Reverse engineering of foreign keys in table dbo.Bankverbindungen completed

- Reverse engineering of foreign keys in table dbo.Benutzer completed

- Reverse engineering of foreign keys in table dbo.BenutzerGruppen completed

- Reverse engineering of foreign keys in table dbo.Briefe completed

- Reverse engineering of foreign keys in table dbo.Buchungen completed

ERROR: Migration: reverseEngineerTableFKs: Reverse engineer of table dbo.BuchungenGebührenVerweise was attempted but the table has no columns attribute

- Reverse engineering of foreign keys in table dbo.BuchungenGebührenVerweise completed

- Reverse engineering of foreign keys in table dbo.Differenz completed

- Reverse engineering of foreign keys in table dbo.EinAUS completed

- Reverse engineering of foreign keys in table dbo.EinGebuehren completed

- Reverse engineering of foreign keys in table dbo.ExportVorschriften completed

- Reverse engineering of foreign keys in table dbo.Fachbelegung completed

- Reverse engineering of foreign keys in table dbo.Filter completed

ERROR: Migration: reverseEngineerTableFKs: While reverse engineering table dbo.GebuchteKurse: The foreign key dbo references the table FK_GebuchteKurse_SchülerInformationen.SchülerInformationen, which was not found in the source schema

- Reverse engineering of foreign keys in table dbo.GebuchteKurse completed

ERROR: Migration: reverseEngineerTableFKs: Reverse engineer of table dbo.Gebühren was attempted but the table has no columns attribute

- Reverse engineering of foreign keys in table dbo.Gebühren completed

ERROR: Migration: reverseEngineerTableFKs: Reverse engineer of table dbo.GruppenGebühren was attempted but the table has no columns attribute

- Reverse engineering of foreign keys in table dbo.GruppenGebühren completed

- Reverse engineering of foreign keys in table dbo.Honorare completed

- Reverse engineering of foreign keys in table dbo.Instrumente completed

- Reverse engineering of foreign keys in table dbo.InstrumentenVerweise completed

- Reverse engineering of foreign keys in table dbo.Interessen completed

- Reverse engineering of foreign keys in table dbo.InteressenVerweise completed

- Reverse engineering of foreign keys in table dbo.Kategorien completed

- Reverse engineering of foreign keys in table dbo.Kontakte completed

- Reverse engineering of foreign keys in table dbo.Konten completed

- Reverse engineering of foreign keys in table dbo.Kurse completed

- Reverse engineering of foreign keys in table dbo.KursGruppen completed

- Reverse engineering of foreign keys in table dbo.KursLehrerVerweise completed

ERROR: Migration: reverseEngineerTableFKs: Reverse engineer of table dbo.SchülerInformationen was attempted but the table has no columns attribute

- Reverse engineering of foreign keys in table dbo.SchülerInformationen completed

ERROR: Migration: reverseEngineerTableFKs: Reverse engineer of table dbo.LehrerKürzel was attempted but the table has no columns attribute

- Reverse engineering of foreign keys in table dbo.LehrerKürzel completed

- Reverse engineering of foreign keys in table dbo.Rabatte completed

- Reverse engineering of foreign keys in table dbo.Rechnungen completed

- Reverse engineering of foreign keys in table dbo.Schulabschluss completed

- Reverse engineering of foreign keys in table dbo.SchulabschlussVerweise completed

ERROR: Migration: reverseEngineerTableFKs: Reverse engineer of table dbo.SchülerInaktivZeiten was attempted but the table has no columns attribute

- Reverse engineering of foreign keys in table dbo.SchülerInaktivZeiten completed

ERROR: Migration: reverseEngineerTableFKs: Reverse engineer of table dbo.SchülerListe was attempted but the table has no columns attribute

- Reverse engineering of foreign keys in table dbo.SchülerListe completed

- Reverse engineering of foreign keys in table dbo.Semester completed

- Reverse engineering of foreign keys in table dbo.SonstigeHonorare completed

- Reverse engineering of foreign keys in table dbo.SQL completed

ERROR: Migration: reverseEngineerTableFKs: Reverse engineer of table dbo.Staatsangehörigkeit was attempted but the table has no columns attribute

- Reverse engineering of foreign keys in table dbo.Staatsangehörigkeit completed

- Reverse engineering of foreign keys in table dbo.StaatsVerweise completed

- Reverse engineering of foreign keys in table dbo.StandardHonorare completed

- Reverse engineering of foreign keys in table dbo.t_HonorarAbrechnungen completed

- Reverse engineering of foreign keys in table dbo.t_HonorarAbrechnungenPos completed

- Reverse engineering of foreign keys in table dbo.Tarif completed

ERROR: Migration: reverseEngineerTableFKs: Reverse engineer of table dbo.Tarifbeträge was attempted but the table has no columns attribute

- Reverse engineering of foreign keys in table dbo.Tarifbeträge completed

- Reverse engineering of foreign keys in table dbo.Turnus completed

- Reverse engineering of foreign keys in table dbo.UnterrichtsTypen completed

- Reverse engineering of foreign keys in table dbo.UnterrichtsVertraege completed

- Reverse engineering of foreign keys in table dbo.Verbindungen completed

- Reverse engineering of foreign keys in table dbo.Verweildauer completed

- Reverse engineering of foreign keys in table dbo.WochenStunden completed

- Reverse engineering of foreign keys in table dbo.ZahlungsArten completed

- Reverse engineering of foreign keys in table dbo.ZahlungsWeisen completed

- Reverse engineering of foreign keys in table dbo.sysdiagrams completed

- Second pass of table reverse engineering for schema dbo completed!

- Reverse engineering completed!

Reverse engineer selected schemata finished

Post-processing of reverse engineered schemata...

Merging reverse engineered schema objects into a single schema...

Post-processing of reverse engineered schemata done

Tasks finished with warnings and/or errors, view the logs for details

Finished performing tasks.