1. Andrew Davis
  2. PowerBuilder
  3. Wednesday, 15 December 2021 11:38 AM UTC

Hi,

I am just after some advice - what SQL query builder would you all recommend , that works with SQL Anywhere 16 ?

regards

Andrew

 

Adolfo Chairez Gallegos Accepted Answer Pending Moderation
  1. Friday, 17 December 2021 15:03 PM UTC
  2. PowerBuilder
  3. # 1

I use SqlAnyWhere 16, because it has many functionalities:
1.- Supports up to 32,000 concurrent connections.
2.- You can declare SOAP WebServices with JSON, RAW, XML formats. No need IIS
3.- You can create events to run external applications.
4.- You can schedule backups and maintenance to the database.
5.- You can schedule tasks.
6.- You can link database server tables such as Oracle, SqlAnywer and other servers. This means that you can make an insert in SqlAnyWhere and the data will be saved in the linked database.
7.- You can make this database server run as an application or as a service.
8.- It's fast an easy to install, my application install and setup a "server" in 3 mins with just one click
9.- Run in the Cloud (I have personally tested it with AWS)

And finally it's free.

If you want more information write me:

adolfochairez@yahoo.com

Comment
  1. Miguel Leeuwe
  2. Friday, 17 December 2021 22:17 PM UTC
Hi Adolfo,

I don't think it's free.

regards
  1. Helpful 2
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 16 December 2021 18:24 PM UTC
  2. PowerBuilder
  3. # 2

Have a look at DBeaver Community edition: https://dbeaver.io/ it's free.

Setup for sqlanywhere: https://learningintheopen.org/2019/07/24/dbeaver-sql-anywhere-database-connection-setup/

Or Flyspeed SQL, which has become pretty good over the last years and used to be free. If there's no longer a free version, it's still very cheap (like $40):

https://www.activedbsoft.com/download-querytool.html

 

Comment
  1. Andrew Davis
  2. Monday, 20 December 2021 11:31 AM UTC
The DBEaver SQL anywhere database connection is causing me problems,



The flyspeed seems very good however - thanks
  1. Helpful
  1. Miguel Leeuwe
  2. Monday, 20 December 2021 11:35 AM UTC
yes, I've also experienced sometimes that DBeaver's connections are a bit more difficult.

Great you found FlySpeed useful, yw.
  1. Helpful
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Wednesday, 15 December 2021 14:55 PM UTC
  2. PowerBuilder
  3. # 3

You can also try UltimateSuite SQL (powertothebuilder.com). It's free, and it's developef using PB...

Andreas.

Comment
  1. Andrew Davis
  2. Thursday, 16 December 2021 15:34 PM UTC
Andreas

This does seem good, although i have come across a few bugs, and the help file doesnt work, but it does seem to do the job
  1. Helpful
There are no comments made yet.
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 15 December 2021 14:34 PM UTC
  2. PowerBuilder
  3. # 4

I have not used this personally but https://razorsql.com/docs/query_builder.html

 

Comment
  1. Andrew Davis
  2. Thursday, 16 December 2021 15:34 PM UTC
I downloaded this, I am testing the evaluation version, but its quite expensive to purchase
  1. Helpful 1
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.