Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread Schema comparison tools: Suggestions?
Thu, Feb 23 2006 2:53 PMPermanent Link

Sam Jones
Hello all!

I have an old DBISAM 4 db (from over a year ago), and a new one. The schemas are similar,
but not the same.

Is there a schema comparison tool I can use to spot the differences?

(I thought of going table by table and exporting all the DDL, but there are a lot of tables)

Thanks!!
Thu, Feb 23 2006 3:07 PMPermanent Link

Jeff Cook
Sam Jones <sjones9@gmail.com> wrote on Thu, 23 Feb 2006 14:53:46 -0500

>Hello all!
>
>I have an old DBISAM 4 db (from over a year ago), and a new one. The schemas are similar,
>but not the same.
>

Sam

Why not just use DBSYS Reverse Engineer to get the schemas in text files and then use something like "Beyond Compare"  (free 30 day trial version) to spot the differences.

Jeff Cook



--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz



Thu, Feb 23 2006 3:19 PMPermanent Link

Sam Jones
Beyond Compare I have been a licensed user of for years (it is hot!)

Does DBSYS work against a whole dir of tables, or one table at a time?

(I need to do the whole stack in one go)
Thu, Feb 23 2006 4:14 PMPermanent Link

Steve Forbes

Team Elevate Team Elevate

Hi Sam,

You can choose a whole dir, or any combination of tables to reverse engineer
in DBSYS.

--
Best regards

Steve

"Sam Jones" <sjones9@gmail.com> wrote in message
news:D4AEACE2-2A63-458D-ACC0-E417A3AB9A5E@news.elevatesoft.com...
> Beyond Compare I have been a licensed user of for years (it is hot!)
>
> Does DBSYS work against a whole dir of tables, or one table at a time?
>
> (I need to do the whole stack in one go)
>

Thu, Feb 23 2006 5:06 PMPermanent Link

Sam Jones
Thanks!

Will check it out.
Thu, Feb 23 2006 5:14 PMPermanent Link

Michael Baytalsky
Hi Sam,

You can try our Context Database Designer.
http://www.contextsoft.com/products/dbdesign

You can reverse engineer two databases into two schemas and
then use Compare Schemas to compare them. You might find
the tool useful for other things too Wink Trial version will
allow you to compare and is fully functional otherwise, except
it shows watermark on designer window.

Regards,
Michael


Sam Jones wrote:
> Hello all!
>
> I have an old DBISAM 4 db (from over a year ago), and a new one. The schemas are similar,
> but not the same.
>
> Is there a schema comparison tool I can use to spot the differences?
>
> (I thought of going table by table and exporting all the DDL, but there are a lot of tables)
>
> Thanks!!
>
Thu, Feb 23 2006 10:25 PMPermanent Link

Steve Gill

>You can try our Context Database Designer.
>http://www.contextsoft.com/products/dbdesign
>
>You can reverse engineer two databases into two schemas and
>then use Compare Schemas to compare them. You might find
>the tool useful for other things too Wink Trial version will
>allow you to compare and is fully functional otherwise, except
>it shows watermark on designer window.

I haven't used Context Database Designer for comparing schemas but I
just wanted to say it is a great product!

Regards,

SteveG
Fri, Feb 24 2006 10:40 AMPermanent Link

"David Farrell-Garcia"
Steve Gill wrote:
> I haven't used Context Database Designer for comparing schemas but I
> just wanted to say it is a great product!
>

I am using v2 beta and it is a great product and if you used it to
create your original schema then keeping your database structure
updated is automatic with a line or two of code.
Mon, Aug 14 2006 8:51 AMPermanent Link

Damien Collings
Sam Jones <sjones9@gmail.com> wrote:

Hello all!

I have an old DBISAM 4 db (from over a year ago), and a new one. The schemas are similar,
but not the same.

Is there a schema comparison tool I can use to spot the differences?

(I thought of going table by table and exporting all the DDL, but there are a lot of tables)

Thanks!!

>> You can try my component. You choose a source folder and ONE OR MORE TARGET FOLDERS
that you wish to compare your source against. The system then looks for the target folders
and performs an sql based table restructure,compare  and/or merge.  It exists as a
component which you can drop into any delphi app and call a compare/restructure each time
your application starts. It has full event driven restructuring options allowing you to
display progress, obtain/modify the sql's it generated and abort. Options also exist for
backing existing files before compare/restructure. I highly recommend you look at it, it
has been used in three commercial products very successfully for this type of use. It is
also widely used for mass source target operations for inhouse datastores when multiple
datasets need to be upgraded with the touch of a button. It can also completely reorganise
your field ordering based on source, target , alphabetic or index optimised/alphabetic.

You will need to contact me at support@bwsoftwaretools.com should you require the source.

Home: www.bwsoftwaretools.com
Download: http://www.bwsoftwaretools.com/f/setup.exe

Kind Regards,

Damien Collings.
BW Software Tools.
Image