I need to open a .db file from Sybase. Reading its headers I found this:

9.0.2.3702 Sybase Inc.

What's the minimum software I need to open the file? Where can I find it?

I'm newbie and feel lost with so many tools...

Regards

asked 28 Aug '13, 03:13

marcis's gravatar image

marcis
16223
accept rate: 0%

edited 28 Aug '13, 08:19

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297


Hi Marcis,

I assume you don't already have a copy of Adaptive Server Anywhere (SQL Anywhere) 9 on your machine?

If not, you should download SQL Anywhere 16 Developer Edition. Version 9 database files cannot be started directly on version 16, you will need to rebuild the database. Note you will need a username/password for the database, the default is dba/sql. Once the database is rebuilt, you should be able to access the data contained in it using Sybase Central and Interactive SQL. (Click 'Connect' in Sybase Central and choose 'Start and connect to a database on this computer').

Please note that the Developer Edition for development purposes only and should not be used in production.

Hope this helps.

permanent link

answered 28 Aug '13, 08:05

Mikel%20Rychliski's gravatar image

Mikel Rychliski
2.1k1641
accept rate: 32%

Is there any free version of ASA 16 to download and to be used in production (any or other version)?

thanks

(28 Aug '13, 10:29) Walmir Taques
Replies hidden

No, production versions must be licensed - the developer edition cannot be used in production. In SQL Anywhere 11 or 12, if you are using an exclusive web application, there is the SQL Anywhere Web Edition available, that was free to use.

(28 Aug '13, 10:42) Jeff Albion

@Jeff: So v16 doesn't come with a Web Edition? If so, why (in case there is a published answer...)?

(28 Aug '13, 15:05) Volker Barth

FWIW, the doc page http://www.sybase.com/detail?id=1068247 does not say that the free Web Edition is no more available with v16...

(29 Aug '13, 05:18) Volker Barth

SQL Anywhere 9.x can open all versions back to (at least 5.5) With SQL Anywhere 10 a new file format was used, so with SQLA versions 10-16 you can open all DB files back (including) V10

When you wish to open a older format with v10 and up, you can convert them into the new format. (Basically a automatic unload/reload in the new format)

permanent link

answered 28 Aug '13, 10:47

ASchild's gravatar image

ASchild
777222740
accept rate: 14%

beware if use v10 and up esp v11 rel 2960, and you have outer join in your app or store proc, you may find failures and need to convert them manually. worse offenders are sql with reference to subquery

(28 Aug '13, 12:26) gg99
Replies hidden

@@gg99: I don't think the problem you're unfortunately facing (see this FAQ) is a typical one for migrating SA databases - it's apparently due to the long deprecated T-SQL outer joins. Note: T-SQL outer joins have already been deprecated with SA v10...

(28 Aug '13, 15:04) Volker Barth
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:

×128
×47
×13

question asked: 28 Aug '13, 03:13

question was seen: 10,282 times

last updated: 29 Aug '13, 05:18