Go to Top

Migrating to SQL Server

Detangling the new SQL Server ODBC and OLEDB drivers and what about Native Client?

Some of you may already know that Microsoft backtracked on their planned deprecation of OLEDB and provided a new OLEDB driver. However, it can be a headscratcher to figure what you should be using. When we were using SQL Server Native Client, it was pretty easy — the Native Client had both OLEDB and ODBC shipped in a single DLL file, making for easy installation. All you had to make …Read More

Using the new SSMA version 7.8, pitfalls to avoid

Microsoft has been updating their SQL Server Management Assistants on a regular basis, and they just updated the SSMA for Access. However you can’t see what’s new for 7.8 in their official documentation. The latest version of SQL Server Migration Assistant (SSMA) version 7.8 can be downloaded from here. The 7.8 version is much easier than prior especially with handling 32/64 bits but there are quirks, which we’ll be looking at. Which …Read More

Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.