SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Zealot
    Join Date
    May 2002
    Posts
    182
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Using MS SQL and MYSQL together?

    Forgive me, as I know very little about databases. I'm trying to gauge whether or not it's possible for a website to use both MS SQL and MYSQL together. I work for a company that is in need of a new forum software and I'm trying to see if vBulletin will work, but we currently use NT servers and MS SQL. I'd like to use vBulletin for the forums solution, yet maintain the existing solution we have that allows users to submit content to our MS SQL database. The goal would be to store the user data in vBulletin's MYSQL database, and enable the registered vBulletin users to submit content to the MS SQL database - basically using vBulletin's registration system to validate the users to submit content to both databases. Is this possible?

    I know some will suggest this, so let me just say that completely moving everything to MYSQL isn't an option at this point.

  2. #2
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    I'm sure it is, as I evaluated a similar situation about a year ago. We decided it wasn't for us, but not for lack of trying.

    My suggestion, though, would be to use windows-level programming to achieve cross-talk, as opposed to trying to get vB to talk to SQL Server, etc.

    Simply write a DTS app on you SQL Server machine which will do maintenance between the 2 db's. It's a bit of extra work for MIS, but it's worth it, especially since it sounds like this is a bit of an experiment
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  3. #3
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Contact John@vbulletin.com

    He may have some good news for you!

  4. #4
    SitePoint Zealot
    Join Date
    May 2002
    Posts
    182
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    sent him an email...

    but he never responded. What kind of good news would he have?

  5. #5
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Just some things in regards to vB and MS SQL Server. What did you send in your email?

  6. #6
    SitePoint Zealot
    Join Date
    May 2002
    Posts
    182
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I mentioned that someone here on SitePoint recommended I ask him this question, and posted my original question... I've posted this on vBulletin also, but no reply from them yet.

  7. #7
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm wondering if we'll see a publicly available Sybase release of vBulletin?

    Aaron
    Aaron Brazell
    Technosailor



  8. #8
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    In conjunction with a MS SQL version perhaps?

  9. #9
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What about Oracle? What about...:gasp:....DB2?
    Aaron Brazell
    Technosailor



  10. #10
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Cannot comment, not my area of DBA-ing expertise.


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
  •