Setting Relationships/Diagrams

[Databaseguy]

I have migrated an old Access DB to SQL Server. All of the tables are normalized and I have set PKs and FKs.

I want to set relationships to enforce referential integrity and improve performance.

I go to diagrams, click add new, and start setting the relationships. When I am done, SQL gives me the prompt: "The following tables will be saved to your database. Do you wish to continue ?"

This is a confusing prompt and I bail out and answer no at this point. Will it overwrite the existing tables ? Create a new one ? Exactly what does this prompt mean ?
Tyrone Lumley
augerinn@gte.net

 

[vadimg]

If you're simply adding relationships, SQL Server will create the constraint on specified tables. It will not overwrite existing data.


However, I would suggest creating a copy of the database (or a few tables) and experimenting on that....