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.

Move database to a site running a different version of ianywhere

3 posts in General Discussion Last posting was on 2006-08-10 04:43:52.0Z
Jack Hirschi, Computer One Posted on 2006-08-09 19:17:58.0Z
Sender: 52b7.44da31f7.1804289383@sybase.com
From: Jack Hirschi, Computer One
Newsgroups: ianywhere.public.general
Subject: Move database to a site running a different version of ianywhere
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44da32c0.52c2.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 9 Aug 2006 12:08:48 -0700, 10.22.241.42
Lines: 4
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Aug 2006 12:08:50 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Aug 2006 12:17:58 -0700
X-Trace: forums-1-dub 1155151078 10.22.108.75 (9 Aug 2006 12:17:58 -0700)
X-Original-Trace: 9 Aug 2006 12:17:58 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5547
Article PK: 1586

I need to move a database from a site running Adaptive
Server Anywhere 6.03.2747 to a site running Adaptive Server
Anywhere 7. Any help with the steps to do this is
appreciated.


Breck Carter [Team iAnywhere] Posted on 2006-08-10 00:46:11.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Move database to a site running a different version of ianywhere
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <ohvkd25valbdt8pk1b2f7sh66kh8qfs2ul@4ax.com>
References: <44da32c0.52c2.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
X-Original-NNTP-Posting-Host: wsip-24-120-131-198.lv.lv.cox.net
X-Original-Trace: 9 Aug 2006 17:36:58 -0700, wsip-24-120-131-198.lv.lv.cox.net
Lines: 37
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 9 Aug 2006 17:37:01 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 9 Aug 2006 17:46:11 -0700
X-Trace: forums-1-dub 1155170771 10.22.108.75 (9 Aug 2006 17:46:11 -0700)
X-Original-Trace: 9 Aug 2006 17:46:11 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5549
Article PK: 1585


On 9 Aug 2006 12:17:58 -0700, Jack Hirschi, Computer One wrote:

>I need to move a database from a site running Adaptive
>Server Anywhere 6.03.2747 to a site running Adaptive Server
>Anywhere 7. Any help with the steps to do this is
>appreciated.

The simplest approach is to just copy the database file and use
dbsrv7.exe to start it; Version 7 can run Version 6 databases without
any upgrade process.

(there, wasn't that easy? :)

If you want to take advantage of any internal file format changes in
version 7, you can then use the Version 7 dbunload.exe to unload the
database, stop the old database, run Version 7 dbinit.exe to create a
new .DB file (use -p 4096 to get an efficient 4K page size, start the
new database with dbsrv7.exe, and then run dbisql.exe to reload the
database using the reload.sql and *.dat files created by dbunload.

There is also a Version 7 dbupgrad.exe program which upgrades the
system tables and enables some new features; it is an easy alternative
to the unload/reload but not as good.

Read more about these *.exe programs in the Version 7 Help.

Now... what you should REALLY be doing is upgrading to 9.0.2... MUCH
better performance, MANY more features.

Breck

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


Jack Hirschi Posted on 2006-08-10 04:43:52.0Z
Sender: 5e22.44dab853.1804289383@sybase.com
From: Jack Hirschi
Newsgroups: ianywhere.public.general
Subject: Re: Move database to a site running a different version of ianywhere
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44dab988.5e3c.1681692777@sybase.com>
References: <ohvkd25valbdt8pk1b2f7sh66kh8qfs2ul@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Aug 2006 21:43:52 -0700
X-Trace: forums-1-dub 1155185032 10.22.241.41 (9 Aug 2006 21:43:52 -0700)
X-Original-Trace: 9 Aug 2006 21:43:52 -0700, 10.22.241.41
Lines: 46
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5550
Article PK: 1587


> On 9 Aug 2006 12:17:58 -0700, Jack Hirschi, Computer One
> wrote:
>
> >I need to move a database from a site running Adaptive
> >Server Anywhere 6.03.2747 to a site running Adaptive
> Server >Anywhere 7. Any help with the steps to do this is
> >appreciated.
>
> The simplest approach is to just copy the database file
> and use dbsrv7.exe to start it; Version 7 can run Version
> 6 databases without any upgrade process.
>
> (there, wasn't that easy? :)
>
> If you want to take advantage of any internal file format
> changes in version 7, you can then use the Version 7
> dbunload.exe to unload the database, stop the old database
> , run Version 7 dbinit.exe to create a new .DB file (use
> -p 4096 to get an efficient 4K page size, start the new
> database with dbsrv7.exe, and then run dbisql.exe to
> reload the database using the reload.sql and *.dat files
> created by dbunload.
>
> There is also a Version 7 dbupgrad.exe program which
> upgrades the system tables and enables some new features;
> it is an easy alternative to the unload/reload but not as
> good.
>
> Read more about these *.exe programs in the Version 7
> Help.
>
> Now... what you should REALLY be doing is upgrading to
> 9.0.2... MUCH better performance, MANY more features.
>
> Breck
>
> --
> 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

Thank You!!