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?
SQL server 2008 Compatibility question
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 120
- Joined: Thu Oct 28, 2004 4:24 pm
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.
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.
"Don't let the bull between you and the fence"
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill
Thanks
Gregg J Knight
"Never Never Never Quit"
Winston Churchill