将Access数据库导入SQL Server，保留表之间的关系

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

有人能告诉我你是否可以将Access数据库导入SQL Server,保留密钥和Access中建立的关系?

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

如果是这样,请告诉我如何做到这一点。

2 个解决方案

#1

(Quoting a comment to another answer:)

(引用评论到另一个答案:)

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

我尝试使用Microsoft SQL Server迁移助手Access,此工具不导出关系

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

废话。 SQL Server Migration Assistant for Access肯定可以将Access数据库传输到SQL Server并保留表之间的关系。

Access database:

SSMA for Access report:

SSMA for Access报告:

Resulting SQL Server database:

生成的SQL Server数据库:

#2

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:

这是指Access 2007 - Access在导入操作结束时不会自动在相关表之间创建关系。您必须使用“关系”选项卡上的选项手动创建各种新表和现有表之间的关系。要显示“关系”选项卡:

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