August 31st, 2012, 06:22 AM
Database replication question?
I have a question.
Currently our client has a website where they are using aspx as front end and SQL server as back end. We are developing same functionality using php and my sql.
Currently 1 phase of development is finished. They are using both applications to do the job. Now in 2nd integration they are asking the data sync from one database to other.
We have decided once the user enters the aspx form the data will be stored in client sql server but we though of writing a script to enter this info into a csv file so that from our side we access that file and update in mysql.
Other than ftp any other better approaches to access that file on client server?
Is there any possibility to sync databases directly?
Please give some suggestions?