RSS Feeds

FAQ Topics

All FAQ's

General DBA

General Developer

DBA Performance Tuning

Developer Performance Tuning

Clustering

Error Messages

USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...

SQL Server 2005 - clients using native client, should clients be upgrade as well

As you may be aware that SQL Server 2005 is steady and for the DBAs the task is to upgrade the database, in this scenario there will be a big question that whether the clients should be upgraded to use SQL Native client on the server.

The backward compatibility of SQL Server 2005 engine will allow to connect the previous version's MDAC client tools. But in order to take full advantages of 2005 version feature on server-end it is recommended to upgrade the client tools as well. As this is required to take new data types advantages, specifically. This will enable the application to make use of newest features in SQL Server 2005. Over the time there are considerable differences between MDAC and SQL Native cleint, to avoid any sort of mismatch of compatibility issues it is recommended to upgrade clients to SQL Native client, also this should not have any downtrend or issues to the application you are using.