Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nimrodm
Starting Member
12 Posts |
 Posted - 2009-12-17 : 14:45:32
|
| Hello people,I have an question for you.I wanna take mySQL db and integrate it with Sql server.What is the best way to do it?I read that there is option to create linked server of mySQLin Sql server and then use it in SSIS. Why should we do it if we can add ODBC for the MySQL trough the SSIS?In other words, what is better - create linked server and work with it in SSIS or to use ODBC? and why?I will be glad to hear what are the cons and advs..sorry for my poor english.Thanks. |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-12-17 : 21:12:52
|
| If you use a linked server then you code can be in a stored procedure on the SQL server and you don't need SSIS. It really all depends on what you are going to do with the data.An infinite universe is the ultimate cartesian product. |
 |
|
|
nimrodm
Starting Member
12 Posts |
Posted - 2009-12-18 : 06:37:52
|
| Yes, but I want to create processes via the SSIS which combinate the two db servers.I get data from two sources (one of them is mySQL) and I want to merge and insert them into SQLserver.What do you say? |
|
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-12-18 : 10:28:20
|
| In that case I would create a new connection in SSIS for the mySQL database. Use the ADO.NET connection manager and then use your ODBC connection.The reason to use a linked server on the SQL server would be for moving data via SQL which is a lot easier for straightforward moves.An infinite universe is the ultimate cartesian product. |
|
|
|
nimrodm
Starting Member
12 Posts |
Posted - 2009-12-19 : 09:01:39
|
| What is your meaning in your last paragraph?"The reason to use a linked server on the SQL server would be for moving data via SQL which is a lot easier for straightforward moves."Which moving data via SQL SERVER examples you can bring?Interesting question - Why ADO.net and not OLE DB?What is the different and the reason to use ADO.net and not OLE DB in my case?Thx!!!Nimrod |
|
|
|
|
|
|
linked server in SSIS