Hi, I downloaded the installation files SQLA17.exe and SQLA17DEVELOPER.exe and I have noticed that both files are identical. I can use the SQLA17DEVELOPER.exe in combination with a valid licences to install a production server? I see the characteristics of the different editions and I see that the Developer edition is different from the Workgroup Edge edition. Can this imply that the license acquired turns off features of the installer? I have a Workgroup Edge edition licen.

Thanks.

asked 14 Jan, 12:16

JAValdez's gravatar image

JAValdez
456
accept rate: 0%

2

As far as I know the SQL Anywhere setup.exe files have always been the same for all the editions, with license keys and dblic.exe making individual installations work differently. If memory serves, the cloud setup was different but that's moot now. Internally, the dbsrv17.exe and dbeng17.exe executables have some differences, but you always get both of those when you run a setup.

(14 Jan, 12:58) Breck Carter

I don't know about these two files but you can certainly use a Developer Edition to install a paid version, see that older FAQ. It deals with v12 but applies to newer versions, too, AFAIK.

(14 Jan, 15:19) Volker Barth

Thank you Breck and Volker.. your comments give to me some ideas to better understand the problem that we have. Basically, we have differences when compare one report in production against the same report in test. Theoretically we have the same servers configuration, but, in production we have a license for Workgroup Edge Edition and Developer Edition for testing.

(15 Jan, 13:39) JAValdez
Replies hidden

If SELECT @@VERSION returns the same result in test and production, look elsewhere for your problem. I.e., there is some difference in the database data, or the SQL code, or the application code between test and production, or, if your application has some dependencies on the outside world (files, etc) the problem may be caused by differences there.

If SELECT @@VERSION is different, the problem may be caused by differences in the server code.

(15 Jan, 13:53) Breck Carter

@@VERSION is the same for both (17.0.6.2806) and data has a two hours difference (from backup). I think that difference is the services and the server licence. For example, in production we have 7 services on the same server holding 18 databases and in testing we have one service mounted for the same 18 databases. Another difference is the engines. While we have a Workgroup Edge Edition license in production, in testing we have the Developer edition.

(15 Jan, 17:33) JAValdez
Replies hidden

Well, even if data and code and server version are identical, results may be different, say because the database engine uses different query plans, and your query is non-deterministic (think of a missing ORDER BY), or because configuration is different.

(15 Jan, 17:34) Volker Barth

As Breck has stated, it's very unlikely that the differing results (BTW: In what respect do they differ?) are related to the editions in use when the build number is identical.

You might check the query plans of the according queries for differences, it could also be related to different cache contents, isolation levels, different concurrent users and the like...

(16 Jan, 03:12) Volker Barth
showing 4 of 7 show all flat view

This is documented as KBA #1878709.

How can an installation be migrated from a non-production license (e.g. developer edition or evaluation license) to a production license?

permanent link

answered 15 Jan, 02:13

asa's gravatar image

asa
131126
accept rate: 9%

Your answer
toggle preview

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×153
×17

question asked: 14 Jan, 12:16

question was seen: 75 times

last updated: 16 Jan, 03:12