SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict bimalpoudel's Avatar
    Join Date
    Feb 2009
    Location
    Kathmandu, Nepal
    Posts
    279
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Convert MySQL database to MSSQL and upgrade PHP Scripts

    Hi folks,
    I need to migrate to MSSQL from MySQL. The application is complete and working in MySQL.
    I do not know the detailed differences in SQL, connection objects etc about MSQSL.
    I have more than 100 unique pages full of MySQL queries that do some basic things like:
    searching, paginations, add/edit/delete of the records.

    What factors should I consider while taking this change?
    I would prefer to choose a quicker way to move the database, and upgrade the corresponding PHP Scripts.

    Thanks.
    Bimal Poudel @ Sanjaal Framework over Smarty Template Engine
    ASKING INTERESTING QUESTIONS ON SITEPOINT FOURM

    Hire for coding support - PHP/MySQL

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,017
    Mentioned
    53 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by bimalpoudel View Post
    What factors should I consider while taking this change?
    time

    this is going to take a long time, and you need to allow for it

    you will have to test every single query, and rewrite many of them
    r937.com | rudy.ca | 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
  •