I have a rare scenario. Is there any possibility to achieve the target? Here is the situation:
I have developed a responsive site for a supermarket. I am using php with foundation framework and the back-end is MySQL. It is for promoting their products. They already having software for billing, which was developed using WPF with SQL Server back-end. Now they need to include online shopping in the web site, and they need to reduce the product from the local software according to the online sale.
I can use replication if both the databases are the same. But in this case, the local DB is SQL Server and the live DB is MySQL. How can I achieve the target of syncing live and local DBs?