Hi Gurus, We need to have a mechanism to sync data (replication) between Ms Sql DB and My sql DB. May I request to provide clarification for following questions in this regards: 1. Can we use SSIS for this purpose? 2. If yes, how the packages are triggered when any of the table is updated? 3. Is there a way to create the service which can send the accept the request with parameters and give the response? Thanks in advance. Regards, Venkatesh G

I don't recommend this way, this will be HEAVY load on server. because with every change you run synchronization mechanism. But I recommend a SCHEDULED synchronization mechanism, you can set schedule as daily or each 6 hours ... in this way you don't need trigger just you need a scheduled job which can be run by sql server agent, and yes, you can use SSIS for this purpose.http://www.rad.pasfu.com

Thank you Raad, your recommendation is appreciated. May I request you to give your opinion on point 3: 3. Is there a way to create the service which can send the accept the request with parameters and give the response? Regards Venkatesh G

Thank you Raad, your recommendation is appreciated . May I request you to give your opinion on point 3: 3. Is there a way to create the service which can send the accept the request with parameters and give the response? Regards Venkatesh G I'm not clear about this question. what do you mean exactly? Do you mean that you want to be sure that synchronization applied correctly? or something else?http://www.rad.pasfu.com

Let me put it this way: Can I expose the SSIS services / Package as Webservices, which can be consumed from php programs?

Let me put it this way: Can I expose the SSIS services / Package as Webservices, which can be consumed from php programs? there is no SSIS Service which you can call from php application. but you can run ssis package from command prompt with DTEXEC command, there should be a way in php code to run a command. for details of DTEXEC Command look here: http://msdn.microsoft.com/en-us/library/ms162810.aspxhttp://www.rad.pasfu.com

Thank you once again Raad. It really help full. regards Venkatesh G