Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hello, I hope somebody in here can help me...

A while ago a link was posted on this forum. This link took you to a webpage where a comparison between different databases was made. A chart was also present. Ofcause Oracle was in top and SQL Server was close behind followed by PostgreSQL (I not 100% sure about PostgreSQL,though) but the next database was SQL Anywhere.

I tried looking for this comparision (also with the help of google) but because i do not remember more then I written I have not been successfull in finding it, please can somebody help me?

Thanks in advance


asked 11 Feb '16, 11:13

M%20G's gravatar image

accept rate: 42%

The SQL Anywhere information is incomplete; e.g., row-level locking, maximum column name size are both "?"

(11 Feb '16, 14:35) Breck Carter
Replies hidden

Very wild guess: You are not relating to TPC benchmarks, do you?

Cf. SQL Anywhere 16 Crushes Oracle, DB2 in TPC-C Price/Performance

(12 Feb '16, 02:45) Volker Barth

Thank you for your posts, but that's not it. I remember the Post was made from someone from SAP and they were happy about the result...It might even be 1-1,5 years ago...

(12 Feb '16, 07:17) M G
Replies hidden

You mean that one (though it's relating to the same issue I had mentioned...)?

(12 Feb '16, 07:57) Volker Barth

well I'm gonna get the stubborn label for this :)

Well no, it also contained a graphic Picture and SQL Anywhere was not on I'm questioning myself, perhaps it was Another database forum...and not a SAP Post....

(12 Feb '16, 08:32) M G
Replies hidden

So what was the comparison about? Features? Performance? Customer value? Market share (well, probably not...)?

As to the "...not a SAP Post...":

Here's one with DB2 at the right:

Here's a more complete reference

(12 Feb '16, 08:57) Volker Barth

Ha ha ha, very funny Volker

No it was Performance and Features. And now I'm more sure it was a SQL-Server Forum...So bye for now

(16 Feb '16, 09:50) M G

I would suggest that someone from SAP is adding the missing information...

(24 Feb '16, 12:03) Martin
showing 5 of 8 show all flat view

If you're working with small databases I've found running mysqldump on both databases with the --skip-comments and --skip-extended-insert options to generate SQL scripts, then running diff on the SQL scripts works pretty well.

By skipping comments you avoid meaningless differences such as the time you ran the mysqldump command. By using the --skip-extended-insert command you ensure each row is inserted with its own insert statement. This eliminates the situation where a single new or modified record can cause a chain reaction in all future insert statements. Running with these options produces larger dumps with no comments so this is probably not something you want to do in production use but for development it should be fine. I've put examples of the commands I use below:

mysqldump --skip-comments --skip-extended-insert -u root -p dbName1>file1.sql mysqldump --skip-comments --skip-extended-insert -u root -p dbName2>file2.sql diff file1.sql file2.sql

permanent link

answered 01 Mar '16, 00:56

xavipirlo10's gravatar image

accept rate: 0%


You have completely missed the point of the question :)

(01 Mar '16, 10:45) Breck Carter

There are six commonly recognized models (types) of database that are useful for different types of data or information. Depending upon your specific needs, one of these models should be appropriate for your migration from paper based systems to a database.

Relational database Flat-file database Hierarchical & Network database Object-oriented database Object-relational database

permanent link

answered 24 Aug '16, 05:47

nancy19's gravatar image

accept rate: 0%

edited 24 Aug '16, 08:25

Mark%20Culp's gravatar image

Mark Culp

You for your valuable contribution, thank. Very helpful in my work, it will be.

(24 Aug '16, 08:20) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 11 Feb '16, 11:13

question was seen: 2,915 times

last updated: 24 Aug '16, 08:25