SQL version support visibility

acfalk's profile image acfalk posted 2 weeks ago in General Permalink

I am looking for a SQL platform that will support multiple versions of SQL (We have SQL Server, MySQL and MariaDb servers), and I am frustrated that I cannot find on your webpage what are the latest versions of each that you support. This is critical information for someone like me. I have been using Toad for over 10 years, but they are losing me because they are so far behind - They don't even support MySQL 8 which has been around for over 5 years.

Please consider either a pinned comment in your forum, or a visible page called "SQL Versions Supported".

ansgar's profile image ansgar posted 2 weeks ago Permalink

What about checking out if the one you use works?

TTSneko's profile image TTSneko posted 2 weeks ago Permalink

As Toad fully supports MySQL up to 8.2 (with 8.3 having been released in January) I'd say that is a botted post.

acfalk's profile image acfalk posted 2 weeks ago Permalink

I use Toad Data Point, which is their vaunted cross-platform SQL application. Unfortunately it is way behind. Here is a snippet from the latest release notes:

Toad Data Point 6.2 supports the following databases:

  • Oracle 10g R2, 11g, 11g R2, 12c, 12c R2, 18c
  • SQL Server 2012 and SQL Server 2012 Express
  • SQL Server 2014 Enterprise and SQL Server 2014 Express
  • SQL Server 2016
  • SQL Server 2017
  • SQL Server 2019
  • IBM DB2 for LUW 9.7, 10.1, 10.5, 10.5.0.5, 11.1, 11.5
  • IBM DB2 for z/OS 11, 12
  • IBM DB2 LUW 10.5 Fix Pack 4
  • IBM DB2 LUW 10.1 Fix Pack 4
  • IBM DB2 LUW 9.7 Fix Pack 10
  • MySQL 5.0, 5.1, 5.5, 5.6, 5.7
  • MariaDB 5.5.5, 10.2.8, 10.3.2 (using MySQL provider)
  • SAP ASE 15.5, 15.7, 16 SP03
  • SAP IQ 15, 16
  • SAP SQL Anywhere 16
  • SAP HANA SPS 08, SPS 09, SPS 10, SPS 11, SPS 12, SAP HANA 2.0, SAP HANA 2.0 SPS 02
  • SAP HANA Cloud Databases
  • Teradata 12.0, 13.0, 13.10, 14, 15, 16
  • Access® 2007, 2010, 2013, 2016
acfalk's profile image acfalk posted 2 weeks ago Permalink

What about checking out if the one you use works?

What about letting us know whether we can use it before we install it?

I am using a PC that is locked by our IT department. I can't even install Solitaire without approvals in triplicate. Before I ask them to be able to test HeidiSQL, I should at least know whether it's compatible with whatever versions we use.

ansgar's profile image ansgar posted 2 weeks ago Permalink

Please note HeidiSQL is free to use, and this kind of support is done in spare time.

If you want firm commitments regarding compatibility, you should prefer a commercial software.

TTSneko's profile image TTSneko posted 2 weeks ago Permalink

I use Toad Data Point, which is their vaunted cross-platform SQL application.

Common sense dictates that people describe their problem and include all relevant facts straight away, without forching folk (paid support or otherwise) having to play Twenty Questions with you.

Not my fault for assuming but your fault for not correctly stating your problem. What kind of company do you work for; is generic blahblah supposed to offer results there? Your question is like entering a bakery and then not providing any information on what you want whilst standing in the way of employees and other customers.

It normally is the job of IT to know - and provide - the tools required by the corresponding departments. If they are so restrictive as you imply they will definitely not allow you to install shareware simply because the certification of such would be a real pain, if not impossible. You should know that.

acfalk's profile image acfalk posted 2 weeks ago Permalink

I use Toad Data Point, which is their vaunted cross-platform SQL application.

Common sense dictates that people describe their problem and include all relevant facts straight away, without forching folk (paid support or otherwise) having to play Twenty Questions with you.

Not my fault for assuming but your fault for not correctly stating your problem. What kind of company do you work for; is generic blahblah supposed to offer results there? Your question is like entering a bakery and then not providing any information on what you want whilst standing in the way of employees and other customers.

It normally is the job of IT to know - and provide - the tools required by the corresponding departments. If they are so restrictive as you imply they will definitely not allow you to install shareware simply because the certification of such would be a real pain, if not impossible. You should know that.

Fair point, however my question was pretty specific, in regards to what versions HeidiSQL is compatible with, hoping to see a listing like I showed from Toad.

FYI, I work in Telecom, and we use a mix of MySQL, MariaDB, and SQL Server databases, which all together process and bill about 50 to 60 million new records every day, And I did all the SQL code for them except SQL Server, of which I only did some of it. I think that qualifies me as a power-user.

acfalk's profile image acfalk posted 2 weeks ago Permalink

I use Toad Data Point, which is their vaunted cross-platform SQL application.

Common sense dictates that people describe their problem and include all relevant facts straight away, without forching folk (paid support or otherwise) having to play Twenty Questions with you.

Not my fault for assuming but your fault for not correctly stating your problem. What kind of company do you work for; is generic blahblah supposed to offer results there? Your question is like entering a bakery and then not providing any information on what you want whilst standing in the way of employees and other customers.

It normally is the job of IT to know - and provide - the tools required by the corresponding departments. If they are so restrictive as you imply they will definitely not allow you to install shareware simply because the certification of such would be a real pain, if not impossible. You should know that.

Fair point, however my question was pretty specific, in regards to what versions HeidiSQL is compatible with, hoping to see a listing like I showed from Toad.

FYI, I work in Telecom, and we use a mix of MySQL, MariaDB, and SQL Server databases, which all together process and bill about 50 to 60 million new records every day, And I did all the SQL code for them except SQL Server, of which I only did some of it. I think that qualifies me as a power-user.

Our IT guys set up the basic servers, but have no clue about programming or processes. They are simply complaining that MySQL 5.7 and MariaDB 10.3 which we are currently using, are past end-of-life and want to upgrade to something that will be supported. I'm the one who has to figure out the platforms I want to use (like Toad or Heidi) and they have to install it.

Please login to leave a reply, or register at first.