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

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,
0
jaguar4u
Asked:
jaguar4u
  • 3
  • 2
1 Solution
 
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
 
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
 
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

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