How do you get two databases talking to one another

Posted on 2012-08-29
Last Modified: 2012-08-30
Tomorrow I'm giving a presentation and at one point I'm anticipating a questions as far as how to get my database and theirs talking to one another at the end of the day.

In the past, my only response would be to provide an option in the administrative suite which would allow the administrator to download a csv file reflecting that day's activity that could then be imported into the other database.

Is that enough or what sort of options / expectations should I be anticipating so I can sound intelligent?


I realize it depends on the database then I'm needing to communicate with. But if I'm working with MySQL, can I export that data from a csv file and presume that the techs on the other side will have enough to work with?
Question by:brucegust
    LVL 24

    Assisted Solution

    Yes you can export that data, or you can also build an API so that third parties can query your system anytime without giving them a direct database connection.
    LVL 142

    Accepted Solution

    let's put it like this, in "layman's terms": databases don't talk.

    they can only answer questions by either returning data for questions that are named "SELECT this or that", or returning "ok" or "not ok: error xxxx" for questions like "may I INSERT, DELETE or UPDATE this record/data into tables, please".

    so, when you speak about getting databases to "talk" to each other, you need to have something between the 2 databases that ask those questions.
    exporting data from one, importing data to the other.

    and yes, most database engines have tools to simplify the "talk" for importing / exporting.

    if you have mssql server, for example, it can connect directly to other database using odbc or oledb, including oracle, mysql etc .
    so, mssql engine can even import "directly" from such a linked server.

    Author Comment

    So, here's what I'm going to recommend: I'll build an API that allows the administrators to go in and query the database, the resulting screen / csv file has the info they're looking for according to the fields / field names they need in order to be able to import that information into their database.

    They can either export a csv file, or they can provide me a connection to their database and I insert it into their database directly from my API.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (, A SQLite Tidbit: Quick Numbers Table Generation (…
    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now