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 |
|
SergioM
Posting Yak Master
170 Posts |
 Posted - 2010-10-31 : 12:36:22
|
| Hey! I'm new to SQL but not to programming or computers at large. So I have a few questions/concerns which are outside of my understanding.I have an in house server that uses MS SQL Server 2005. I would like to link that with my website's MySQL Server 5.x, so I've hired someone to create an SSIS package that would perform ETL operations daily. However after some time, he now tells me that an SSIS package is not possible and that we would need a .Net application to act as the intermediary. This brings many questions1) Is it possible that it really isn't possible to make an SSIS package between SQL Server 2005 & MySQL? I've read a lot about this and all signs point to it having a few setbacks, but tutorial after another seem to say that it's possible. Did I miss something?2) Am I right to want to stick to SSIS? I'm afraid that a custom application is likely to be unstable & Inflexible. If I need to change something, I would like to be able to do it by hiring anyone else. Not just the guy who knows what he wrote and how he wrote it. Thanks for the help. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-10-31 : 12:55:57
|
| What makes you think that an ssis package would be any more maintainable than an application.If you're worry about skillstes and all you want is a transfer of data then extreact to files then import the files - that means the two systems are isolated and you don't have to connect the two together - would probably find it causes less pain in the long run - the sqls server processing is done on sql server and the mysql on mysql.I would be very surprised if you couldn't create an odbc connection to mysql that was accessible from ssis though.In fact here's someone who's done ithttp://blogs.msdn.com/b/mattm/archive/2009/01/07/writing-to-a-mysql-database-from-ssis.aspx==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-11-01 : 12:30:04
|
| 1) Is it possible that it really isn't possible to make an SSIS package between SQL Server 2005 & MySQL?No. It is easy to do. Anyone telling you it isn't possible doesn't know what they are doing. You just need the MySQL driver installed on the MS SQL machine, and you need a valid login to MySQL. Sounds like you need to hire someone who has actually done this kind of work before.2) Am I right to want to stick to SSIS?Sure. This is most likely how I'd do it. There's lots of ways, but SSIS is the way I do it. Also, this way you have total control over it. |
|
|
|
SergioM
Posting Yak Master
170 Posts |
Posted - 2010-11-05 : 23:44:56
|
| Ahh, thank you both very, VERY much. This is one of those situations where a little good advice can spare me needless expenses and awful results. I'm happy to hear that I'm on the right track |
|
|
|
|
|
|
SSIS between SQL Server 2005 & MySQL Server