I recommend you focus on Table and Referential integrity in left window where you can set whether and what to create or drop.
In Option tab there are two windows: DB Schema Generation and Schema where you actually set up what is ERwin going to do.So just create two config export files – one for dropping and one for creating. Thing is when you make changes to the model you have to recreate tables in the DB and in order to do so you have to drop them first (when you use PK and FK constraint you have to drop them in special order) and create them again. This is extremely useful when you have one file for creating tables, relationships etc. Schema Generation file – any configuration you set up can be saved into XML file and used later.This dialog allows you to fully set up export. Click on Tools select Forward Engineer and then Scheme generation. If you have chosen your target db engine you are ready to export your model.
If you have not chosen target db engine do it now clicking on Database/Choose Database. ERwin’s export dialog is really sophisticated and allows you to properly set what you want to export. By export I actually mean creating all tables, relationships etc. But usually what you want to do with model is to export it to the database so it can be used by you and other developers. In last post we have designed simple model of a bank and save it either locally or to data mart.
0 kommentar(er)
