Skip to Content
0
Jul 06, 2016 at 09:49 AM

Generation undo-scripts, when generation db-sctipts

24 Views

Hi,

did someone managed, to generate an DB-undo-script at the time where the database scripts are generated?

I'm talking about an database revert script generated during the time when calling "Apply Model Changes to Database".

So let's say when calling "Apply Model Changes to Database", we've got the following scripts:

1) database create/alter script:

create table TABLE_4

( COLUMN_1 CHAR,

COLUMN_2 CHAR,

COLUMN_3 CHAR );

alter table TABLE_1

add COLUMN_5 CHAR;

2) Now, what I want to generate as well is an database revert script, looking like this:

drop table TABLE_4;

alter table TABLE_1

drop column COLUMN_5;

BR,

Rafal