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.




14 posts

Geek


Topic # 223920 24-Oct-2017 14:11
Send private message quote this post

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

9150 posts

Uber Geek
+1 received by user: 1290


  Reply # 1888622 24-Oct-2017 14:20
Send private message quote this post

What kind of database is it?

118 posts

Master Geek
+1 received by user: 24


  Reply # 1888624 24-Oct-2017 14:21
Send private message quote this post

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


 
 
 
 


1394 posts

Uber Geek
+1 received by user: 159


  Reply # 1888640 24-Oct-2017 14:53
Send private message quote this post

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 »

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 »

UFB killer app: Speed
Posted 17-Nov-2017 17:01


The case for RSS — MacSparky
Posted 13-Nov-2017 14:35


WordPress and Indieweb: Take control of your online presence — 6:30 GridAKL Nov 30
Posted 11-Nov-2017 13:43


Chorus reveals technology upgrade for schools, students
Posted 10-Nov-2017 10:28


Vodafone says Internet of Things (IoT) crucial for digital transformation
Posted 10-Nov-2017 10:06


Police and Facebook launch AMBER Alerts system in NZ
Posted 9-Nov-2017 10:49


Amazon debuts Fire TV Stick Basic Edition in over 100 new countries
Posted 8-Nov-2017 05:34


Vodafone VoIP transition to start this month
Posted 7-Nov-2017 12:33


Spark enhances IoT network capability
Posted 7-Nov-2017 11:33


Vocus NZ sale and broadband competition
Posted 6-Nov-2017 14:36


Hawaiki reaches key milestone in landmark deep-sea fibre project
Posted 4-Nov-2017 13:53


Countdown launches new proximity online shopping app
Posted 4-Nov-2017 13:50


Nokia 3310 to be available through Spark New Zealand
Posted 4-Nov-2017 13:31


Nest launches in New Zealand
Posted 4-Nov-2017 12:31


Active wholesale as Chorus tackles wireless challenge
Posted 3-Nov-2017 10:55



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.

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