Content Data Store database server support history
The Content Data Store of SDL Tridion 2011 SP1 has a number of changed software prerequisites compared to version 5.3, 5.3 SP1, 2009, 2009 SP1 and 2011. If your current version of Oracle or SQL Server is not supported, upgrade Oracle or SQL Server before upgrading the database.
In the following table: N=not supported, Y=supported, D=Deprecated (support may be dropped in the next version release), Dr=Dropped (support is definitely dropped in the next version release), P=Probably dropped (support is probably dropped in the next version release):
| Database server | 5.3 | 5.3 SP1 | 2009 | 2009 SP1 | 2011 | 2011 SP1 |
|---|---|---|---|---|---|---|
| Microsoft SQL Server 2000 SP4 | Y | Y | N | N | N | N |
| Microsoft SQL Server 2005 SP2 | Y | D | N | N | N | N |
| Microsoft SQL Server 2005 SP3 | N | Y | Y | Y | Y | Dr |
| Microsoft SQL Server 2005 SP4 | N | N | N | N | N | P |
| Microsoft SQL Server 2008 SP1 | N | N | Y | Y | N | N |
| Microsoft SQL Server 2008 R2 | N | N | N | N | Y | Dr |
| Microsoft SQL Server 2008 R2 SP1 | N | N | N | N | N | Y |
| Microsoft SQL Server 2008 R2 SP1 | N | N | N | N | N | Y |
| Oracle Database 9i Release 2 patch set 9.2.0.8 | Y | Y | N | N | N | N |
| Oracle Database 10g Release 2 patch set 10.2.0.2 | Y | D | N | N | N | N |
| Oracle Database 10g Release 2 patch set 10.2.0.3 | Y | D | N | N | N | N |
| Oracle Database 10g Release 2 patch set 10.2.0.4 | N | Y | Y | Y | N | N |
| Oracle Database 10g Release 2 patch set 10.2.0.5 | N | N | N | N | Y | Y |
| Oracle Database 11g Release 2 patch set 11.1.0.7 | N | N | Y | Y | N | N |
| Oracle Database 11g Release 2 patch set 11.2.0.1 | N | N | N | N | Y | Dr |
| Oracle Database 11g Release 2 patch set 11.2.0.2 | N | N | N | N | N | Y |
| IBM DB2 Server 8.1 | Y | Y | N | N | N | N |
| IBM DB2 Server 9.5 | N | N | Y | Y | N | N |
| IBM DB2 Server 9.7 | N | N | N | N | Y | P |