1. Forum
  2. Usenet
  3. COMP.LANG.XHARBOUR

  • Advantage Database Server

    From Michael Hagl@21:1/5 to All on Wed Mar 15 12:23:36 2023
    Hello,

    does anyone know anything about the Advantage Database server. Obviously SAP has completely discontinued the part. I can't find any way to buy licenses here.

    Best regards Michael Hagl.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From dlzc@21:1/5 to Michael Hagl on Thu Mar 16 08:10:39 2023
    Dear Michael Hagl:

    On Wednesday, March 15, 2023 at 12:23:37 PM UTC-7, Michael Hagl wrote:
    Hello,

    does anyone know anything about the Advantage Database
    server. Obviously SAP has completely discontinued the part.
    I can't find any way to buy licenses here.

    They want you to migrate to "SQL Anywhere", which you may or may not have known (I did not).

    https://userapps.support.sap.com/sap/support/knowledge/en/3136538

    https://www.sapstore.com/solutions/99017/SAP-SQL-Anywhere

    I have no idea what that means other than they want new licensing fees paid.

    David A. Smith

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Michael Hagl@21:1/5 to All on Thu Mar 16 09:10:05 2023
    Dear David A. Smith,

    thank your for your answer.

    I think, most of ADS user work with dbf files and can not or do not want to migrate to SQL-Anywhere, because maybe in few years SAP forgets that SQL Anywhere exists and force user to migrate to SAP-HANA.

    Michael Hagl

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From dlzc@21:1/5 to Michael Hagl on Thu Mar 16 12:41:12 2023
    Dear Michael Hagl:

    On Thursday, March 16, 2023 at 9:10:07 AM UTC-7, Michael Hagl wrote:

    I think, most of ADS user work with dbf files and can not
    or do not want to migrate to SQL-Anywhere, because maybe
    in few years SAP forgets that SQL Anywhere exists and force
    user to migrate to SAP-HANA.

    Agreed, if you are going to SQL, why move to another proprietary back end? PostgreSQL

    But if they have migration tools available from ADS to SQL, would that not help some? Asking, not commanding it be so.

    David A. Smith

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Reinaldo@21:1/5 to dlzc on Fri Mar 17 07:12:48 2023
    On Thursday, March 16, 2023 at 3:41:13 PM UTC-4, dlzc wrote:
    Dear Michael Hagl:
    On Thursday, March 16, 2023 at 9:10:07 AM UTC-7, Michael Hagl wrote:

    I think, most of ADS user work with dbf files and can not
    or do not want to migrate to SQL-Anywhere, because maybe
    in few years SAP forgets that SQL Anywhere exists and force
    user to migrate to SAP-HANA.
    Agreed, if you are going to SQL, why move to another proprietary back end? PostgreSQL

    But if they have migration tools available from ADS to SQL, would that not help some? Asking, not commanding it be so.

    David A. Smith
    Hello;

    To get new licenses I think you can try Eric Ocampo: eric.ocampo@sap.com

    I'm a long time ADS user and I hate to see it go away. Moving my code SQL is not the issue as I have already moved to SQL and can't hardly remember how to use ISAM navigation anymore. The problem is everything else specific to ADS like its proprietary
    stored procedures and way to manage users and groups permissions. That part will take me a while to port.

    But if push comes to shove, I will opt for an SQL that is less likely to be abandoned, like MS-SQL. What other SQL and why would you recommend?

    Thank you,

    Reinaldo.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rick Lipkin@21:1/5 to Reinaldo on Fri Mar 17 08:10:53 2023
    On Friday, March 17, 2023 at 10:12:49 AM UTC-4, Reinaldo wrote:
    On Thursday, March 16, 2023 at 3:41:13 PM UTC-4, dlzc wrote:
    Dear Michael Hagl:
    On Thursday, March 16, 2023 at 9:10:07 AM UTC-7, Michael Hagl wrote:

    I think, most of ADS user work with dbf files and can not
    or do not want to migrate to SQL-Anywhere, because maybe
    in few years SAP forgets that SQL Anywhere exists and force
    user to migrate to SAP-HANA.
    Agreed, if you are going to SQL, why move to another proprietary back end? PostgreSQL

    But if they have migration tools available from ADS to SQL, would that not help some? Asking, not commanding it be so.

    David A. Smith
    Hello;

    To get new licenses I think you can try Eric Ocampo: eric....@sap.com

    I'm a long time ADS user and I hate to see it go away. Moving my code SQL is not the issue as I have already moved to SQL and can't hardly remember how to use ISAM navigation anymore. The problem is everything else specific to ADS like its proprietary
    stored procedures and way to manage users and groups permissions. That part will take me a while to port.

    But if push comes to shove, I will opt for an SQL that is less likely to be abandoned, like MS-SQL. What other SQL and why would you recommend?

    Thank you,

    Reinaldo.

    To All

    I like Advantage Server but Sql has been the database standard for over 10 years . FiveWin and ADO make it easy to re-code your .dbf to Sql be it MS Access or MS Sql Server .. I put together a little tutorial several years ago ... with Enrico's help

    http://fivetechsoft.com/forums/viewtopic.php?t=6691&highlight=ado

    Ado is native to Fivewin and you can look at the code \function\adofuncs.prg and does NOT need to use ODBC

    Check out \samples\AdoRick.prg for a working FiveWin and MS Access Sql demo.

    Rick Lipkin

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Rick Lipkin@21:1/5 to Reinaldo on Fri Mar 17 08:01:52 2023
    On Friday, March 17, 2023 at 10:12:49 AM UTC-4, Reinaldo wrote:
    On Thursday, March 16, 2023 at 3:41:13 PM UTC-4, dlzc wrote:
    Dear Michael Hagl:
    On Thursday, March 16, 2023 at 9:10:07 AM UTC-7, Michael Hagl wrote:

    I think, most of ADS user work with dbf files and can not
    or do not want to migrate to SQL-Anywhere, because maybe
    in few years SAP forgets that SQL Anywhere exists and force
    user to migrate to SAP-HANA.
    Agreed, if you are going to SQL, why move to another proprietary back end? PostgreSQL

    But if they have migration tools available from ADS to SQL, would that not help some? Asking, not commanding it be so.

    David A. Smith
    Hello;

    To get new licenses I think you can try Eric Ocampo: eric....@sap.com

    I'm a long time ADS user and I hate to see it go away. Moving my code SQL is not the issue as I have already moved to SQL and can't hardly remember how to use ISAM navigation anymore. The problem is everything else specific to ADS like its proprietary
    stored procedures and way to manage users and groups permissions. That part will take me a while to port.

    But if push comes to shove, I will opt for an SQL that is less likely to be abandoned, like MS-SQL. What other SQL and why would you recommend?

    Thank you,

    Reinaldo.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)