如何导入MDB到SQL Server [英] How to import mdb to sql server

问题描述

我有一个VB应用程序。现在，我已经开发了Asp.net相同的VB应用程序。在VB我已经使用MSACCESS数据库。在asp.net我使用SQL Server。现在，我想移动或MSACCESS数据库的数据复制到SQL Server。

I have a vb application. Now I have developed that same vb application in Asp.net. In vb I had used MSAccess database. In asp.net I am using Sql server. Now I want to Move or copy the MSaccess database data into Sql server.

推荐答案

打开MS Access数据库，去工具/数据库实用程序/升迁向导。你完成了。

Open your MS Access database, go to tools/database utilities/upsizing wizard. You're done.

只要按照向导的步骤，请确保您有SQL服务器的管理权限，请与关于详细的表/索引/规则升迁集成帮助所有的步骤。

Just follow the wizard's steps, make sure you have administrative rights on the SQL server, check all your steps with the integrated help for detailled table/indexes/rules upsizing.

有些数据库不会轻易升迁，由于无法导入到SQL特定访问/喷气配置。 本公司有一个小模块来检查这种问题，并且还可能提出自己的升迁向导的here 。

Some database will not upsize easily, due to specific Access/Jet configuration that cannot be imported into SQL. This company has a small module to check this kind of issue and might also propose its own upsizing wizard here.

这篇关于如何导入MDB到SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！