Log: Starting... Prepare information for data copy... Prepare information for data copy done Determine number of rows to copy.... Counting number of rows in tables... /usr/lib/mysql-workbench/wbcopytables-bin --count-only --passwords-from-stdin --odbc-source="DRIVER={FreeTDS};SERVER=127.0.0.1;PORT=1433;DATABASE=ApolloData;UID=sa;;TDS_VERSION=7.1" --table [ApolloData] [dbo].[tblAWJournoLink] --table [ApolloData] [dbo].[TblAnalystCountries] --table [ApolloData] [dbo].[dtproperties] --table [ApolloData] [dbo].[tblAWArticles] --table [ApolloData] [dbo].[tblAWThemes] --table [ApolloData] [dbo].[u] --table [ApolloData] [dbo].[TblMonths] --table [ApolloData] [dbo].[tblAWCompanies] --table [ApolloData] [dbo].[tblAWJournalists] --table [ApolloData] [dbo].[tblCompanies] --table [ApolloData] [dbo].[TblArticleCountries] --table [ApolloData] [dbo].[tblAWAnalysts] --table [ApolloData] [dbo].[tblAWArticleContent] --table [ApolloData] [dbo].[tblAWSources] --table [ApolloData] [dbo].[tblCategoryGroup] 16:12:57 [INF][ copytable]: Opening ODBC connection to [unknown] 'DRIVER={FreeTDS};SERVER=127.0.0.1;PORT=1433;DATABASE=ApolloData;UID=sa;;TDS_VERSION=7.1;PWD=XXX' 16:12:57 [INF][ copytable]: ODBC connection to 'DRIVER={FreeTDS};SERVER=127.0.0.1;PORT=1433;DATABASE=ApolloData;UID=sa;;TDS_VERSION=7.1;PWD=' opened 1300098 total rows in 15 tables need to be copied: - [ApolloData].[dbo].[tblAWJournoLink]: 43123 - [ApolloData].[dbo].[TblAnalystCountries]: 50 - [ApolloData].[dbo].[dtproperties]: 0 - [ApolloData].[dbo].[tblAWArticles]: 96996 - [ApolloData].[dbo].[tblAWThemes]: 950 - [ApolloData].[dbo].[u]: 1 - [ApolloData].[dbo].[TblMonths]: 13 - [ApolloData].[dbo].[tblAWCompanies]: 4715 - [ApolloData].[dbo].[tblAWJournalists]: 9302 - [ApolloData].[dbo].[tblCompanies]: 12158 - [ApolloData].[dbo].[TblArticleCountries]: 18 - [ApolloData].[dbo].[tblAWAnalysts]: 3193 - [ApolloData].[dbo].[tblAWArticleContent]: 1126936 - [ApolloData].[dbo].[tblAWSources]: 1397 - [ApolloData].[dbo].[tblCategoryGroup]: 1246 Determine number of rows to copy finished Copy data to target RDBMS.... Migrating data... /usr/lib/mysql-workbench/wbcopytables-bin --odbc-source="DRIVER={FreeTDS};SERVER=127.0.0.1;PORT=1433;DATABASE=ApolloData;UID=sa;;TDS_VERSION=7.1" --target="finley@localhost:3306" --progress --passwords-from-stdin --thread-count=2 --source-rdbms-type=Mssql --table [ApolloData] [dbo].[tblAWJournoLink] `ApolloData` `tblAWJournoLink` [IntPRCId],[IntJournalistId] `IntPRCId`,`IntJournalistId` [IntPRCId], [IntJournalistId] --table [ApolloData] [dbo].[TblAnalystCountries] `ApolloData` `TblAnalystCountries` [intCountry] `intCountry` [intCountry], CAST([Country] as NVARCHAR(255)) as [Country], [EMEA] --table [ApolloData] [dbo].[dtproperties] `ApolloData` `dtproperties` [id],[property] `id`,`property` [id], [objectid], CAST([property] as NVARCHAR(64)) as [property], CAST([value] as NVARCHAR(255)) as [value], [uvalue], [lvalue], [version] --table [ApolloData] [dbo].[tblAWArticles] `ApolloData` `tblAWArticles` [IntPRCId] `IntPRCId` [IntPRCId], [DatArticleDate], [StrHeadline], [StrWebAddress], [IntWordCount], [IntSourceId], [datMonth], [IntSourceCategoryId], [intArticleCountry] --table [ApolloData] [dbo].[tblAWThemes] `ApolloData` `tblAWThemes` [intCategoryID] `intCategoryID` [intCategoryID], [strCategory] --table [ApolloData] [dbo].[u] `ApolloData` `u` [userid] `userid` [userid], CAST([email] as NVARCHAR(255)) as [email], CAST([password] as NVARCHAR(255)) as [password], CAST([token] as NVARCHAR(255)) as [token], CAST([username] as NVARCHAR(255)) as [username], [active], CAST([prosp_api_key] as NCHAR(32)) as [prosp_api_key], CAST([email_token] as NCHAR(64)) as [email_token] --table [ApolloData] [dbo].[TblMonths] `ApolloData` `TblMonths` [DatMonth], [StrMonth], [DatMonthEnd] --table [ApolloData] [dbo].[tblAWCompanies] `ApolloData` `tblAWCompanies` [IntCompanyID] `IntCompanyID` [IntCompanyID], [StrCompanyName], [StrCompanySort], [StrCorporateWebsite], [intCompanyActivity] --table [ApolloData] [dbo].[tblAWJournalists] `ApolloData` `tblAWJournalists` [IntJournalistId] `IntJournalistId` [IntJournalistId], [StrJournalistName], [StrFirstName], [StrSurName] --table [ApolloData] [dbo].[tblCompanies] `ApolloData` `tblCompanies` [IntCompanyID], [StrCompanyName] --table [ApolloData] [dbo].[TblArticleCountries] `ApolloData` `TblArticleCountries` [intCountry] `intCountry` [intCountry], CAST([Country] as NVARCHAR(255)) as [Country], [EMEA] --table [ApolloData] [dbo].[tblAWAnalysts] `ApolloData` `tblAWAnalysts` [intPersonID] `intPersonID` [intPersonID], [intCompanyID], [strPerson], [StrFirstName], [StrLastName], [StrBiogSite], [strAnalystJobTitle], [intAnalystCountry], CAST([StrTwitterId] as NVARCHAR(50)) as [StrTwitterId], CAST([StrLinkedInId] as NVARCHAR(250)) as [StrLinkedInId] --table [ApolloData] [dbo].[tblAWArticleContent] `ApolloData` `tblAWArticleContent` [IntPRCId],[IntType],[IntTypeId],[IntScore],[IntMentions] `IntPRCId`,`IntType`,`IntTypeId`,`IntScore`,`IntMentions` [IntPRCId], [IntType], [IntTypeId], [IntScore], [IntMentions] --table [ApolloData] [dbo].[tblAWSources] `ApolloData` `tblAWSources` [intSourceID] `intSourceID` [intSourceID], [strSource], [strPRCCategory], [IntCategoryId], [hypWebSite], [intSourceCountry] --table [ApolloData] [dbo].[tblCategoryGroup] `ApolloData` `tblCategoryGroup` [intCategoryGroupID], [strCategory] 16:12:57 [INF][ copytable]: Connecting to MySQL server at localhost:3306 with user finley 16:12:57 [INF][ copytable]: Connection to MySQL opened 16:12:57 [INF][ copytable]: Opening ODBC connection to [Mssql] 'DRIVER={FreeTDS};SERVER=127.0.0.1;PORT=1433;DATABASE=ApolloData;UID=sa;;TDS_VERSION=7.1;PWD=XXX' 16:12:57 [INF][ copytable]: ODBC connection to 'DRIVER={FreeTDS};SERVER=127.0.0.1;PORT=1433;DATABASE=ApolloData;UID=sa;;TDS_VERSION=7.1;PWD=' opened 16:12:57 [INF][ copytable]: Connecting to MySQL server at localhost:3306 with user finley 16:12:57 [INF][ copytable]: Connection to MySQL opened 16:12:57 [INF][ copytable]: Opening ODBC connection to [Mssql] 'DRIVER={FreeTDS};SERVER=127.0.0.1;PORT=1433;DATABASE=ApolloData;UID=sa;;TDS_VERSION=7.1;PWD=XXX' `ApolloData`.`tblAWJournoLink`:Copying 2 columns of 43123 rows from table [ApolloData].[dbo].[tblAWJournoLink] 16:12:57 [INF][ copytable]: ODBC connection to 'DRIVER={FreeTDS};SERVER=127.0.0.1;PORT=1433;DATABASE=ApolloData;UID=sa;;TDS_VERSION=7.1;PWD=' opened 16:12:57 [INF][ copytable]: Connecting to MySQL server at localhost:3306 with user finley 16:12:57 [INF][ copytable]: Connection to MySQL opened `ApolloData`.`TblAnalystCountries`:Copying 3 columns of 50 rows from table [ApolloData].[dbo].[TblAnalystCountries] ROR:`ApolloData`.`TblAnalystCountries`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`TblAnalystCountries`:Failed copying 50 rows `ApolloData`.`dtproperties`:Copying 7 columns of 0 rows from table [ApolloData].[dbo].[dtproperties] `ApolloData`.`dtproperties`:Finished copying 0 rows in 0m00s `ApolloData`.`tblAWArticles`:Copying 9 columns of 96996 rows from table [ApolloData].[dbo].[tblAWArticles] ROR:`ApolloData`.`tblAWArticles`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`tblAWArticles`:Failed copying 96996 rows `ApolloData`.`tblAWThemes`:Copying 2 columns of 950 rows from table [ApolloData].[dbo].[tblAWThemes] ROR:`ApolloData`.`tblAWThemes`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`tblAWThemes`:Failed copying 950 rows `ApolloData`.`u`:Copying 8 columns of 1 rows from table [ApolloData].[dbo].[u] ROR:`ApolloData`.`u`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`u`:Failed copying 1 rows `ApolloData`.`TblMonths`:Copying 3 columns of 13 rows from table [ApolloData].[dbo].[TblMonths] ROR:`ApolloData`.`TblMonths`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`TblMonths`:Failed copying 13 rows `ApolloData`.`tblAWCompanies`:Copying 5 columns of 4715 rows from table [ApolloData].[dbo].[tblAWCompanies] ROR:`ApolloData`.`tblAWCompanies`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`tblAWCompanies`:Failed copying 4715 rows `ApolloData`.`tblAWJournalists`:Copying 4 columns of 9302 rows from table [ApolloData].[dbo].[tblAWJournalists] ROR:`ApolloData`.`tblAWJournalists`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`tblAWJournalists`:Failed copying 9302 rows `ApolloData`.`tblCompanies`:Copying 2 columns of 12158 rows from table [ApolloData].[dbo].[tblCompanies] ROR:`ApolloData`.`tblCompanies`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`tblCompanies`:Failed copying 12158 rows `ApolloData`.`TblArticleCountries`:Copying 3 columns of 18 rows from table [ApolloData].[dbo].[TblArticleCountries] ROR:`ApolloData`.`TblArticleCountries`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`TblArticleCountries`:Failed copying 18 rows `ApolloData`.`tblAWAnalysts`:Copying 10 columns of 3193 rows from table [ApolloData].[dbo].[tblAWAnalysts] ROR:`ApolloData`.`tblAWAnalysts`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`tblAWAnalysts`:Failed copying 3193 rows `ApolloData`.`tblAWArticleContent`:Copying 5 columns of 1126936 rows from table [ApolloData].[dbo].[tblAWArticleContent] `ApolloData`.`tblAWJournoLink`:Finished copying 43123 rows in 0m03s `ApolloData`.`tblAWSources`:Copying 6 columns of 1397 rows from table [ApolloData].[dbo].[tblAWSources] ROR:`ApolloData`.`tblAWSources`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`tblAWSources`:Failed copying 1397 rows `ApolloData`.`tblCategoryGroup`:Copying 2 columns of 1246 rows from table [ApolloData].[dbo].[tblCategoryGroup] ROR:`ApolloData`.`tblCategoryGroup`:Error during charset conversion of wstring: Success ERROR: `ApolloData`.`tblCategoryGroup`:Failed copying 1246 rows `ApolloData`.`tblAWArticleContent`:Finished copying 1126936 rows in 2m01s 16:14:59 [INF][ copytable]: Re-enabling triggers for schema 'ApolloData' 16:14:59 [INF][ copytable]: No triggers found for 'ApolloData' FINISHED Copy helper has finished Data copy results: - `ApolloData`.`tblAWJournoLink` has succeeded (43123 of 43123 rows copied) - `ApolloData`.`TblAnalystCountries` has FAILED (0 of 50 rows copied) - `ApolloData`.`dtproperties` has succeeded (0 of 0 rows copied) - `ApolloData`.`tblAWArticles` has FAILED (0 of 96996 rows copied) - `ApolloData`.`tblAWThemes` has FAILED (0 of 950 rows copied) - `ApolloData`.`u` has FAILED (0 of 1 rows copied) - `ApolloData`.`TblMonths` has FAILED (0 of 13 rows copied) - `ApolloData`.`tblAWCompanies` has FAILED (0 of 4715 rows copied) - `ApolloData`.`tblAWJournalists` has FAILED (0 of 9302 rows copied) - `ApolloData`.`tblCompanies` has FAILED (0 of 12158 rows copied) - `ApolloData`.`TblArticleCountries` has FAILED (0 of 18 rows copied) - `ApolloData`.`tblAWAnalysts` has FAILED (0 of 3193 rows copied) - `ApolloData`.`tblAWArticleContent` has succeeded (1126936 of 1126936 rows copied) - `ApolloData`.`tblAWSources` has FAILED (0 of 1397 rows copied) - `ApolloData`.`tblCategoryGroup` has FAILED (0 of 1246 rows copied) 3 tables of 15 were fully copied Click [Retry] to retry copying remaining data from tables Copy data to target RDBMS finished Tasks finished with warnings and/or errors, view the logs for details Finished performing tasks.