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?
Instead of developing custom integration, consider using a heterogenous database synchronization solution. Since you are already using open source products, you might be interested in SymmetricDS, an open source database sync engine. It supports replication between MS SQL-Server and MySQL. It captures data changes and syncs the data in the background over an HTTP protocol. You can configure which tables to sync and how often. There is also data transformation if the data schema is different between the two databases. If you are updating both databases, it can sync changes in both directions and perform conflict resolution. There is also a version called SymmetricDS Pro that has a GUI administrator and is backed with production support services.