Forum Discussion
Microsoft SQL Server Migration Assistant v7.7 for Access now includes 32bit version!
I agree it really has dumbfounded me as well... the only thing I could conclude is that the SSMA team are not MS Access Developers.
DanMoorehead_PowerWeb5AI wrote:
Thanks for the heads up, Juan, and good news!
Bringing back 32-bit support for the SQL Server Migration Assistant will be definitely make it more practical to use in many cases.
Doesn't it seem strange that SSMA ended up 64-bit only in the first place, considering how often 32-bit version of Microsoft Office is installed (as is even recommended, for maximum add-in compatibility)?
Any idea of what that was the case?
Juan Soto wrote:
Great news everyone! Via Klaus Oberdalhoff today I learned that version 7.7 now includes TWO versions to download, the 64 bit and 32 bit!
This is a major improvement, before it only included the 64 bit version, requiring additional steps to migrate your Access 32bit database to Azure or a SQL Server.
Anthony,
I suppose you may be right. From a non-Office developer standpoint, 64-bit seems the way to go, with most Windows installs being 64-bit these days – if otherwise unfamiliar with how most Office installs are 32-bit.