Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - 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
Sender: 346e.4635f43e.1804289383@sybase.com
From: Dave Brown
Newsgroups: ianywhere.public.general
Subject: Versions supported by SQLAnywhere 10
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4635f4fe.348b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Apr 2007 06:54:06 -0700
X-Trace: forums-1-dub 1177941246 10.22.241.41 (30 Apr 2007 06:54:06 -0700)
X-Original-Trace: 30 Apr 2007 06:54:06 -0700, 10.22.241.41
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.

TIA


Breck Carter [Team iAnywhere] Posted on 2007-04-30 14:15:46.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Versions supported by SQLAnywhere 10
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <4stb33hhahia44a206cthor14sp7hqlb90@4ax.com>
References: <4635f4fe.348b.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 30 Apr 2007 07:15:46 -0700
X-Trace: forums-1-dub 1177942546 64.7.134.118 (30 Apr 2007 07:15:46 -0700)
X-Original-Trace: 30 Apr 2007 07:15:46 -0700, bcarter.sentex.ca
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.

Breck

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
running.

REM Be sure to stop *all* database engines on the computer you're
using,
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

PAUSE MAKE SURE YOU DO NOT HAVE ANY ENGINES RUNNING.

"%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
file
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.
>
>TIA

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Chris Keating (Sybase iAnywhere) Posted on 2007-04-30 14:08:21.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating@iAnywhere.Dot.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Versions supported by SQLAnywhere 10
References: <4635f4fe.348b.1681692777@sybase.com>
In-Reply-To: <4635f4fe.348b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: keating-dm20.sybase.com
X-Original-NNTP-Posting-Host: keating-dm20.sybase.com
Message-ID: <4635f855$1@forums-1-dub>
Date: 30 Apr 2007 07:08:21 -0700
X-Trace: forums-1-dub 1177942101 10.25.99.119 (30 Apr 2007 07:08:21 -0700)
X-Original-Trace: 30 Apr 2007 07:08:21 -0700, keating-dm20.sybase.com
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!

http://www.ianywhere.com/downloads/software/sql_anywhere_intro.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************