Results 1 to 3 of 3

Thread: ASA to ASE

  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: ASE to ASA

    (Sorry, My original topic was incorrect! Should be: ASE to ASA)

    A client needs to migrate an Sybase ASE 12.5 db to ASA - Are there any whitepapers, info etc. on the syntax differences between the two systems? The app accessing the db is Powerbuilder 9, I seem to remember that there is an issue with single/double quotes??

    Thanks
    Last edited by farmer; 02-16-04 at 10:19.

  2. #2
    Join Date
    Jan 2004
    Location
    Shanghai,China
    Posts
    76
    If u migrate ASE TO ASA.U must pay attention to them:
    1 DataType of column conversation
    2 U must rewrite all the triggers and procedures,because the SQL syntax is different
    3 If u use some ASE12.5 special feature,It's will be a trickiness.

    if u process all business rules in the client application(PB),so the Mirgration will be simple.

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    T-SQL is quite similar and compatible.
    ASA T-SQL offer more features.
    It's not necessary to rewrite all SP : only small changes are necessary.
    The parmeter quoted identifier must be set correctly.
    Creating an ASA db, use the T-SQL compatibility option

Posting Permissions

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