Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (4)

Resolved SQL query builder software - SQL Anywhere 16

  1. Advice
0
Votes
Undo
  1. Andrew Davis
    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

 

  1. SQL
Connecting to Git with proxy server not working
DataWindow edit issue, PB padding string fields ca...
Responses (4)
Adolfo Chairez Gallegos
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
Miguel Leeuwe
  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
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
Andrew Davis
  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
Miguel Leeuwe
  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
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
Andrew Davis
  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)
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
Andrew Davis
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.