SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    May 2007
    Posts
    92
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Search from MY SQL AND MS SQL at the same time?

    hi all, i got a project that have existing database which is using the MySQL. but now this project need to do a new version and MS SQL is used as database for the new version. so the old data is remain store in the my sql but the new data will store into the new DB(MS SQL). i got a problem here, do u think when i do the searching function, it can search the old data from the MY SQL DB, and the new data from the MS SQL DB at the same time? who can share with me about this knowledge? thank you very much.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    yes you can do it, but not "at the same time" -- just issue 2 search queries, and combine the results in your application language
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


Bookmarks

Posting Permissions

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