none
Como Migrar Una base de datos Access Office 365 a SQL Azure RRS feed

  • Pregunta

  • Hoy he tenido un problema. al migrar una base de datos que tenia en access office 365

    "Migrar BD access office 365 a SQL Azure"

    Estava utilizando SQL Server Migration Assistant for access.

    Al intentar cargar la BD daba el siguiente error.

    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.

    Solución:

    Instalar el runtime de access 2010

    https://www.microsoft.com/es-ES/download/details.aspx?id=13255

    Con esto SSMA funciono correctamente.

    Saludos

    Aldo Flores Reyes

    @alduar

     

    martes, 16 de junio de 2020 16:23