1. John Vanleeuwe
  2. PowerBuilder
  3. Thursday, 27 July 2017 11:32 AM UTC

Hi guys,

We just found out SAP SQL Anywhere will only be sold in 5 user licenses. Our software is in 95% a 1 to 3 user software that uses SQL Anywhere 11.

Since we can't sell our software anymore for a reasonable price anymore ( due to the obligated minimum 5 user license of SAP for each installation) we are forced to look for other database options.

Ultimately we are looking for a solution that

- allows us to buy 1 user database licenses

-  can convert SQLAnywhere 11 into this new RDBMS.

 

Who's using which database software at the moment and why ?

 

 

TIA

John

Daniel Vivier Accepted Answer Pending Moderation
  1. Thursday, 27 July 2017 15:34 PM UTC
  2. PowerBuilder
  3. # 1

I suspect any conversion will have to be done with code. The easiest way is likely with PB's pipeline objects. That's how we did a conversion years ago from the free SQL Anywhere that came with PB (but didn't allow for database structure changes) to Firebird SQL, which we've been very happy with. It's quite small, free, fast, and solid. It also has an embedded version that doesn't even have to be installed, except for the ODBC driver, for single user situations.

Comment
  1. John Vanleeuwe
  2. Friday, 28 July 2017 03:52 AM UTC
Hi Dan,



Thanks for your reply.



In this post it seems like you are informing to go for Firebird SQL with all its advantages. But in another post of you today you are asking how to convert from firebird to mysql ? May i ask you what is the reason for your switch from Firebird SQL to MySQL please ?



 



Kind regards



John

  1. Helpful
  1. Daniel Vivier
  2. Friday, 28 July 2017 15:10 PM UTC
Because at some point we want to have a version that runs on Appeon Web, and Firebird isn't a supported DB under Appeon Web. I really haven't found another small and sufficiently capable DB that is supported under Appeon Web, so we may have to give up and do the complex programming needed to have our app work with 2 different DBs, rather than just a conversion to another DB that we can use both in our downloaded / installed client server version (which we would not give up, because most of our clients would prefer it) and an Appeon Web version.

  1. Helpful
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 27 July 2017 15:33 PM UTC
  2. PowerBuilder
  3. # 2

Or try an open-source DB like PostgreSQL via ODBC.

Comment
There are no comments made yet.
Michael Hartnett Accepted Answer Pending Moderation
  1. Thursday, 27 July 2017 14:13 PM UTC
  2. PowerBuilder
  3. # 3

We are making the move to SQL Server Express for our smaller clients.  As Roland said, if the DB size is smaller than 10Gb, it is perfect and no required licenses.

 

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 27 July 2017 18:35 PM UTC
Hi Michael;



SS Express is great alternative DBMS to SA that many of my previous Canadian government clients have found for not only DDL/DML compatibility but schema compatibility as well. Not that some refactoring might still be necessary, but they found it the easiest to transition to in general.

Of course, there are many other factors that each App Development team should consider in making this decision.



Regards ... Chris
  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 27 July 2017 13:17 PM UTC
  2. PowerBuilder
  3. # 4

If you can guarantee your database won't go over 10GB, Microsoft SQL Server Express is completely free.

Comment
  1. John Vanleeuwe
  2. Friday, 28 July 2017 03:50 AM UTC
Hi Roland,



What is the alternative ? Can we - in case of a db > 10GB - upgrade to another licensed solution or ... ?



 



TIA



John

  1. Helpful
  1. Daniel Vivier
  2. Monday, 31 July 2017 15:45 PM UTC
You would upgrade to a paid version of MS SQL Server.

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.