ERD - Reversing Physical to Logical


#1

Hi,

I’m currently evaluating Visual Paradigm for use as a data modeller. I currently have an Oracle database which I have reverse engineered to a physical model, but I would like to reverse it back to a logical model so that I can eventually forward engineer it to Postgres. I can’t find any way to get a logical model from my current database. Is there a way of doing this?

Many thanks!


#2

Welcome to the forums!

Now, before I go on please keep in mind that my experience on database design within Visual Paradigm is limited. I’m pretty sure an official member of the VP team will also see this soon, but I figured I could always try to give you some ideas.

What kind of diagram are you working with?

I’m assuming an ERD diagram (edit: sorry, I didn’t read the title correctly) and if that’s the case then you should also be able to skip the logical view part and tell Visual Paradigm to generate the SQL directly.

But first: the best way to produce a logical view that I can think of from the top of my head is to have an entity selected and then pressing enter. This will take you into the Entity specification where the ‘Columns’ tab should show you what you want.

However… There’s a better way to reach your goal (I think so anyway): Select the ‘tools’ tab, and find the ‘DB => Generate Database’ option. This allows you to generate a database based on the diagram you’re working on.

You can even tell VP to directly set up the database within your database server (see Tools toolbar, DB => Configure database).

This is what I mean:

As you can see I don’t speak from personal experience because my license doesn’t provide this functionality, but even so I still hope this can be of some help to you.

And if something isn’t fully clear yet then please be sure to say so!

I hope you enjoy your Visual Paradigm evaluation so far.


#3

Hi,

Once you have an ERD, you can generate it to any supported databases and VP will auto perform type conversion. You can select Postgres as default in Database Configuration.

The ERD will be updated according to the default database.
erd


#4

Thank you for such a quick reply. I’d seen the ‘Generate Database’ option but couldn’t work out why it kept trying to generate to Oracle again. Not sure how I missed the ‘Configure Database’ option! Would still probably have preferred to work on a logical model not a physical one, but doing it the way you suggested will work well too.

Thanks again!


#5

Thanks :slightly_smiling_face:. That works well now