I need transfer to a database in MS SQL Server 2008 to MySQL. I am new to MySQL (never use it before). And my task just transfer it for someone else. I will not use MySQL later
so what is the best way to do it?
I have install the latest version of MySQL to same machine of SQL Server 2008. Then I try
(1) export data , but I got error like the 1st image
(2) I know SSIS, and follow the instruction I did it as 2nd image with error message below. I can successfully create table in MySQL but can not insert data into it
[ADO NET Destination ] Error: An exception has occurred during data insertion, the message returned from the provider is: Unknown column 'p1' in 'field list' --> I don't know where 'p1' comes from I don't have a 'p1' field in the table
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "ADO NET Destination" (96) failed with error code 0xC020844B while processing input "ADO NET Destination Input" (99). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
I might miss something since I am brand new to MySQL. My DB in SQL server is about 10GB. I think this is just a one time task. so I am open for any methods which can transfer the DB to MySQL
thanks in advance