?
Solved

Transfer a DB from SQL Server 2008 to MySQL

Posted on 2011-02-25
4
Medium Priority
?
1,968 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 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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…
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…

752 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