Data migration from MYSQL to SQL SERVER 2008 R2

Dear All,

I have a production databsae on MySQL and want to send some data everyday to SQL SERVER 2008 R2 as a job. Kindly advice if this is possible to create a link server for MySQL in SQL SERVER 2008 R2.

Many Thanks,
jaguar4uAsked:
Who is Participating?
 
Jerryuk007Commented:
- Do you know DTS (SQL 2000)? SSIS is like DTS but for MSSQL 2005 and above.

Not the best practice, but you can create a DTS on a SQL 2000 DB Server and then import it in SQL 2008.

SSIS are written using BI (component of Visual Studio which can be installed from the MSSQL 2008 installation). Then it's mainly drag&drop...

Jerry
0
 
Jerryuk007Commented:
You might not need to create a linked server...
You can just create an SSIS Package with the connection to your MySQL Database (likely using OLEDB or ODBC Connection), then you can add all the Transformation Tasks and Data Manipulation you wish.

After you just need to schedule that SSIS to run at specific time through MSSQL Agent.

Jerry
0
 
jaguar4uAuthor Commented:
Thank you for your kind response.

Is possible to assist me with SSIS Package creation?

Thanks
0
 
jaguar4uAuthor Commented:
Thank you, i followed the following tutorial and problem solved with your help...

http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm

Thank you
0
 
jaguar4uAuthor Commented:
Thank you, you saved lot of my time.
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.

All Courses

From novice to tech pro — start learning today.