WordPress and MicrosoftSQL database

  • I have created a basic cms in WordPress using a number of plugins to include company information, photos, etc.

    The information about employes are on external MicrosoftSQL database.

    How can I display data(tables,views) from external MicrosoftSQL database to WordPress page?
    How I can connect to that separate server and query tables,views etc?

    Best regards

    ROxettero

Viewing 3 replies - 1 through 3 (of 3 total)

  • You will most likely have to export the tables from the MSSQL database and import into the WP Database. WordPress itself can not connect to 2 databases at once.

    Actually, WordPress can connect ot more than one database at a time, but you will need to set up your own database connection and handler as WordPress doesn’t have anything that works with MSSQL built into it. If you’re doing this I’d suggest looking at using PDO so you can “rework” things easily if anything changes on the remote system.

    Thread Starter roxettero

    (@roxettero)

    Hi,

    thank You for answers HudsonValleyWebDesign, and Catacaustic. ??

    HudsonValleyWebDesign: You suggest that I simply export the MSSQL view, and than go to phpMyAdmin and import data?

    Catacaustic: I’m concerned a little bit. I was thinking about it, but I don’t have much time to do that, and it seems to me that it can cause lots of problems :).

    Best Regards

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress and MicrosoftSQL database’ is closed to new replies.

Tags