Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    12

    Unanswered: Porting an existant application from ms access to Sql server

    My database knowledge are with MySql and Oracle, but recently I was asked to evaluate the migration of an existing (and maybe more) from ms access to sql server. My question is simple, if all of the sql are hard coded into the code ... how well this sql will work, I mean is the sql between access and sql server are plug'n'play ? However in any case, I always rewiew all of the sql.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    No, MS Access SQL is not directly portable to SQLSVR TSQL. They are similiar enough to be identical for simple queries, but moderately complex statements will probably not run on both platforms so some rewriting will be necessary. Also, there are subtle differences in the available datatypes between Access and SQL Server.

    Microsoft provides a wizard for upsizing Access databases SQL Server which does a pretty good job of transferring the tables and converting the code.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313

Posting Permissions

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