Migrating to SQL Server

Optimizing Access w/SQL Server IndyPass 5/21/19

Join me on Tuesday May 21st 2019 as I present Optimizing Access with SQL Server to the great folks at IndyPass. I’ll be discussing all the great tips and techniques we use with clients around the world. Pizza will be served as well. Abstract: SQL Server DBA’s are often asked to take over a Microsoft [...]

Optimizing Access w/SQL Server IndyPass 5/21/192019-05-16T07:30:00-05:00

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 an [...]

Detangling the new SQL Server ODBC and OLEDB drivers and what about Native Client?2018-11-15T09:04:02-05:00

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 h [...]

Using the new SSMA version 7.8, pitfalls to avoid2018-07-03T06:33:05-05:00

Use SQL Server Native Client 11.0 for the best performance

In our experience in using linked tables with Access, we get the best response using Native Client 11.0 with dsnless tables. You could use ODBC 11 for SQL Server but then you would NOT be able to use ADODB, so we prefer the latter and not the former. Microsoft does a great job of hiding Native Clien [...]

Use SQL Server Native Client 11.0 for the best performance2015-11-11T21:43:33-05:00
FREE CONSULT
close slider