Avatar of SystemSys
SystemSysFlag for Saudi Arabia asked on

What i need to Export data from SQL Server to MySQL DATABASE ?

HELLO ...

i'm Confuseing ,, what i need from Tool to Export DATA FROM SQL SERVER 2005 TO MYSQL DATABASE ?
I Want to tell me what i need , i don't have any idea about mysql ,, but my manage want to Export data from sql server to mysql data base

what i should to download from tool to do that ?
i don't have mysql tool ,,
and i want to tell me what i need ...

and tell me the setp to do that and Export  data after i have a tool for mysql database ,,

please this is very important for me ,,, please help me
Microsoft SQL ServerMySQL Server

Avatar of undefined
Last Comment
SystemSys

8/22/2022 - Mon
gamebits

You could export your data as a CSV file, MySQL support it. We need more information on your MySQL environment to be able to help you.
aterea

From mssql server 2005 you could use an integration project to export the data to the mysql db.
Using an odbc driver on the windows box to connect to the mysql database.
aterea

by integration project i mean "integration services" project.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
Mark Wills

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Faizan Sarwar

ASKER
SystemSys

thank you .. you are the best ,,
i'll accept this answer but i'll returen for discussing this things in ohter time ,, becuase i have a lot of work at this moment ...
and thank you
ASKER
SystemSys

thank you .. you are the best ,,
i'll accept this answer but i'll returen for discussing this things in ohter time ,, becuase i have a lot of work at this moment ...
and thank you
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.