Import Access database into SQL Server preserving relationships between tables

Question

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.

Have you tried googling "import access database to sql server"? Here is the first link that I found in that search: https://support.microsoft.com/en-us/kb/237980 Also possible duplicate of http://stackoverflow.com/questions/1307512/how-to-export-an-entire-access-database-to-sql-server — John Odom
– John Odom, Commented May 6, 2015 at 16:53
Yes. I did it... and it is not that easy. the link you send me does not work because refers access 97!!!!! and I need the utility imports the relationship between tables. Import without keys and relationship is easy but with keys and relationship... That is what I want to know. — Jota Q
– Jota Q, Commented May 6, 2015 at 17:04
@JotaQ What version of access are you using then? You should add a tag to your question specifying the version. — John Odom
– John Odom, Commented May 6, 2015 at 18:07

Gord Thompson · Accepted Answer · 2015-05-07 09:49:56Z

4

(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:

SSMA for Access report:

Resulting SQL Server database:

answered May 7, 2015 at 9:49

Gord Thompson

125k39 gold badges252 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bob kendall · Accepted Answer · 2015-05-06 17:29:25Z

1

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

answered May 6, 2015 at 17:29

bob kendall

5511 bronze badges

2 Comments

Gord Thompson Over a year ago

I thought the question was about importing in the other direction, from Access to SQL Server.

Jota Q Over a year ago

I am tried with Microsoft SQL Server Migration Assistant for Access and this tool doesn't export relationships... I think it's impossible...

Collectives™ on Stack Overflow

Import Access database into SQL Server preserving relationships between tables

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related