SQL server 2008 Compatibility question

qutesanju · Post by **qutesanju** » Mon May 16, 2011 12:46 am

We are currently running DataStage Server Edition 7.5.3 on Windows 2003 Server. The database is Microsoft SQL Server 2005

Few jobs are server jobs and use ODBC stages to access data in the database.

We have SSAS cubes running on SQL server 2005

We want to upgrade to SQL Server 2008 standard edition.
Does anyone know of any compatibility issues with this upgrade?

PaulVL · Post by **PaulVL** » Mon May 16, 2011 7:16 am

We had to upgrade out DataDirect drivers to the latest version to work properly with the new SQL Server. We used to have v6, now we have 6.something.

greggknight · Post by **greggknight** » Mon May 16, 2011 7:26 am

Well I have server jobs that I wrote back on version 5 against SQL server 2000
I have run them on all versions of datastage upto and including 8.5 there after and against all SQL versions upto and including SQL server 2008R2 ( 64 bit) I have not modified the jobs any. They are part of a reporting system I built to gather job statistics and load them in to SQL tables.

But thats my jobs I don't know what you have or what you are doing in the jobs. For instance the SQL thats in the ODBC. Is it SQL ansi standard????

That kind of stuff.