Import Access Relationships to SQL Server 2005

• jamonakes

  Valued Member

  Points: 66

  More actions

  November 25, 2008 at 1:09 am

  #215674

  I recently migrated a database from Access 2007 to SQL Server using SQL Server Migration Assistance for Access. It worked well, only that it failed to migrate the Relationship diagram to SQL Server. I need to have the relationship diagram as well but I have so far not found a way to migrate it from Access to SQL Server 2005. Anyone with ideas on how to go about this?

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  November 25, 2008 at 3:32 am

  #903005

  I don't think you can import the diagram from Access to SQL server. Why can't you just create a new diagram in Management Studio?

  [font="Verdana"]Markus Bohse[/font]

• Nick H

  SSC Journeyman

  Points: 95

  More actions

  June 13, 2011 at 10:22 pm

  #1338151

  Nm