Missing relationships after attaching a database by SQL Server Management Studio

Question

Relationships between entities does not seem to exist after I imported a .mdf file by SQL Server Management Studio and I am sure that this database had many relationships between tables.

Does anyone have any idea on what might have happened and how can I solve this problem?

Are you transferring this from a different server or just re-attching it? — MwcsMac, Apr 28 '15 at 20:06
What do you mean by *import a .mdf file* - did you **attach** it to your SQL Server? Or what exactly did you do?? — marc_s, Apr 28 '15 at 20:20
I attached it to the SQL Server expecting it to show table relationships, but it did not. — Gustavo Rangel, Apr 28 '15 at 20:29
Are you referring to database diagram? Can you view what you are referring to on the original server? — MwcsMac, Apr 28 '15 at 23:04
possible duplicate of [How to export a SQL Server 2008 Database Diagram to another DB?](http://stackoverflow.com/questions/4019560/how-to-export-a-sql-server-2008-database-diagram-to-another-db) — DeanOC, Apr 28 '15 at 23:28

score 0 · Accepted Answer · edited May 23 '17 at 10:26

0

Look at this post if you are referring to the database diagrams. Database diagrams dot not come across with the mdf.

How to export a SQL Server 2008 Database Diagram to another DB?

edited May 23 '17 at 10:26

Community

1
1

answered Apr 28 '15 at 23:09

MwcsMac

6,810
5
32
52

Missing relationships after attaching a database by SQL Server Management Studio

1 Answers1