Hi,
We are planning to upgrade our external source SQL server 2005 database to SQL server 2008 database.
are any issues connecting Datastage PX 8.1 jobs to SQL server 2008 database?
Please advise!
Thanks,
Hoa Nguyen
SQL server 2008
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 6
- Joined: Wed Jun 10, 2009 12:38 pm
Hi
Which version of Datastage you are going to use?
8.1 will support only SQL Server 2005 and not 2008
8.5 will support only SQL Server 2008 , but not R2
In term of connection, you will not find any issues.
But if you use Upsert, there you will start to face issue. Job may hang for hours even for few records either it is th' SQL Server Stage / ODBC Stage.
DS User
Which version of Datastage you are going to use?
8.1 will support only SQL Server 2005 and not 2008
8.5 will support only SQL Server 2008 , but not R2
In term of connection, you will not find any issues.
But if you use Upsert, there you will start to face issue. Job may hang for hours even for few records either it is th' SQL Server Stage / ODBC Stage.
DS User