Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2012
    Posts
    7

    Unanswered: 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?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You're going to need to phrase your problem more clearly and coherently if you want an answer.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Aug 2012
    Posts
    1
    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.

  4. #4
    Join Date
    Aug 2012
    Posts
    7
    Thanks Erilong, This is a good one and hope I get the perfect solution.

  5. #5
    Join Date
    Jan 2002
    Location
    Czech Republic
    Posts
    14
    Take a look at DBSync for MSSQL and MySQL Trigger-based synchronization implemented recently makes the sync process faster in times.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •