1. John Vanleeuwe
  2. PowerBuilder
  3. Thursday, 27 July 2017

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

Roland Smith Accepted Answer Pending Moderation
0
Votes
Undo

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

Comment
Hi Roland,



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



 



TIA



John

  1. John Vanleeuwe
  2. Friday, 28 July 2017
You would upgrade to a paid version of MS SQL Server.

  1. Dan Cooperstock
  2. Monday, 31 July 2017
There are no comments made yet.
  1. Thursday, 27 July 2017
  2. PowerBuilder
  3. # 1
Michael Hartnett Accepted Answer Pending Moderation
0
Votes
Undo

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
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. Chris Pollach
  2. Thursday, 27 July 2017
There are no comments made yet.
  1. Thursday, 27 July 2017
  2. PowerBuilder
  3. # 2
Armeen Mazda Accepted Answer Pending Moderation
0
Votes
Undo

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

Comment
There are no comments made yet.
  1. Thursday, 27 July 2017
  2. PowerBuilder
  3. # 3
Dan Cooperstock Accepted Answer Pending Moderation
0
Votes
Undo

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
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. John Vanleeuwe
  2. Friday, 28 July 2017
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. Dan Cooperstock
  2. Friday, 28 July 2017
There are no comments made yet.
  1. Thursday, 27 July 2017
  2. PowerBuilder
  3. # 4
  • Page :
  • 1


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