Unable to see relationship diagram in database after upsizing from Access 2003 to SQL Server 2008 R2
Hi, I have upsized from Access 2003 to SQL Server 2008 R2 using upsizing wizard. Everything works fine. But I don't see relationship in SQL SErver 2008 R2 if I go to database. But I set relationship in Access 2003 before upsizing it. ALso I don't see relationship (diagram) in Access 2003 , which I was able to see before. So do I need to again recreate the relationship amongst the table in Access 2003 Or SQL SErver 2008 R2 ? Any idea ? I thought, if you link tables, everything should be taken care but i don't see relationship structure any more.
If you have selected to transfer the relationships among table to the SQL server, then the relationships should be created on the SQL Server Side. But the relationships on the SQL Server side are not represented graphically like in Access unless you create some Database Diagram and put your tables into the diagram. Without the diagram you can see the relationships on particular table by selecting that table in SSMS Object Explorer, right clicking on it and select Design. Then in the menu Table Designer/Relationships you can see the relationships defined for that table. Once you move the tables to SQL server you no longer see the relationships directly in Access. However you can then create the relationships in the Access layer among tables, you are no longer able to enforce the reference integrity in Access as this is handled by the SQL Server.