Thanks for your post. Currently we support generate script for 2) create new table, but for
rename old table
data insert from old table to new table take into account renaming column
drop old table
they are not supported in current version (existing table/column will not be dropped, only create a new table/column in database).
But in coming release, i.e. DB-VA 5.1, we will support drop existing tables/columns. You can check “Include drop table/columns that not exist in ER model” when update the database (as attached image).
But if you rename existing table/column, we will drop the original table/column and create a new table/column in database (with the new entity name/column name on your ERD) - we will consider to alter name of table/column in database instead of drop old table/column and create new one.
I just sent you a private message with the link for release candidate (RC) build of VP Suite 4.1 (covers DB-VA 5.1), you can download the RC and try out the drop existing table/column function.
Hope these answer your question. Please do not hesitate to ask if there is any further question.
Hi!
Script is made in Oracle JDeveloper for rename the table column:
ALTER TABLE POINT_TXT
MODIFY (“Prim” CHAR(20 BYTE));
It’s better then 4 steps in Erwin or PowerDesigner!
[quote=vinger4]Script is made in Oracle JDeveloper for rename the table column:
ALTER TABLE POINT_TXT
MODIFY (“Prim” CHAR(20 BYTE));
It’s better then 4 steps in Erwin or PowerDesigner![/quote]
You mean you expect the statement generated in RC of VP Suite 4.1 should be more simple?
Thanks for replying. I’m sorry that generating alter script for renamed tables and columns will not be supported in coming VP Suite 4.2 but we will support this in VP Suite 4.3 or later. I’ll keep you informed for any further news on this issue.