One landscape with different databases releases

[Former Member]

Dears,

A customer have MSSQL 2000 installed on your systems DEV and QAS. The PRD system does not installed.

Now the customer need install only the production system, but he want with MSSQL 2005.

Does have problems? What SAP recommend?

Thanks,

Dejalma Rodrigues

[former_member181887]

Hi,

It is possible to have different releases of DB within a landscape <u>as long as the same release of the SAP application supports it</u>. The end users will not see any difference.

The challenge is support for DB patching if you don't have anywhere to replicate production issues. Not to mention possible issues with different DB tuning parameters and back-up recovery processes.

I would suggest that you <b>at least</b> upgrade the QAS system to SQL Server 2005 too in the short term. The recommendation you will always get is to have all 3 aligned on the same release - that should be your longer term goal.

Cheers,

Mike