| Author |
Topic |
|
WJHamel
Aged Yak Warrior
651 Posts |
 Posted - 2012-02-10 : 11:33:59
|
| Again, working on a data conversion.Source data is a sql2k8 db, being converted to a new sql2k8 db.my ? is this:Is there a function in mgmt studio which provides a visual map of a db that shows the relationship between the different fields in each table (primary keys:foreign keys, constraints, etc) which will help me map how things will move from point A(their db) to point b(our db).thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 11:37:02
|
| You can start using databse diagrams for getting table relationships------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2012-02-10 : 11:43:52
|
| i'm looking at that feature currently, but it doesn't really appear to show me anything more than the columns in each table. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 11:55:22
|
| are you sure you've fk relationships setup?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
WJHamel
Aged Yak Warrior
651 Posts |
Posted - 2012-02-10 : 11:56:36
|
| Their db was restored locally on my machine as any other would be. Would that not also restore the fk relationships? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-10 : 12:01:00
|
| ideally yes. If was setup properly in the original db------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-02-10 : 12:37:12
|
| Thats the reason why it is SO SO SO important to have your logical model in place before you go ahead with the physical design.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-02-10 : 12:52:12
|
| you could try this:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=143772I wrote it a long time ago.... may work for what you need.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-02-10 : 13:05:57
|
quote:
Originally posted by Transact Charlie
you could try this:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=143772I wrote it a long time ago.... may work for what you need.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Does it provide the visual map which the OP is asking ?  After Monday and Tuesday even the calendar says W T F .... |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-02-11 : 03:04:59
|
| no -- they have to use their imaginations.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
diagramming a db