database structure compare

i would say that you get a simple DDL generation script to reverse engineer  both databases.

then just compare the two text files.

look at http://www.midsomer.org/ (dbschema.pl)

alternatively ..

http://www.edbarlow.com/

Heck, just compare the contents of sysobjects in the databases.  All the info you need is there, and you can bcp or otherwise extract the contents to a text file.

i hope the question is not posted by my colleague!!
ok
sybase does have a utility called "sybase central" which  generates DDL for entire database.
It also gives a utility called "defncopy" (may not be used for table generation alone).

Hi, you cannot get everything from sysobjects. there are lot of other system tables to be extracted from. sysobjects just gives the object names and some status bits.
get the data from the following tables:
sysobjects,syscolumns,sysindexes,syscomments,systypes,syskeys, ---

my question to Amitpagarwal---
i have downloaded dbschema.pl from misnomer.org for Linux
but it has problem with DBLIB compilation (accepted by the
site). Do you have any suggesstion for NT env ?

thanks.

perfect.......

 Thanks