Home > Archive > SQL Anywhere database > December 2005 > How to compare to databases ? Use of dbdelta.exe









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author How to compare to databases ? Use of dbdelta.exe
Peter Stojkovic

2005-12-22, 3:23 am

I must often compare two databases.

In earlier times i have used DBDELTA from Charles Butcher Version 1.37 (
Year 2002 ) with ASA 5.04


But now i can NOT connect to Databasa ASA 9.02
I dont know why, and there is no additional description.


Does anyone have expirience with DBDELTA and ASA90.?
Please let me know.

Has someone other expirience with other small freeware-tools ?

Thanks
Peter Stojkovic



Andrew Giulinn

2005-12-22, 8:24 pm

Peter

As I seldom find that I need to compare both schema and data, I use a
different technique for each.

I use Sybase PowerDesigner (which comes bundled in SQL Anywhere Studio as
Physical Architect as far as I know - we have a separate licence too) to
compare schemas.

And I use a small procedure that I've written to extract all the data out
into a text file from each database and then a freeware textfile diff
utility (I currently use CSDiff -
http://www.componentsoftware.com/products/freetool.htm) to compare the data.

Cheers

--
Andrew Giulinn
Senior Analyst/Programmer
Integrated Aviation Software Pty Ltd

"Peter Stojkovic" <Peter.Stojkovic@gmx.net> wrote in message
news:43aa51d2$1@foru
ms-2-dub...
>I must often compare two databases.
>
> In earlier times i have used DBDELTA from Charles Butcher Version 1.37 (
> Year 2002 ) with ASA 5.04
>
>
> But now i can NOT connect to Databasa ASA 9.02
> I dont know why, and there is no additional description.
>
>
> Does anyone have expirience with DBDELTA and ASA90.?
> Please let me know.
>
> Has someone other expirience with other small freeware-tools ?
>
> Thanks
> Peter Stojkovic
>
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com