ALTER scripts for existent tables

General Questions/Discussions
1

Hey guys,

While playing with DB-VA I couldn’t find an option in which I can generate ALTER scripts from an existent table that was loaded from an existent/reversed database. Say that you generate an E-R diagram out of your current database and you put it under version control, later on, you add a column or constraint so that means that you CAN’T drop the table and create it again, instead, you only want to generate an alter script with that specific change.

Is that possible? that’s also one of the greatest features that I was expecting when I got DB-VA.

Thanks in advance

2

Hi user,

Thanks for your post. You can update the database by selecting “Update Database” in Database Code Generation dialog box (see image).

Best regards,
Lilian Wong

update_db.png