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.

Migration

8 posts in General Discussion Last posting was on 2004-07-26 15:25:04.0Z
Joe Posted on 2004-07-23 13:32:04.0Z
Sender: 6013.41011199.1804289383@sybase.com
From: Joe
Newsgroups: ianywhere.public.general
Subject: Migration
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41011354.6040.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Jul 2004 06:32:04 -0700
X-Trace: forums-1-dub 1090589524 10.22.241.41 (23 Jul 2004 06:32:04 -0700)
X-Original-Trace: 23 Jul 2004 06:32:04 -0700, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3300
Article PK: 7209

Hi,

I'm migrating some database apps from PB6.5 (SQLAnywhere
5.5) to PB9 (ASAnywhere 8).

The solution I've found to migrate de databases is
compress(5.5), descompress(8) and change log file.

There's another easiest way?

Thanks,
Joe


Greg Fenton Posted on 2004-07-23 14:52:05.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20040707)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Migration
References: <41011354.6040.1681692777@sybase.com>
In-Reply-To: <41011354.6040.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <41012615$1@forums-1-dub>
Date: 23 Jul 2004 07:52:05 -0700
X-Trace: forums-1-dub 1090594325 10.25.100.188 (23 Jul 2004 07:52:05 -0700)
X-Original-Trace: 23 Jul 2004 07:52:05 -0700, gfenton-xp.sybase.com
Lines: 42
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3301
Article PK: 7211


Joe wrote:
>
> The solution I've found to migrate de databases is
> compress(5.5), descompress(8) and change log file.
>
> There's another easiest way?
>

Yes, in fact I wonder what you think the compress/decompress is doing,
because it isn't "migrating" the database...

What you are trying to do is "upgrade" the database. There are two
basic approaches.

