MySQL / SQL Server... working together as a total solution

Question

Hi,

I want to user sql server for analysis services, and a few other small apps.

The majority of our systems are in MySQL. Things like user info, customer info, sales data I need to get into SQL Server.

Obviously, there is much to debate here. What I was attempting to do is to dump a read only copy into SQL Server so I can user reporting services / analysis services.

Now before you go ahead and say that you can just access MySQL in report services, small things don't work, like stored proc column names in the report designer etc..

Is anyone doing this? Do shops out there run both happily and have some sort of sync go on?

Answer 1

If all your code is mysql, then you may as well leave it like that. You can easily use SSIS to pull data in from mysql, and make it data warehouse friendly.

I have plenty of clients who pull data in from a variety of systems. It's not worth trying to make them all use SQL Server, no matter how much my SQL expertise would like that.