3

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?

closed as too broad by LowlyDBA, Gaius, mustaccio, Colin 't Hart, hot2use Jun 13 '18 at 17:52

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

0

You can use Linked Server for SQL Server side. Creata a stored procedure to check online mysql tables data. If product sold decrease the local product count on the Local SQL Server.

Why do you cover this problem on the application side using transaction ?

Not the answer you're looking for? Browse other questions tagged or ask your own question.