One is to update the system tables using the upgrade tools ("Upgrade
Database" in Sybase Central or "dbugrad" from the command line).

The other, and *strongly recommended* approach is to unload the data
from the old db and load it into a new db. This can be done using the
"Unload Database" wizard in Sybase Central or using the "dbunload"
command-line utility.

All of this is very well documented in the ASA 8.x online docs:

What's New in SQL Anywhere Studio
12. Upgrading Software and Databases
- Upgrading Adaptive Server Anywhere


Again, it is *strongly recommended* that you upgrade the databsae file
format, not just the database itself (see "Upgrading the database file
format" link on the above page).

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Joe Posted on 2004-07-23 16:18:00.0Z
Sender: 21c5.4101265e.1804289383@sybase.com
From: Joe
Newsgroups: ianywhere.public.general
Subject: Re: Migration
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41013b32.22c7.1681692777@sybase.com>
References: <41012615$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 23 Jul 2004 09:22:10 -0700, 10.22.241.42
Lines: 63
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Jul 2004 09:11:10 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Jul 2004 09:18:00 -0700
X-Trace: forums-1-dub 1090599480 10.22.108.75 (23 Jul 2004 09:18:00 -0700)
X-Original-Trace: 23 Jul 2004 09:18:00 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3304
Article PK: 7214

I have in one computer the server of SQL-Anywhere5.5 and
some database files 5.5.
And, in another computer, the server of ASA8. What I want is
to take the files of 5.5 and put them as ASA8 database files
to make it the new, and only, database server.

The upgrade option is funny, I have tryed to connect from
ASA8 to the 5.5 files and it says that I cannot connect
because the file is from a previous version.

Compress/uncompress it's the way that I use to optimize and
let the files as historic (once a year). Then I uncompress
to a new file with all the data.

> Joe wrote:
> >
> > The solution I've found to migrate de databases is
> > compress(5.5), descompress(8) and change log file.
> >
> > There's another easiest way?
> >
>
> Yes, in fact I wonder what you think the
> compress/decompress is doing, because it isn't
> "migrating" the database...
>
> What you are trying to do is "upgrade" the database.
> There are two basic approaches.
>
> One is to update the system tables using the upgrade tools
> ("Upgrade Database" in Sybase Central or "dbugrad" from
> the command line).
>
> The other, and *strongly recommended* approach is to
> unload the data from the old db and load it into a new
> db. This can be done using the "Unload Database" wizard
> in Sybase Central or using the "dbunload" command-line
> utility.
>
> All of this is very well documented in the ASA 8.x online
> docs:
>
> What's New in SQL Anywhere Studio
> 12. Upgrading Software and Databases
> - Upgrading Adaptive Server Anywhere
>
>
> Again, it is *strongly recommended* that you upgrade the
> databsae file format, not just the database itself (see
> "Upgrading the database file format" link on the above
> page).
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/


Joe Posted on 2004-07-23 16:19:04.0Z
Sender: 21c5.4101265e.1804289383@sybase.com
From: Joe
Newsgroups: ianywhere.public.general
Subject: Re: Migration
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41013b72.22d1.1681692777@sybase.com>
References: <41012615$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 23 Jul 2004 09:23:14 -0700, 10.22.241.42
Lines: 62
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Jul 2004 09:12:14 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Jul 2004 09:19:04 -0700
X-Trace: forums-1-dub 1090599544 10.22.108.75 (23 Jul 2004 09:19:04 -0700)
X-Original-Trace: 23 Jul 2004 09:19:04 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3305
Article PK: 7215

I have in one computer the server of SQL-Anywhere5.5 and
some database files 5.5.
And, in another computer, the server of ASA8. What I want is
to take the files of 5.5 and put them as ASA8 database files
to make it the new, and only, database server.

The upgrade option is funny, I have tryed to connect from
ASA8 to the 5.5 files and it says that I cannot connect
because the file is from a previous version.

Compress/uncompress it's the way that I use to optimize and
let the files as historic (once a year). Then I uncompress
to a new file with all the data.

> Joe wrote:
> >
> > The solution I've found to migrate de databases is
> > compress(5.5), descompress(8) and change log file.
> >
> > There's another easiest way?
> >
>
> Yes, in fact I wonder what you think the
> compress/decompress is doing, because it isn't
> "migrating" the database...
>
> What you are trying to do is "upgrade" the database.
> There are two basic approaches.
>
> One is to update the system tables using the upgrade tools
> ("Upgrade Database" in Sybase Central or "dbugrad" from
> the command line).
>
> The other, and *strongly recommended* approach is to
> unload the data from the old db and load it into a new
> db. This can be done using the "Unload Database" wizard
> in Sybase Central or using the "dbunload" command-line
> utility.
>
> All of this is very well documented in the ASA 8.x online
> docs:
>
> What's New in SQL Anywhere Studio
> 12. Upgrading Software and Databases
> - Upgrading Adaptive Server Anywhere
>
>
> Again, it is *strongly recommended* that you upgrade the
> databsae file format, not just the database itself (see
> "Upgrading the database file format" link on the above
> page).
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/


Joe Posted on 2004-07-23 16:19:47.0Z
Sender: 22d6.41013b8f.1804289383@sybase.com
From: Joe
Newsgroups: ianywhere.public.general
Subject: Re: Migration
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41013b9b.22d7.1681692777@sybase.com>
References: <41012615$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 23 Jul 2004 09:23:55 -0700, 10.22.241.42
Lines: 62
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Jul 2004 09:12:55 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Jul 2004 09:19:47 -0700
X-Trace: forums-1-dub 1090599587 10.22.108.75 (23 Jul 2004 09:19:47 -0700)
X-Original-Trace: 23 Jul 2004 09:19:47 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3306
Article PK: 7216

I have in one computer the server of SQL-Anywhere5.5 and
some database files 5.5.
And, in another computer, the server of ASA8. What I want is
to take the files of 5.5 and put them as ASA8 database files
to make it the new, and only, database server.

The upgrade option is funny, I have tryed to connect from
ASA8 to the 5.5 files and it says that I cannot connect
because the file is from a previous version.

Compress/uncompress it's the way that I use to optimize and
let the files as historic (once a year). Then I uncompress
to a new file with all the data.

> Joe wrote:
> >
> > The solution I've found to migrate de databases is
> > compress(5.5), descompress(8) and change log file.
> >
> > There's another easiest way?
> >
>
> Yes, in fact I wonder what you think the
> compress/decompress is doing, because it isn't
> "migrating" the database...
>
> What you are trying to do is "upgrade" the database.
> There are two basic approaches.
>
> One is to update the system tables using the upgrade tools
> ("Upgrade Database" in Sybase Central or "dbugrad" from
> the command line).
>
> The other, and *strongly recommended* approach is to
> unload the data from the old db and load it into a new
> db. This can be done using the "Unload Database" wizard
> in Sybase Central or using the "dbunload" command-line
> utility.
>
> All of this is very well documented in the ASA 8.x online
> docs:
>
> What's New in SQL Anywhere Studio
> 12. Upgrading Software and Databases
> - Upgrading Adaptive Server Anywhere
>
>
> Again, it is *strongly recommended* that you upgrade the
> databsae file format, not just the database itself (see
> "Upgrading the database file format" link on the above
> page).
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/


Greg Fenton Posted on 2004-07-23 16:23:34.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20040707)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Migration
References: <41012615$1@forums-1-dub> <41013b9b.22d7.1681692777@sybase.com>
In-Reply-To: <41013b9b.22d7.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: gfenton-xp.sybase.com
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <41013b86@forums-1-dub>
Date: 23 Jul 2004 09:23:34 -0700
X-Trace: forums-1-dub 1090599814 10.25.100.188 (23 Jul 2004 09:23:34 -0700)
X-Original-Trace: 23 Jul 2004 09:23:34 -0700, gfenton-xp.sybase.com
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3307
Article PK: 7219


Joe wrote:
>
> The upgrade option is funny, I have tryed to connect from
> ASA8 to the 5.5 files and it says that I cannot connect
> because the file is from a previous version.
>

Can you post the following information:

- what version and build of ASA 8.x (use the command "dbeng8 -v")
- what is the command you are using to "connect" ASA 8 to the 5.5 files?
- what is the exact error message you are getting when you try to
"connect"? Where is this message displayed?
- are you transfering the files from the old machine to the new one? If
so, how?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Joe Posted on 2004-07-26 09:35:04.0Z
Sender: 1a45.4104d019.1804289383@sybase.com
From: Joe
Newsgroups: ianywhere.public.general
Subject: Re: Migration
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4104d048.1a49.1681692777@sybase.com>
References: <41013b86@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Jul 2004 02:35:04 -0700
X-Trace: forums-1-dub 1090834504 10.22.241.41 (26 Jul 2004 02:35:04 -0700)
X-Original-Trace: 26 Jul 2004 02:35:04 -0700, 10.22.241.41
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3312
Article PK: 7222

Can you post the following information:

- what version and build of ASA 8.x (use the command
"dbeng8 -v") - what is the command you are using to
"connect" ASA 8 to the 5.5 files?
8.0.1(2600)

- what is the exact error message you are getting when you
try to "connect"? Where is this message displayed?
I was trying to connect to the file because I could not
create an ODBC DSN because I have not the SQLAnywhere 5.5
option and it said it could not find the .ini file. But I
create one DSN with ASA8 and connect trough it, the first
thing it says is to unload, so OK.

- are you transfering the files from the old machine to the
new one? If so, how?
Copy the files .log, .mlg and .db.

Anyway, I think it will work like this: create a DSN with
ASA8 and connect to the file with Sybase Central; it say
then to unload.

Thanks,
Joe.
(Sorry because of the repeated but I didn't saw the
answers).

> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer//


Greg Fenton Posted on 2004-07-26 15:25:04.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20040707)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Migration
References: <41013b86@forums-1-dub> <4104d048.1a49.1681692777@sybase.com>
In-Reply-To: <4104d048.1a49.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <41052352$1@forums-2-dub>
X-Original-Trace: 26 Jul 2004 08:29:22 -0700, gfenton-xp.sybase.com
Lines: 22
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Jul 2004 08:17:54 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Jul 2004 08:25:04 -0700
X-Trace: forums-1-dub 1090855504 10.22.108.75 (26 Jul 2004 08:25:04 -0700)
X-Original-Trace: 26 Jul 2004 08:25:04 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3316
Article PK: 7225


Joe wrote:
>
> Anyway, I think it will work like this: create a DSN with
> ASA8 and connect to the file with Sybase Central; it say
> then to unload.
>

Yes, this is the right approach. The DSN you create is not for the .db
file, but for the database engine you open the .db file with. Since you
are opening it with ASA 8.x , you want an ASA 8 DSN.

Sybase Central for v. 8 cannot directly manage an ASA 5.x database file,
so when you connect it will ask you to upgrade.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/