Skip to Content
0
Former Member
May 26, 2014 at 08:42 AM

Compare database

73 Views

Hi.

I'm trying to compare 2 SA12 databases in Sybase Central using "Tools - SQL Anywhere 12 - Compare databases...".

Both databases are quite small (< 100 Mb), almost no data.

DB1 is an old ASA9 which has been upgraded to SA12 using unload/reaload and "Upgrade database".

DB2 is a SA12 from the start.

It's a lot of similarities in the databases, but I think there are a few missing tables, FK's, triggers and such in DB1.

Therefore I'm trying to compare them so that I can get at sql-file to make them identical.

But it looks like the compare-function never gets finished.

I started it on friday afternoon, and it was still running this morning. So I cancelled the job.

When comparing 2 small databases like this, I think something is wrong?

Or is it supposed to take this long?

I've installed the latest EBF (4104), and started the compare once again.

Is this the best way to compare the databases?

Is there perhaps a commandline I can use?

Regards,

Bjarne Anker

Maritech Systems

Norway