Data Type Not Supported
Posted: Fri 28 Jun 2013 17:24
I am very interested in using the product to migrate an existing project from SQL Server using the standard linq to sql support in visual studio 2010 to a MySQL database. For this I chose the trial version, if I can get everything working I will buy a full license.
After using the migration wizard, I am getting a number of "data type not supported" errors. I will post the full error listing below but the issue is with the following two data types:
and
I also get the last error on NVarChar(MAX) (I'm assuming any NVarChar type). The first error is very crippling because the automatic SQL Server to MySQL conversion seems to have chosen BigInt as the type for my primary keys.
It looks like either I have something set up wrong in linqconnect or my schema on the mysql server needs to be modified. Can anyone give me a suggestion for how to proceed with either option?
thanks a lot,
Max
Full list of errors:
After using the migration wizard, I am getting a number of "data type not supported" errors. I will post the full error listing below but the issue is with the following two data types:
Code: Select all
The data type 'BigInt NOT NULL IDENTITY' is not supported.
Code: Select all
The data type 'NVarChar(50)' is not supported.
It looks like either I have something set up wrong in linqconnect or my schema on the mysql server needs to be modified. Can anyone give me a suggestion for how to proceed with either option?
thanks a lot,
Max
Full list of errors:
Code: Select all
Error 108 The ServerDataType value of the Column element 'WavFileName' in the Type element 'Video' is not valid. The data type 'NVarChar(50)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 104 The ServerDataType value of the Column element 'VideoSourceId' in the Type element 'VideoSource' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 111 The ServerDataType value of the Column element 'VideoShotId' in the Type element 'VideoShot' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 112 The ServerDataType value of the Column element 'VideoShotFileName' in the Type element 'VideoShot' is not valid. The data type 'NVarChar(50)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 106 The ServerDataType value of the Column element 'VideoIdAtSource' in the Type element 'Video' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 105 The ServerDataType value of the Column element 'VideoId' in the Type element 'Video' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 109 The ServerDataType value of the Column element 'VideoFrameId' in the Type element 'VideoFrame' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 110 The ServerDataType value of the Column element 'VideoFrameFileName' in the Type element 'VideoFrame' is not valid. The data type 'NVarChar(50)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 107 The ServerDataType value of the Column element 'VideoFileName' in the Type element 'Video' is not valid. The data type 'NVarChar(50) NOT NULL' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 117 The ServerDataType value of the Column element 'UserFriendlyName' in the Type element 'Concept' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 125 The ServerDataType value of the Column element 'TextMetaData' in the Type element 'ConceptInstanceView' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 119 The ServerDataType value of the Column element 'TextMetaData' in the Type element 'ConceptInstance' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 127 The ServerDataType value of the Column element 'SpatioTemporalMetaData' in the Type element 'ConceptInstanceView' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 121 The ServerDataType value of the Column element 'SpatioTemporalMetaData' in the Type element 'ConceptInstance' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 126 The ServerDataType value of the Column element 'SpatialMetaData' in the Type element 'ConceptInstanceView' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 120 The ServerDataType value of the Column element 'SpatialMetaData' in the Type element 'ConceptInstance' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 123 The ServerDataType value of the Column element 'MetaData' in the Type element 'ConceptThreshold' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 102 The ServerDataType value of the Column element 'MetaData' in the Type element 'ConceptEvidence' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 115 The ServerDataType value of the Column element 'MetaData' in the Type element 'Algorithm' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 113 The ServerDataType value of the Column element 'FileDirectoryId' in the Type element 'FileDirectory' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 103 The ServerDataType value of the Column element 'DataSourceId' in the Type element 'DataSource' is not valid. The data type 'Int NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 101 The ServerDataType value of the Column element 'ConceptTypeId' in the Type element 'ConceptType' is not valid. The data type 'Int NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 124 The ServerDataType value of the Column element 'ConceptInstanceId' in the Type element 'ConceptInstanceView' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 118 The ServerDataType value of the Column element 'ConceptInstanceId' in the Type element 'ConceptInstance' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 116 The ServerDataType value of the Column element 'ConceptId' in the Type element 'Concept' is not valid. The data type 'Int NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 122 The ServerDataType value of the Column element 'ComparisonOperator' in the Type element 'ConceptThreshold' is not valid. The data type 'NVarChar(50)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 114 The ServerDataType value of the Column element 'AlgorithmId' in the Type element 'Algorithm' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1