November 20, 2010 at 8:40 pm
Hi guys Please advise me!
Scenario is "Client"provide a database(has 48 columns) and db has no PK AND FK relation and client don't have any ER Diagram and anything. I want to find out a relation of these tables and after that i need few tables to populate my company database. My question is what is the best and fast way to find out relationship of tables. And i don't know which one is PK. I have two option
1) GO THROUGH all tables and find out relation manually and use join to join the table and get the information/tables that i need
2) USE "REVERSE ENGINEERING" TO ERWIN DATA MODELING TOOL TO GET ER DIAGRAM.
Please advise me easy/fast way. Please don't hesitate if my question is not clear. I know there is lot of gurus can help me. Your help/reply help me a lot. Thanks in advance.
November 20, 2010 at 9:05 pm
Talk with the developers, Check the Store Procedures,Views, Function and DTS/SSIS if any,
Over the object (Table,View,Etc) Right click-View Dependencies-Objects on Which [xxxx] depends.
November 20, 2010 at 9:19 pm
Thanks for prompt reply!
The problem is they just provide Two db one is .mdf and other one is ACCESS db.
and there is no PK/FK/SP/VIEW. Any clue?
November 20, 2010 at 9:31 pm
Try to add the Access DB as linked Server and compare the table schema.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply