将访问数据库转换为MSSQL数据库使用Microsoft SQL Server迁移助手进行访问 [英] Converting Access Database to MSSQL Database Using Microsoft SQL Server Migration Assistant for Access

问题描述

我想修改Ms Access数据库到MS SQL 2012，使用Microsoft SQL Server Migration Assistant Access 6.0版
，但每次我尝试转换它的错误弹出。任何想法如何我可以解决问题我重新安装程序Microsoft SQL Server迁移助理Access，它只是工作，之后，我有相同的错误。
任何帮助将是最感激的

I am trying to convent a Ms Access Database to MS SQL 2012, using Microsoft SQL Server Migration Assistant for Access version 6.0 but each time i try to convert it an error pops up. any ideas how i can solve the problem i reinstall the program Microsoft SQL Server Migration Assistant for Access , and it worked just ones and after that i have the same error. any help will be most appreciated

Access Object Collector错误：Database
检索组件的COM类工厂由于以下
错误，CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419}失败：80040154类未注册（来自HRESULT的异常：
0x80040154（REGDB_E_CLASSNOTREG））。此错误可能是
运行SSMA作为64位应用程序，而只安装32位
连接组件的结果，反之亦然。如果您有32位连接组件或64位
SSMA应用程序，如果您有64位连接组件，您可以运行32位
SSMA应用程序，快捷方式
到32位和64位SSMA可以在程序菜单下找到。
您还可以考虑从
更新连接组件 http://go.microsoft.com/ fwlink /？LinkId = 197502 。
加载数据库内容时出错。

Access Object Collector error: Database Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). This error may be a result of running SSMA as 64-bit application while having only 32-bit connectivity components installed or vice versa. You can run 32-bit SSMA application if you have 32-bit connectivity components or 64-bit SSMA application if you have 64-bit connectivity components, shortcut to both 32-bit and 64-bit SSMA can be found under the Programs menu. You can also consider updating your connectivity components from http://go.microsoft.com/fwlink/?LinkId=197502. An error occurred while loading database content.

推荐答案

我不得不找到32位SSMA的EXE，即使我运行64位的窗口。默认安装位置为：

I remember this error. I had to find the EXE for 32-bit SSMA even though I was running 64-bit windows. The default installed location was:

C：\ Microsoft SQL Server Migration Assistant for Access \bin

C:\Microsoft SQL Server Migration Assistant for Access\bin

文件名为：

SSMAforAccess32.exe

SSMAforAccess32.exe

这篇关于将访问数据库转换为MSSQL数据库使用Microsoft SQL Server迁移助手进行访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！