July 5, 2017 at 12:24 pm
Hi all,
I had to buy a new computer and I am trying to set it to the settings I had on my previous one.
I have a 64 bits Dell-computer, run SQL Server 2012 together with Visual Studio 2010.
Also installed is mySQL, which is 32 bits.
My goal is to move data from mySQL to SQL Server using SSIS
In SSIS I have made the connection between SSIS and SQL Server and this connection works.
For the connection to mySQL I need to install a connector (I forgot how I did this on my previous computer, it's been a long time ago and this is not my regular work).
When I search internet for information I am a bit confused, so many possibilities to choose from.
Can anybody give me a push in the right direction?
Thanks in advance
Hein
July 10, 2017 at 8:43 am
Does mySql have an ODBC driver? If so, you could create a "Linked Server" for when you want to access the data directly from SQL Server. Once you have that installed, then create an ODBC connection in Control Panel. Just remember that if you do a JOIN between any of the remote tables, you'll end up sending the entire set of data from all the JOINED tables, across the network to SQL Server where IT will do the JOIN. In that scenario, be sure to use either OPENQUERY or OPENROWSET, and use a mySql query against the remote database to limit the recordset that gets sent back to SQL Server.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
July 11, 2017 at 5:38 am
Thank you Steve for your advice.
On my previous computer I have worked with a linked server (for a while).
For small tables this was ok, for the larger tables it proved to be unworkable. The amount of data simply was too much.
What I did was to make a copy of the database in SQL Server, and populate that, using SSIS
I now need to recreate the link between my 64 bit SSIS and the 32 bit mySQL.
I have installed a few connectors (I am not sure which one is the correct one) and am trying to activate (maybe some other definition is better?) these in administrative tools.
I am the administrator, but seems to lack administrative rights.
The search to correct this continues
Anyway, thanks for your help
Hein
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply