To homepage To homepage
Solved

TX upgrade from 18.6.8.64

R
Rank

Hello,

We are still running on TX 18.6.8.64 version and SQL server 2014.

Now they want us to upgrade to SQL server 2022 so it makes sense to also upgrade TX.

 

Questions:

  1. can I upgrade from 18.6.8.64 to latest TX version in 1 go ? 
  2. is SQL server 2022 working fine with latest TX version ?

Thanks,

Ronny

icon

Best answer by rory.smith 7 May 2024, 10:43

View original

2 replies

rory.smith
Rank
Userlevel 6
Badge +7

Hi @rluyten ,

  1. I would trial it by cloning your repository database and run against empty data databases. You will definitely need to run the advisor tool because you will likely need to redeploy indexes and conditional lookups.
  2. SQL Server 2022 works fine with TX if you are on 20.10.40 or later iirc. If you are running more complex SQL Server setups I would consider 2019 over 2022 though. Don’t forget to change the Compatibility Mode of the databases you move from 2014 to the new version to be able to use new SQL features.
Thomas Lind
Rank
Userlevel 6
Badge +5

Hi @rluyten 

Also go through the following guide, but skip the ones for ODX.

https://legacysupport.timextender.com/hc/en-us/articles/360042623431-Upgrade-ODX-and-TimeXtender-from-a-previous-version

You should always upgrade to the newest version and not just the first one that supports SQL2022.

Reply


Terms and ConditionsCookie settings