Solved

Transfer a DB from SQL Server 2008 to MySQL

Posted on 2011-02-25
4
1,919 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 500 total points
ID: 34981876
0
 
LVL 17

Assisted Solution

by:dbaSQL
dbaSQL earned 500 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Creating and Managing Databases with phpMyAdmin in cPanel.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This video discusses moving either the default database or any database to a new volume.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now