On Tue, 04 May 2004 23:44:02 -0700, hazly wrote:
Quote:
I'm a part-time Sybase DBA and don't have much knowledge in admin a db
engine. Currently I have databases reside on AIX and would like to
transfer the databases to Sybase on NT. Is there any tools or ways? I
found that a backup data is not compatible to other Sybase from different
palatform. |
If you have 12.5.0.x you can use the new "sybmigrate" tool.
If not, you need to extract the DDL for the database (with ddlgen ,
dbschema.pl or some similar tool), load the DDL to the target database,
and then bcp all the data. It's not really very hard to do, but it takes a
little bit of time.
Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html