SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: MySQL

  1. #1
    Bah, I'll just hack it DoobyWho's Avatar
    Join Date
    Jul 2002
    Posts
    476
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL

    Is MySql and MS Sql Server compatible?

  2. #2
    morphine for a wooden leg randem's Avatar
    Join Date
    Jun 2002
    Location
    .chicago.il.us
    Posts
    957
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Perhaps you should better explain your question.

    Syntactically, no. They're not compatible.
    ----Adopt-a-Sig----
    Your message here!

  3. #3
    Bah, I'll just hack it DoobyWho's Avatar
    Join Date
    Jul 2002
    Posts
    476
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    One of our clients wishes to use their SQL server at their office to interact with the website. Right now the website data stored on a MySQL database. How would we go about enabling them to update the site through the SQL database instead?

  4. #4
    morphine for a wooden leg randem's Avatar
    Join Date
    Jun 2002
    Location
    .chicago.il.us
    Posts
    957
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Mostly, it's just a matter of exporting the data from MySQL and importing it into MS SQL Server. That's not too hard.

    The more unfriendly part is that you'll have to change the code of the site to use MSSQL functions instead of MySQL functions, in addition to checking the syntax for all the SQL queryies for syntax that has to be changed.
    ----Adopt-a-Sig----
    Your message here!


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
  •