where did my relationships go?

[scroce]

i recently migrated tables from mdb file into SQL Server. I noticed I lost all my relationships settings and primary keys.

When I did the migration I remember telling it which fields were PK's, but it's like it didn't take.

Now it looks like i'm going to have to re-do all my relationships.

am I not looking in the right place? or if so, what how do you make sure you don't lose these settings?


I am a nobody, and nobody is perfect; therefore, I am perfect.

 

[cmmrfrds]

The diagram resides on the sql server side. Do you have Enterprise Manager so that you can look at these diagrams.

Or, you should be able to see the diagrams under database diagrams in Access.

Did you migrate using the upsizing wizard?

 

[scroce]

Do I have this concept correct?- Diagrams in the adp file should mirror diagrams under EM in SQL Server, right?

the diagrams are in neither place - they must not have made it over.

and now that i think about it a little more, maybe I didn't use the migration wizard - I did a simple import (i had been experimenting with several ways to get the data imported, and I must have forgotten this particular time)

at any rate, it's probably easier for me to just recreate the relationships manually at this point.



I am a nobody, and nobody is perfect; therefore, I am perfect.

 

[cmmrfrds]

The diagram tool is the easiest way to set up the relationships. I normally, use the diagramer in EM.

 

[scroce]

ok - thanks!

I am a nobody, and nobody is perfect; therefore, I am perfect.