john_zakaria
11-02-2009, 07:29 AM
i have a site of a Clothing store .. the local database in the store is MSSQL but the database on server is MYSQL....
i want to make instant synchronization so when someone buy a cloth from the store it will be deleted from database (MSSQL) to ensure that it is bought.. i want also to remove it from the database of phpmyadmin at the same time.. so if anyone tries to buy it from the shopping card online he will find that this product is already sold..
so i need an instant synchronization program or an y other idea between mssql and mysql so any changes in mssql will chnage the database in phpmyadmin...
i want to make instant synchronization so when someone buy a cloth from the store it will be deleted from database (MSSQL) to ensure that it is bought.. i want also to remove it from the database of phpmyadmin at the same time.. so if anyone tries to buy it from the shopping card online he will find that this product is already sold..
so i need an instant synchronization program or an y other idea between mssql and mysql so any changes in mssql will chnage the database in phpmyadmin...