Обсуждение: Differences between database objects (tables, triggers, sequences, functiions) and a sql file

Поиск
Список
Период
Сортировка

Differences between database objects (tables, triggers, sequences, functiions) and a sql file

От
Ravi Malghan
Дата:
I have a master sql file used to create all the database objects for an application. Is there an application/script to compare what's in the actual database and my sql file and display the differences?

Re: Differences between database objects (tables, triggers, sequences, functiions) and a sql file

От
"David G. Johnston"
Дата:
On Sun, Oct 29, 2023, 13:59 Ravi Malghan <ravimalghan@yahoo.com> wrote:
I have a master sql file used to create all the database objects for an application. Is there an application/script to compare what's in the actual database and my sql file and display the differences?

Not that I know of.  You can find stuff that, once you've executed the script you can compare that database to some other and find differences.

David J.