如何将整个Access数据库导出到SQL Server？ [英] How to export an entire Access database to SQL Server?

问题描述

我刚刚获得了一个可爱的Access数据库，所以我想做的第一件事是把它移到一个正常的数据库管理系统（sqlexpress），但是只有解决方案我发现听起来像疯狂。

在某处没有导出数据库到.sql 按钮？我有大约50个表，这个导出可能会运行不止一次，所以如果我不必手动导出所有的表将是巨大的。生成一个.sql文件（使用表创建和插入）也将是非常好的，因为它将允许我保持它的版本控制。

我猜，如果不可能做一些简单的事情，我会感激任何指针做类似的事情。

解决方案

有没有理由你不想使用Management Studio并指定Microsoft Access作为导入数据操作的数据源？ （Database-> Tasks-> Import，Microsoft Access作为数据源，将mdb文件作为参数）。还是有理由必须在Microsoft Access内完成？

I've just got a lovely Access database, so the first thing I want to do is to move it over to a normal database management system (sqlexpress), but the only solution I've found sounds like craziness.

Isn't there an "export database to .sql" button somewhere? I have around 50 tables and this export might run more than once so it would be great if I didn't have to export all the tables manually. Generating a .sql file (with tables creation and inserts) would also be great since it would allow me to keep that under version control.

I guess if it's not possible to do something simple like this I'd appreciate any pointers to do something similar.

解决方案

Is there a reason you don't want to use Management Studio and specify Microsoft Access as the data source for your Import Data operation? (Database->Tasks->Import, Microsoft Access as data source, mdb file as parameter). Or is there a reason it must be done from within Microsoft Access?

这篇关于如何将整个Access数据库导出到SQL Server？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！