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.

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.

Hello Rory and Thomas,

Thanks for the reply. I am looking into it now.

@rory.smith can you elaborate a bit more on the ‘advisor tool’, that doesn’t ring any bel for me.

Thanks,

Ronny

Hi,

once you are in the newer versions you can right-click your project and have:

If you are in-place upgrading SQL (better not to), you may want to take the following approach to allow rolling back to the old version if something goes wrong: https://www.sqlskills.com/blogs/jonathan/downgrading-sql-server-editions/