Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Gruntam

22 posts

Geek


#223920 24-Oct-2017 14:11
Send private message

Hey Guys,

 

I'm on a mission, I have a database I have inherited and would like to reverse engineer it map it out to get a better understanding of how it all links...

 

I know it is a heap of work, so am looking for advice as to some app / tool that I can at least map out the datafields to (with linkages etc.)...

 

Any ideas as an app that could do this?

 

 

 

Thanks - Grunta


Create new topic

gzt

gzt
18672 posts

Uber Geek
+1 received by user: 7807

Lifetime subscriber

  #1888622 24-Oct-2017 14:20
Send private message

What kind of database is it?



stinger
628 posts

Ultimate Geek
+1 received by user: 169
Inactive user


  #1888624 24-Oct-2017 14:21
Send private message

We use http://www.dbschema.com/ at work, and quite like it.


tchart
2396 posts

Uber Geek
+1 received by user: 577

ID Verified
Trusted

  #1888640 24-Oct-2017 14:53
Send private message

Generally unless someone took the time to document or impose proper foreign key & primary key relationships those tools will generally just give you a diagram showing all the tables etc. And not how they are related.

Not sure if you can still use Visio (it used to be able to do this) but we used Sparx EA to do this kind of thing before.

Good luck.

Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.