dbTalk Databases Forums  

export database to different OS

comp.databases.sybase comp.databases.sybase


Discuss export database to different OS in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hazly
 
Posts: n/a

Default export database to different OS - 05-05-2004 , 01:44 AM






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.

Reply With Quote
  #2  
Old   
Michael Peppler
 
Posts: n/a

Default Re: export database to different OS - 05-05-2004 , 01:49 AM






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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.