Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Versions supported by SQLAnywhere 10

3 posts in General Discussion Last posting was on 2007-04-30 14:15:46.0Z
Dave Brown Posted on 2007-04-30 13:54:06.0Z
From: Dave Brown
Newsgroups: ianywhere.public.general
Subject: Versions supported by SQLAnywhere 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <>
Date: 30 Apr 2007 06:54:06 -0700
X-Trace: forums-1-dub 1177941246 (30 Apr 2007 06:54:06 -0700)
X-Original-Trace: 30 Apr 2007 06:54:06 -0700,
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5959
Article PK: 1936

How many versions back can I go with SQL Anywhere 10? I
need to access a SQL Anywhere 5 database.


Breck Carter [Team iAnywhere] Posted on 2007-04-30 14:15:46.0Z
From: "Breck Carter [Team iAnywhere]" <>
Newsgroups: ianywhere.public.general
Subject: Re: Versions supported by SQLAnywhere 10
Organization: RisingRoad Professional Services
Message-ID: <>
References: <>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Date: 30 Apr 2007 07:15:46 -0700
X-Trace: forums-1-dub 1177942546 (30 Apr 2007 07:15:46 -0700)
X-Original-Trace: 30 Apr 2007 07:15:46 -0700,
Lines: 64
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5961
Article PK: 1933

Version 10 is the first version that *requires* you to recreate the
database as a V10 file.

The good news is, the V10 dbunload utility is all you need to do this,
in one step. I have pasted a sample command file below.


REM If you're a command-line kinda guy, here is my template Windows
REM batch file run_dbunload_upgrade_to_10.bat. It does the
REM unload-reload-all-in-one-dbunload-step, then starts dbeng10
REM and dbisql so you can make sure the new database is up and

REM Be sure to stop *all* database engines on the computer you're
REM before starting the upgrade.

REM Watch out for wrapped lines in the newsgroup display...

REM dbunload...
REM -an ... where to put new database
REM -c ... old database startup connection string
REM -o ... where to put unload console display text file
REM -v verbose mode for console display


"%SQLANY10%\win32\dbunload.exe" -an ddd10.db -c
"DBF=ddd5.db;UID=dba;PWD=sql" -o dbunload_log_ddd5.txt -v
PAUSE dbunload/reload done...

REM dbeng10...
REM -c ... initial RAM cache size
REM -o ... where to put server console display text file
REM -os ... when to rename and restart server console display text
REM -x none speed startup by disabling client protocols except shmem
REM ddd10.db new database to start

"%SQLANY10%\win32\dbspawn.exe" -f "%SQLANY10%\win32\dbeng10.exe" -c
100M -o dbeng10_log_ddd10.txt -os 10M -x none ddd10.db
PAUSE dbeng10 started...

REM dbisql...
REM -c ... new database connection string

"%SQLANY10%\win32\dbisql.exe" -c "ENG=ddd10;DBN=ddd10;UID=dba;PWD=sql"
PAUSE dbisql running...

On 30 Apr 2007 06:54:06 -0700, Dave Brown wrote:

>How many versions back can I go with SQL Anywhere 10? I
>need to access a SQL Anywhere 5 database.

Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
The book:

Chris Keating (Sybase iAnywhere) Posted on 2007-04-30 14:08:21.0Z
From: "Chris Keating (Sybase iAnywhere)" <>
User-Agent: Thunderbird (Windows/20070221)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Versions supported by SQLAnywhere 10
References: <>
In-Reply-To: <>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Message-ID: <4635f855$1@forums-1-dub>
Date: 30 Apr 2007 07:08:21 -0700
X-Trace: forums-1-dub 1177942101 (30 Apr 2007 07:08:21 -0700)
X-Original-Trace: 30 Apr 2007 07:08:21 -0700,
Lines: 34
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5960
Article PK: 1934

SQL Anywhere 10 requires a rebuild of the old database. That process
supports SQL Anywhere 5 databases. Please review the following
documentation on the rebuild process:

SQL Anywhere® 10 - Changes and Upgrading
Upgrading to SQL Anywhere 10
Upgrading SQL Anywhere
Rebuilding your database for version 10.0.0


Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8


Sign up today for your copy of the SQL Anywhere Studio 10 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!


iAnywhere Solutions

** Please only post to the newsgroup

** Whitepapers can be found at
** EBFs can be found at
** Use Case Express to report bugs