Upgrading your existing ADO.NET applications to DB2® Version 9.7 involves managing
the changes between DB2 Version
9.7 and previous releases that impact these applications and verifying
that these applications function as expected.
Before you begin
You do not have to upgrade ADO.NET applications that use
the OLE DB .NET Data Provider or the ODBC .NET Data Provider to run
with DB2 Version 9.7. However,
upgrading these applications to the
Data Server
Provider for .NET can
be beneficial for the following reasons:
- The Data Server
Provider for .NET has
a far more extensive set of APIs than the OLE DB and ODBC .NET data
providers.
- Access to the DB2 database
development productivity tools integrated with Visual Studio.
- Use of the Data Server
Provider for .NET can
bring significant performance improvements.
Procedure
To upgrade your ADO.NET applications to DB2 Version 9.7:
- Review the support for the Data Server
Provider for .NET and
how to program your applications to use the Data Server
Provider for .NET and
determine what changes to make on your ADO.NET applications.
- Rebuild your ADO.NET applications to use the Data Server
Provider for .NET.
What to do next
After upgrading your ADO.NET applications, perform the
remaining steps in the Upgrading database applications task.