CODEWITHSUNDEEP
sqlsql-serverms-accessprimary-keyentity-relationship
Jota Q
Jota Q

Reputation: 73

Import Access database into SQL Server preserving relationships between tables

Could someone tell me if you can import an Access database into SQL Server retaining the keys and the relationships established in Access?

If so, please show me how I can do this.

Upvotes: 1

Views: 3611

Answers (2)

Gord Thompson
Gord Thompson

Reputation: 123399

(Quoting a comment to another answer:)

I am tried with Microsoft SQL Server Migration Assistant for Access and this tool doesn't export relationships

Nonsense. SQL Server Migration Assistant for Access definitely can transfer an Access database to SQL Server and preserve the relationships between the tables.

Access database:

accessDb.png

SSMA for Access report:

ssmaReport.png

Resulting SQL Server database:

ssmsDiagram.png

Upvotes: 4

bob kendall
bob kendall

Reputation: 55

This refers to Access 2007 - Access does not automatically create relationships between related tables at the end of an import operation. You must manually create the relationships between the various new and existing tables by using the options on the Relationships tab. To display the Relationships tab:

https://support.office.com/en-au/article/Import-or-link-to-SQL-Server-data-a5a3b4eb-57b9-45a0-b732-77bc6089b84e

Upvotes: 1

Related Questions