WordPress.org

Ready to get started?Download WordPress

Forums

Database synchronization (8 posts)

  1. Gizmo
    Member
    Posted 1 year ago #

    Our website has a Business directory. We maintenance our Business Database in our local SQL server and update our record once a week. What is the best way to syn the data? We update/add/delete the data (not only add a new record) and also there are over 15000 records.

  2. esmi
    Theme Diva & Forum Moderator
    Posted 1 year ago #

    I'm sorry but what does this have to do with WordPress?

  3. Gizmo
    Member
    Posted 1 year ago #

    I'm open to all options, I'm also thinking if we just integrate between our local SQL server to mySQL.

  4. esmi
    Theme Diva & Forum Moderator
    Posted 1 year ago #

    what does this have to do with WordPress?

  5. Gizmo
    Member
    Posted 1 year ago #

    Yes, we already have a wordpress website and we are going to build a section to display our business directory

  6. esmi
    Theme Diva & Forum Moderator
    Posted 1 year ago #

    So will you be using the WordPress database for this directory?

  7. Gizmo
    Member
    Posted 1 year ago #

    Yes, we use the WordPress database (mySQL) for this directory. I'm looking a best way to transfer data from sql server to WordPress database. Is there a plugin? or other way to do. The objective is to transfer data on a weekly basis from local SQL server to WordPress database (host external).

  8. esmi
    Theme Diva & Forum Moderator
    Posted 1 year ago #

    There's nothing that I'm aware of that would import data from an sql server into a (non-core) WP database table. You'd probably have to build a custom solution for this.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags