Solved

Transfer a DB from SQL Server 2008 to MySQL

Posted on 2011-02-25
4
1,950 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

734 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