Upgrading from SQL Server 2005 to SQL Server 2008

Rohit_ben · Post by **Rohit_ben** » Tue Apr 17, 2012 4:19 am

Hi

As part of a major overhaul in our project, we are migrating from SQL Server 2005 to SQL Server 2008, as a target database. All our DataStage 8.1 ETL jobs fetch data from Oracle and populate tables in SQL Server.

We use ODBC Enterprise stages and have DataDirect Release 5.3 Service Pack 1 drivers installed (which are the default ones shipped with IS 8.1).

Could you please let me know whether IS 8.1 is compatible with SQL Server 2008 ? We would be also upgrading our drivers to 6.0 SP2 or above.

I searched for similar posts but most of them relate to the SQL server enterprise stages and not connectivity through ODBC.

qt_ky · Post by **qt_ky** » Tue Apr 17, 2012 6:50 pm

Check the DataDirect web site and/or product manuals for database versions supported by the ODBC drivers.

Also check with DataStage Support to get confirmation.

This topic has been discussed here as well:

viewtopic.php?t=145041

Rohit_ben · Post by **Rohit_ben** » Sun Apr 22, 2012 11:11 pm

We had raised this issue with IBM. They have responded by saying that the DataDirect v5.3 drivers(default with IS 8.1) does not support SQL Server 2008.

We have to upgrade our ODBC drivers to DataDirect v6.0 and above, which support SQL server 2008.

qt_ky · Post by **qt_ky** » Mon Apr 23, 2012 7:07 pm

Good, then consider upgrading to DataDirect 6.1, the release bundled with 8.7, or DataDirect 7.0 or 7.1 which appear to be the most current releases as of now.

Rohit_ben · Post by **Rohit_ben** » Wed Apr 25, 2012 4:47 am

As advised by IBM, we are upgrading the drivers to DataDirect v6.0