Looking for a database schema compare tool

Posted by Chris on Server Fault See other posts from Server Fault or by Chris
Published on 2009-11-30T13:30:06Z Indexed on 2010/04/23 8:03 UTC
Read the original article Hit count: 324

Filed under:

database-adminstration

|

schema

I'm looking for an application to compare two postgreSql schemas. i like how Aquafold does the job, but i wonder if there are other good solutions out there preferable free tools.

Any suggestions? thanks,

© Server Fault or respective owner

Related posts about database-adminstration

sybase bcp import fails

as seen on Server Fault - Search for 'Server Fault'
We're trying to export some tables from our production database to our test database using bcp. The bcp export seems to work fine, but the import always fails with a data type error (see below). We tested on our test database exporting the table content to a file, then importing it in again immediately… >>> More
DB2 upgrade database Fails due to descriptor corruption

as seen on Server Fault - Search for 'Server Fault'
Hi Everyone, I've recently upgraded my DB2 9.5 to DB2 9.7, and I am unable to update my database to v9.7. The error I have been receiving is this: "SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "Packed descriptor corruption… >>> More
Very large database, very small portion most being retrieved in real time

as seen on Server Fault - Search for 'Server Fault'
Hi folks, I have an interesting database problem. I have a DB that is 150GB in size. My memory buffer is 8GB. Most of my data is rarely being retrieved, or mainly being retrieved by backend processes. I would very much prefer to keep them around because some features require them. Some of it (namely… >>> More
What is "The" book for database design?

as seen on Server Fault - Search for 'Server Fault'
In programming, there is often a canonical book for a particular topic, like the dragon book for compilers, K&R for C, etc. Is their a book regarding modern database design that simply must be read by anyone that would hope to eventually design databases? I'm not looking for a bunch of recommendations… >>> More
How much effort is SQL Server 2008 Administration?

as seen on Server Fault - Search for 'Server Fault'
Hi, I am looking for a suitable hosting environment for an ASP.NET MVC application. One of the options I have is renting a Hyper-V server and installing my license of SQL Server 2008 on it. I'm a bit wary of shared hosting since the one I have tried so far did not seem to have very consistent performance… >>> More

Related posts about schema

Active Directory and Apple's Workgroup Manager

as seen on Server Fault - Search for 'Server Fault'
I thought I'd share my experiences here. I work for a small business with only ~20 users. I wanted the ability to use managed client preferences to assign things like the software update server. Basically the ability to manage my Macs easily and in a native way. At first I tried the magic triangle… >>> More
SQL SERVER – How to Compare the Schema of Two Databases with Schema Compare

as seen on SQL Authority - Search for 'SQL Authority'
Earlier I wrote about An Efficiency Tool to Compare and Synchronize SQL Server Databases and it was very much well received. Since the blog post I have received quite a many question that just like data how we can also compare schema and synchronize it. If you think about comparing the schema manually… >>> More
Copy a domain in old schema to new schema with a procedure in postgresql

as seen on Stack Overflow - Search for 'Stack Overflow'
How do we copy a domain in old schema to new schema using a procedure in postgresql? >>> More
Star Schema vs Snowflake Schema performance

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi... I'm begin to developing a scial sharing website so I'm curious about database design Schema... So in Data-Mining Star-Schema is the best one but how about a social sharing website... And as a nature of the SS websites there will be (i hope :)) many users in same time... Which better for performance… >>> More
java.lang.NoClassDefFoundError: org/springframework/transaction/interceptor/TransactionInterceptor

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to integrate spring 3.1.1 with hibernate 4.0. This is my dispatcher-servlet.xml: <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www… >>> More