question

aRookieBIdev avatar image
aRookieBIdev asked

MYSQL TO SQL Server

Hi , I have a MYSQL Database in a Linux server. I need to pull the data from mysql into my MS SQL SERVER 2012. Can i use an SSIS package to pull it directly or should i extract the data into files and move it locally and import data from the file. Thanks in advance. Kannan
ssissql-server-2008-r2mysql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
Yes you should be able to use SSIS to do this. Here's an older article but it should still be relevant. https://www.mssqltips.com/sqlservertip/2613/export-data-from-mysql-to-sql-server/ Hope that helps!
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.