E9.2 Is 9.2.0.5 compatible with SQL Server 2019?

[TimPierce]

Hello! Does anyone happen to have a link that shows releases of JDE versus the latest version of SQL Server they are compatible with?

We're on 9.2.0.5 and would like to migrate to SQL Server 2019. I'm just making some preliminary investigations.

 

[MFreitag]

support.oracle.com -> Certifications

 

[dysonrichard801]

Hello! I'm not sure if there is a single link that shows the compatibility between different versions of JDE and SQL Server, but I can suggest a few resources that may be helpful for your investigation:

1. JD Edwards Certification Matrix.
2. Microsoft SQL Server Compatibility.
3. JD Edwards Community.

 

[Larry_Jones]

You can set the JDE databases compatibility levels back to an earlier version.
See this https://sdk.rackspace.com/blog/Microsoft-SQL-Server-database-compatibility-levels/

 

[MFreitag]

You can set the JDE databases compatibility levels back to an earlier version.
See this https://sdk.rackspace.com/blog/Microsoft-SQL-Server-database-compatibility-levels/

I have always wondered about this... When ORACLE says JDE 9.2.x is compatible with say SQL Server 2012, can i run a SQL Server 2019 with a database compatibility set to 2012? Does anybody know?

 

[TFZ]

You can, but it's not certified (and as we get further and further away from whatever CNC used to mean, unless its Oracle based, they're not really killing themselves on certifying much else lately.)

 

[MFreitag]

You can, but it's not certified

Well, thanks Captain Obvious In the end it was my fault, i asked if i "CAN". Let me rephrase that. Did anybody ever get even the slightest hint by ORACLE that this would be OK and still be certified?

away from whatever CNC used to mean, unless its Oracle based

I also really like how you put this into words. That's a hard truth!