Forum Discussion
Microsoft SQL Server Migration Assistant v7.7 for Access now includes 32bit version!
The download link for the TWO versions of SSMA 7.7 is here. It kind of exciting to see both the 32 bit and 64 bit msi files.
Note that someone mentioned Windows as well as Office in talking about the SSMA.
You need to match the bitness of Access, not Windows and not SQL Server.
In other words, regardless of whether you have 64 bit Windows or 32 bit Windows, you need to use the same bitness of SSMA 7.7 as your Office installation: 32 to 32, 64 to 64. And, of course, the bitness of the target SQL Server is not relevant either. Only the two applications, Access and SSMA, are of concern.
Great news on two fronts. Obviously, it's good in and of itself, but it also a good example of the wheels at Microsoft eventually grinding out the proper response as a result of feedback from customers. Patience and persistence pay off.
Hi George,
The only context Windows was mentioned in was in stating that you need 32-bit SSMA for 32-bit Office, and how it didn't make sense that only 64-bit SSMA was available before because it needs to match the version of office, which is usually 32-bit Office - with 32-bit Office being the default install even for 64-bit Windows.
But thanks for the download links. The availability of both versions now certainly is good news.
Thanks for explaining that.