07 May 2010

Updating the Database with SQL Developer Data Modeler

This may be one of my most frequently asked questions - "How do I create the "alter" statements to update the database, using SQL Developer Data Modeler?" Most people know how to use the the Data Modeler to generate DDL scripts to create new objects, but not everyone knows how to create the DDL required to update the database. We have created a new online tutorial which walks you through this process. I did mention it recently when I wrote about the new Learning Library, and we have now also added the link to the the Data Modeler page on OTN.

5 comments:

Anonymous said...

Hi Sue!

Wonderful tip and kudos to the development team for SQL Developer. I just learned this at the OTN Database Developer day in Orange County, California and had a chance to meet your colleague Barry McGillis. Also my Oracle Migration book is now available so please pass the word on.

Regards,
Ben Prusinski, Oracle ACE and Oracle Author
My books

Migrating to Oracle, Rampant Tech Press
Exploring Oracle Internals, Rampant Tech Press
Debugging Oracle Applications, Rampant Tech Press

ben@ben-oracle.com

Sue said...

Hi Ben,

Thanks for the feedback. Glad you were able to get to the Oracle Developer Day. Congratulations on the book.

Regards
Sue

Ben Prusinski said...

Hi Sue,

Thanks. Rampant and I would like to send you a free copy of the Migration Book. If you are interested, please send me an email and I can send the book for you. I would also be interested in a review copy of your upcoming PACKT Press book on Oracle SQL Developer and would do a nice review for you as well. By the way, I also have a fourth database book coming out soon from PACKT so I just finished writing for them as well.

Regards,
Ben Prusinski
ben@ben-oracle.com

Anonymous said...

Hi,
"...we have now also added the link..."

Is it the "Re-engineering your Database using Oracle SQL Developer Data Modeler" tutorial you are referring to.

Sue said...

Yes it is. I also need to publish the web cast on this topic. That should be available next week from the webcasts page.

Sue