?
Solved

Transfer a DB from SQL Server 2008 to MySQL

Posted on 2011-02-25
4
Medium Priority
?
2,004 Views
Last Modified: 2012-05-11
Hi,

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

[error message]
[ADO NET Destination [96]] 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

[error message]
[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
export-error.jpg
SSIS-error.jpg
0
Comment
Question by:rmtogether
  • 3
4 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 2000 total points
ID: 34981876
0
 
LVL 17

Assisted Solution

by:dbaSQL
dbaSQL earned 2000 total points
ID: 34981908
0
 

Author Closing Comment

by:rmtogether
ID: 34991967
thank you guys
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 34992079
My pleasure.  Good luck!
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question