drop connections and drop database script for PostgreSQL

REVOKE CONNECT ON DATABASE #{dbname} FROM public;

ALTER DATABASE #{dbname} CONNECTION LIMIT 0;

SELECT pg_terminate_backend(pid)

FROM pg_stat_activity

WHERE pid <> pg_backend_pid()

AND datname='#{dbname}';

DROP DATABASE #{dbname};

stackoverflow.com

Читать весь тред на Juick

rss2lj

DBComparer is a professional database comparison tool for analyzing the differences in Microsoft SQL Server 2008 (and 2005) database structures.

dbcomparer.com

Может быть полезно. Нужно будет потестить.

Читать весь тред на Juick

rss2lj