Skip to main content
To homepage To homepage
Solved

TX upgrade from 18.6.8.64

R
Contributor

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

Best answer by rory.smith

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.
View original
    Did this topic help you find an answer to your question?

    4 replies

    rory.smith
    TimeXtender Xpert
    Forum|alt.badge.img+7
    • rory.smith
    • TimeXtender Xpert
    • 649 replies
    • Answer
    • May 7, 2024

    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
    Community Manager
    Forum|alt.badge.img+5
    • Thomas Lind
    • Community Manager
    • 1017 replies
    • May 7, 2024

    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.

    R
    Contributor
    • rluyten
    • Author
    • Contributor
    • 11 replies
    • May 27, 2024

    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

    rory.smith
    TimeXtender Xpert
    Forum|alt.badge.img+7
    • rory.smith
    • TimeXtender Xpert
    • 649 replies
    • May 27, 2024

    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/ 

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings