• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 737
  • Last Modified:

database structure compare

hi guys,

 is there any way I can compare two database.

 I have two databases and they were supposed to be identical, but i find that one of them is having tables not present in the other, same case with triggers etc.

 does sybase have any utility that helps me compare the structure of the two  databases?
0
earlrainer
Asked:
earlrainer
1 Solution
 
amitpagarwalCommented:
i would say that you get a simple DDL generation script to reverse engineer  both databases.

then just compare the two text files.

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

alternatively ..

http://www.edbarlow.com/
0
 
gletiecqCommented:
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.

0
[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 
pradeepkumartCommented:
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.


0
 
rajeshfar_guptaCommented:
Theres a program called DBDelta that can compare two Sybase databases ...... i dont remember thel ink but you can search for it, its free and works well as i have tried it.
0
 
earlrainerAuthor Commented:
perfect.......

 Thanks
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now