Replication Sybase SQL Anywhere 6 NT to Sybase SQL Anywhere 8 Linux
Hi all,
I am presently thinking about migrating from Sybase SQL Anywhere 6 NT to
Sybase SQL Anywhere 8 Linux. I migrated the db file using the migrate
utility in Sybase Central and everything went fine. We are presently doing
an NT to NT replication using disk shares. I was wondering if a SQL
Anywhere 6 NT to SQL Anywhere 8 Linux replication using this same method is
possible? Any hints on where to start?
0 Alexandre5/27/2002 2:39:24 PM
Couple of points.
> Sybase SQL Anywhere 8 Linux. I migrated the db file using the migrate
> utility in Sybase Central and everything went fine. We are presently doing
I wouldn't do it this way. This is intended to migrate a non-ASA database
to ASA.
ASA is backward compatible.
I would always use this technique moving to a new release.
dbunload -c ...,old.db
dbinit new.db
dbisql -c ..., new.db read reload.sql
Viola, you have a new 8.0 database that is identical to the 6.0 version.
This can also be accomplished in less steps using
dbunload -c ....,old.db -an new.db
Unlike the migration utility, the method outlined above ALSO includes:
users
groups
passwords
triggers
procedures
database options
database creation options
As you can see, it is far superior, and it is the way WE expect you to do
it.
> an NT to NT replication using disk shares. I was wondering if a SQL
> Anywhere 6 NT to SQL Anywhere 8 Linux replication using this same method
is
> possible? Any hints on where to start?
If you are asking if you can use SQL Remote to replicate between ASA
databases (on different platforms), the answer is yes.
In fact you can have a ASA 8 (Linux) database replicating with an ASA 6 (NT)
database. Both databases do not need to be upgraded at the same time.
Using any of the standard message types will work in this configuration
(FILE, FTP, SMTP, MAPI, VIM).
--
David Fishburn
Certified SQL Anywhere Associate
Sybase - iAnywhere Solutions
Professional Services
Please only post to the newsgroup
EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm
Developer Community / Whitepapers
http://www.sybase.com/developer/mobile/
CaseXpress - to report bugs
http://casexpress.sybase.com
Sybase TechWave 2002
"Everything works better when everything works together"
http://www.sybase.com/techwave2002
"Alexandre Sagala" wrote in message
news:Exopg2YBCHA.289@forums.sybase.com...
> Hi all,
> I am presently thinking about migrating from Sybase SQL Anywhere 6 NT
to
> Sybase SQL Anywhere 8 Linux. I migrated the db file using the migrate
> utility in Sybase Central and everything went fine. We are presently doing
> an NT to NT replication using disk shares. I was wondering if a SQL
> Anywhere 6 NT to SQL Anywhere 8 Linux replication using this same method
is
> possible? Any hints on where to start?
>
>
>