20162016. 1. 18. 17:21

64-bit Windows 10 환경에 설치된 Access 2016 x86 버전에 있는 데이터베이스를 Azure DB 로 마이그레이션 하기 위해 SQL Server Migration Assistant (SSMA) v.6.0 32-bit 버전을 설치하였습니다.

 

SSMS 실행 후 Access 파일을 선택하고 나면 툴에서 아래 오류와 함께 마이그레이션을 진행할 수 없게 됩니다.

 

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-bit 버전의 Access Database Engine 2010 Redistributable 패키지를 다운로드 받아 설치한 뒤 SSMA 를 다시 실행해 주시면 위와 같이 필요한 32-bit 클래스 등록 오류 없이 정상적으로 마이그레션 툴을 사용할 수 있습니다.

 

Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=13255

 

 

[참고자료]

SQL Server Migration Assistant for Access nightmare
http://www.explosiveinsight.com/Home/tabid/118/entryid/54/SQL-Server-Migration-Assistant-for-Access-nightmare.aspx

 

Latest Update - Microsoft SQL Server Migration Assistant (SSMA) v6.0 is now available.

http://blogs.msdn.com/b/ssma/archive/2014/08/21/latest-update-microsoft-sql-server-migration-assistant-ssma-v6-0-is-now-available.aspx

 

 

작성자 : Lai Go / 작성일자 : 2016.01.18

Posted by Lai Go