batchmove mySQL to Oracle

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Seifert
Posts: 1
Joined: Tue 24 Apr 2012 09:13

batchmove mySQL to Oracle

Post by Seifert » Wed 25 Apr 2012 12:15

Hello,

I have a mySQL table with a tinyint field. In the oracle table I have this field as a number. If I execute the batch move component then I have an error: field is not integer.

Is there a datatype in oracle for tinyint? Or is there another way to copy the data with different datatypes?

Thanks

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Wed 25 Apr 2012 13:43

Hello,

I have checked the data transfer with the help of the TCRBatchMove component at the tables with MySQL - TINYINT(4) and Oracle - NUMBER fields, and the data is transferred with no errors. Please make sure that the fields order in both DataSet's is the same and that you are using the latest MyDAC and ODAC versions. If the error repeats even on the latest versions with the correct fields order, please send the scripts for creating and filling the tables to alexp*devart*com and also specify your IDE version

Post Reply