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.

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

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

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

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.

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.

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