• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

From SQL Server to MySQL

Hi,

We have SugarCRM application (MySQL Database), and later on, daily, we need to import from SQL Server to the MySQL database. This needs to be done automatically (scheduler)

My questions :
What is the best way to do that? and we don't have any budget to buy MySQL Export Import tool

I think there are some alternatives :
- Make that the SQL Server to export to MySQL
- Make a PHP funtion that read from SQL server and write it to MySQL, The make CRON job to schedule the job.
- Is there any other alternative to do that?
0
softbless
Asked:
softbless
2 Solutions
 
LowfatspreadCommented:
you could schedule it all from the ms sql server side....

you could define the mysql database as a linked server on the ms sql instance , and perform all the necessary

etl style processing there... (or at least do the extract and an ftp to your mysql server,,,)


look at MS SQL Server SSIS jobs....
0
 
Aaron TomoskySD-WAN SimplifiedCommented:
Youcan export schemea and or data from SQL management studio.  There must be a way to script it.  Also I've done the export using mysql GUI tools which is now part of mysql workbench or somethig. It connects to ms SQL and directly imports to mysql. Again I don't know if it can be scripted.
0
 
softblessAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now