I have been tasked with reverse engineering our database. I am trying to figure out how to store values for our domain/look up tables. For instance we have a table for land rights. I should add I am not a database modeler or even a DBA but just a data analyst trying to figure out how to do this properly.
These are the values in this table.
LAND_RIGHT_CLASS_ID LAND_RIGHT_CLASS_DESC DISPLAY_ORDER
1 Grazing NULL
2 Cabin Site NULL
3 Mining NULL
4 Farming NULL
5 Trailer Site NULL
6 Road Use NULL
7 Rock Pit NULL
8 Stream Gauge NULL
9 Snow/Rain Gauge NULL
10 Radio Site NULL
11 Exchange NULL
12 Cost Share NULL
13 Waterline NULL
14 Christmas Trees NULL
15 Ski Trail NULL
16 Log Storage NULL
17 Picnic Site NULL
18 Building NULL
19 Recreation NULL
20 Garbage Disposal NULL
21 Air Strip NULL
22 Land NULL
23 Water Well Site NULL
24 Hydro Electric NULL
25 Port Site NULL
26 Power/Phone Lines NULL
27 TV Satellite NULL
28 Sawmill NULL
29 Campsite NULL
30 Materials NULL
31 Road Crossing NULL
32 Housing NULL
33 Pistol Range NULL
34 Oil Tanks NULL
35 Fencing NULL
36 Loading Facility NULL
37 Undercrossing NULL
38 Culverts NULL
39 Water Pipeline NULL
40 Sewer Lines NULL
41 Speeders/Pushcars NULL
42 Overhead Bridge NULL
43 R/W NULL
44 Drainage, Flood Control NULL
45 Restaurant NULL
46 Encroachment NULL
47 Weather Station NULL
48 War Games NULL
49 Community/Coop NULL
50 Water Rights NULL
51 Explosives NULL
53 Stream Management/Hydrology Coop NULL
54 Yew Bark Collection NULL
55 Property Line Agreement NULL
56 Mortgage NULL
57 Timber Deed NULL
58 Mineral Rights NULL
How do I put these into the attributes properly?
Thanks
Travis
Well you are getting close. Toad Data Modeler will help you reverse engineer the existing database into a new database but to get the data moved you will need to extract it from the source table(s) in insert it into the target. Toad Data Modeler doesn’t do anything with the data.
So, that being said, you could use Toad for (database name goes here) and export the data to spreadsheet and then use Toad for (database name goes here) to import the data into the new environment.
What database are you extracting from and what are you moving to? That would help me answer with better details.
-Mark
Thanks Mark at this point we are not currently migrating. We are trying to document the DB. I am hoping to build a living ERD model of the DB and also create a Data Dictionary. I was lead to believe this would be a good tool to do both of these tasks. I just don't know where to plug in domain values. I want to do this part right to help drive the data dictionary portion of my task.
Travis
On Oct 18, 2016, at 3:05 PM, Mark Kurtz bounce-Mark_Kurtz@toadworld.com wrote:
RE: Attribute Values
Reply by Mark Kurtz
Well you are getting close. Toad Data Modeler will help you reverse engineer the existing database into a new database but to get the data moved you will need to extract it from the source table(s) in insert it into the target. Toad Data Modeler doesn't do anything with the data.
So, that being said, you could use Toad for (database name goes here) and export the data to spreadsheet and then use Toad for (database name goes here) to import the data into the new environment.
What database are you extracting from and what are you moving to? That would help me answer with better details.
-Mark
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad Data Modeler Forum notifications altogether.
Toad Data Modeler - Discussion Forum
Flag
this post as spam/abuse.
Ah, even easier. If you go to this page on Toadworld - http://www.toadworld.com/products/toad-data-modeler - you will see some videos that show you exactly what you are trying to do. They are short, less than 5 minutes I believe, and are free. There is one on “How to create a model” and one on how to “Reverse Engineer your database”.
Then if you go to this page - http://www.toadworld.com/products/toad-data-modeler/m/media-library you will see even more videos.
If you need more help please let me know I we will get you sorted out.
-Mark