Forum Discussion
Microsoft SQL Server Migration Assistant v7.7 for Access now includes 32bit version!
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.
Any idea of why SSMA ended up 64-bit only in the first place, considering how often 32-bit version of Microsoft Office is installed?
Doesn't that seem strange, considering that, even for Windows 64-bit, the 32-bit version of Office is recommended during install (in order to ensure compatibility with most Office Add-ins)?
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.
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.
Hi Anthony,
> the only thing I could conclude is that the SSMA team are not MS Access Developers.
Iirc, you're right. It was a sperate company which MS bought to get the SSMA (especially for Oracle at that time) and all the other SSMA products are just "cross-compiled" (from Java ?) from that source ...
But that's ancient history ...
mfg Klaus
Hi Klaus,
I don't know the actual reasons that have lead to the decision by the SSMA team to support 32 bit again. We've reported the problem several times at MS but maybe that did nothing and there was e.g. just an intervention by a big client that moved things.
In any case, your blog has always been our most up-to-date information source and reference on this, in addition that you've kept Juan, me and others informed by PM when there's been a new development. So I want to take this opportunity to publicly thank you for your persistent work on this important matter for the Access community.
Karl
**********
