This message was deleted.
# citrix-vads
Slackbot
09/12/2022, 2:32 AMThis message was deleted.
j
James Kindon
09/12/2022, 9:05 AMI can tell you in the above sentence exactly what isn't supported 🤮🤘🤮🤦♀️🤦🤮🤘 new farm, export import baby
d
Daniel Marsh
09/12/2022, 12:51 PMYeah I know none of it is supported lol. Customer wants to decomm their SQL server and move all DBs to SQL2017 first and Citrix upgrade will come later. All on 2012 R2 as well... I'm just unsure if 7.11 will bitch about the newer SQL version.
w
Webster Webster
09/12/2022, 4:10 PMBack up the databases and try it.
d
Daniel Marsh
09/12/2022, 10:29 PMThat will be the last resort if we have to, but given change control procedures and having to do the work out of hours etc I'm hoping to only need one attempt at this if possible
j
James Kindon
09/12/2022, 10:57 PMThe environment is too big to look at a side by side build? @Hal Lange is awesome with sql, he has likely seen this scenario before
h
Hal Lange
09/12/2022, 11:01 PMYou can most likely restore the DB and change the sql compat level to an older version on the DB
Hal Lange
09/12/2022, 11:01 PMAnd that should work to keeping it as the older version
Hal Lange
09/12/2022, 11:03 PMProblem you may run into is TLS 1.2 on newer version of SQL
d
Daniel Marsh
09/12/2022, 11:07 PMThey are only going to SQL 2017... which is supported for 7.6 and 7.15 so I'm hoping that means it will also work for 7.11, just trying to confirm first. I think we will just have to give it a go... and thanks for the tip Hal, I'll set the compat level to SQL2016. TLS if it's an issue I'm pretty sure can be disabled with a reg key.
h
Hal Lange
09/12/2022, 11:08 PMCorrect. It can be disabled via registry
Hal Lange
09/12/2022, 11:09 PMif you need to know where to set compat level
Hal Lange
09/12/2022, 11:10 PMproperties on DB and choose "Options"
d
Daniel Marsh
09/12/2022, 11:10 PMAwesome, thanks Hal!
2 Views