Re: MySQL Workbench Migration Invalid Column Name for some tables
Posted by: Marc Nesheim
Date: March 22, 2013 08:24AM

Hi Dmitry,

After looking at the log closer I see where the problem is. Below is the first error that I see when trying to copy the data from the MS SQL server.

ERROR: `Engineering`.`RFApprovalForms`:SQLExecDirect(SELECT [SiteID], [isRunning], [NSectors], [FormID], [SiteTextID], [DateUpdated], [CreatedBy], [Latitude], [Longitude], [TxRxAGL], [DiversityRxAGL], [RFCandidateRank], [TowerTypeStructure], [DesiredTxAMSL], [TowerCompany], [TowerCoSiteID], [Address], [County], [State], [S1AzimuthTxRxAnt], [S1RADcenterTxRxAnt], [S1AntennaModelTxRxAnt], [S1AntennaDimentionsTxRxAnt], [S1MechanicaluptiltTxRxAnt], [S1CoaxRunLengthTxRxAnt], [S1CoaxSizeTxRxAnt], [S1AzimuthRxDiversityAnt], [S1RADcenterRxDiversityAnt], [S1AntennaModelRxDiversityAnt], [S1AntennaDimentionsRxDiversityAnt], [S1MechanicaluptiltRxDiversityAnt], [S1CoaxRunLengthRxDiversityAnt], [S1CoaxSizeRxDiversityAnt], [S2AzimuthTxRxAnt], [S2RADcenterTxRxAnt], [S2AntennaModelTxRxAnt], [S2AntennaDimentionsTxRxAnt], [S2MechanicaluptiltTxRxAnt], [S2CoaxRunLengthTxRxAnt], [S2CoaxSizeTxRxAnt], [S2AzimuthRxDiversityAnt], [S2RADcenterRxDiversityAnt], [S2AntennaModelRxDiversityAnt], [S2AntennaDimentionsRxDiversityAnt], [S2MechanicaluptiltRxDiversityAnt], [S2CoaxRunLengthRxDiversityAnt], [S2CoaxSizeRxDiversityAnt], [S3AzimuthTxRxAnt], [S3RADcenterTxRxAnt], [S3AntennaModelTxRxAnt], [S3AntennaDimentionsTxRxAnt], [S3MechanicaluptiltTxRxAnt], [S3CoaxRunLengthTxRxAnt], [S3CoaxSizeTxRxAnt], [S3AzimuthRxDiversityAnt], [S3RADcenterRxDiversityAnt], [S3AntennaModelRxDiversityAnt], [S3AntennaDimentionsRxDiversityAnt], [S3MechanicaluptiltRxDiversityAnt], [S3CoaxRunLengthRxDiversityAnt], [S3CoaxSizeRxDiversityAnt], [S4AzimuthTxRxAnt], [S4RADcenterTxRxAnt], [S4AntennaModelTxRxAnt], [S4AntennaDimentionsTxRxAnt], [S4MechanicaluptiltTxRxAnt], [S4CoaxRunLengthTxRxAnt], [S4CoaxSizeTxRxAnt], [S4AzimuthRxDiversityAnt], [S4RADcenterRxDiversityAnt], [S4AntennaModelRxDiversityAnt], [S4AntennaDimentionsRxDiversityAnt], [S4MechanicaluptiltRxDiversityAnt], [S4CoaxRunLengthRxDiversityAnt], [S4CoaxSizeRxDiversityAnt], [S5AzimuthTxRxAnt], [S5RADcenterTxRxAnt], [S5AntennaModelTxRxAnt], [S5AntennaDimentionsTxRxAnt], [S5MechanicaluptiltTxRxAnt], [S5CoaxRu FROM [Engineering].[dbo].[RFApprovalForms])

The problem is that the column name right before "FROM" has been chopped off. So the column name is incomplete and the list of columns is also incomplete. So I am guessing that MySQL Workbench has a character limit on the list of columns that can be copied at one time.

I have also opened up a bug against MySQL Workbench for this issue. http://bugs.mysql.com/bug.php?id=68729

Thanks for any help here!

Marc

Options: ReplyQuote




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.