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.




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

11178 posts

Uber Geek

Lifetime subscriber

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

What kind of database is it?

628 posts

Ultimate Geek
Inactive user


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

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


 
 
 
 


1590 posts

Uber Geek

Trusted
Subscriber

  #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



Twitter and LinkedIn »



Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

New online learning platform for kids stuck at home during COVID-19 lockdown
Posted 26-Mar-2020 21:35


New 5G Nokia smartphone unveiled as portfolio expands
Posted 26-Mar-2020 17:11


D-Link ANZ launches wireless AC1200 4G LTE router
Posted 26-Mar-2020 16:32


Ring introduces two new video doorbells and new pre-roll technology
Posted 17-Mar-2020 16:59


OPPO uncovers flagship Find X2 Pro smartphone
Posted 17-Mar-2020 16:54


D-Link COVR-2202 mesh Wi-Fi system now protected by McAfee
Posted 17-Mar-2020 16:00


Spark Sport opens its platform up to all New Zealanders at no charge
Posted 17-Mar-2020 10:04


Spark launches 5G Starter Fund
Posted 8-Mar-2020 19:19


TRENDnet launches high-performance WiFi Mesh Router System
Posted 5-Mar-2020 08:48


Sony boosts full-frame lens line-up with introduction of FE 20mm F1.8 G large-aperture ultra-wide-angle prime Lens
Posted 5-Mar-2020 08:44


Vector and Spark teamed up on smart metering initiative
Posted 5-Mar-2020 08:42


Schneider Electric launches new PDL Pro Series designed specifically for the commercial building market
Posted 5-Mar-2020 08:39


Kiwi app Pedigree DentaStix Studios uses pet images to counter impact of negative social media Content
Posted 5-Mar-2020 08:32


Samsung expands to New Zealand in 5G Networks Deal with Spark
Posted 5-Mar-2020 08:17


New Vodafone mobile data plans with unlimited data
Posted 26-Feb-2020 06:55



Geekzone Live »

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


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



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.

Alternatively, you can receive a daily email with Geekzone updates.