Need true "alter" script style for forward databases

eddiechiang79 / power-architect

Automatically exported from code.google.com/p/power-architect

0 stars 0 forks source link

Need true "alter" script style for forward databases #13

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

So far, I can only "forward a database" by recreating it. Would be nice if 
possible to just apply the changes to existing schema.

For example, if user rename a column, when generating forward script, if the 
column already exists in the old name, then it shall provide the 

alter table XXXX rename column YYYY to PPPP

etc.

Regards,

Edson

Original issue reported on code.google.com by brvik...@gmail.com on 6 May 2014 at 11:02

GoogleCodeExporter commented 9 years ago

For this I use the Tools->Compare DM tool.  I then set the Compare Older 
section to my database and the With Newer section to Current Project.  Make 
sure your output format is set to your database.  When the comparison is done 
you can have Power Architect execute the SQL statements for you.

Original comment by pkneel...@advanced.pro on 21 Aug 2014 at 11:04