I’ve shown how to drag and drop database tables from Oracle SQL Developer into a design. But I’ve never done a start-to-finish, blow-by-blow post on how to import your existing database objects into a data model with SQL Developer.
So let’s do that now.
Warning: Lots of pictures coming up.
Start with a new design, make sure you have a Relational Model to import to.
Now go to the file menu and start the import.
You can import existing connections from Oracle SQL Developer if you have them – note that you need v4.0.3 of the modeler in order to bring over the passwords.
To create a new connection, put in your username, etc. You can test your connection before you hit ‘Ok’ if you want to save yourself some time in case you made a mistake.
Want to import from SQL Server (or DB2) instead? Check out this great post from Oracle ACE Director @kentgraziano on how to get SQL Server connectivity going in SQL Developer Data Modeler.
You can set some import options here – if you have TONS of partitions – skip them and save a bunch of time.
Use the search filter to quickly find your objects and use the Check All box to save yourself some clicks – do this for all the types of database objects you want to import
Does this look right? If so, hit the ‘Finish’ button.
Your model now has the database objects, and here’s a log reminding you what was imported and when.
Don’t forget to save your design!
Ok, it’s saved. But now maybe you want to add it to your design repository for change tracking and source control?
For Extra Credit