we need migartion scripts about Citrix 6.5 to 7.15 LTSR and SQL 2008r2 to 2012sql.

Shirish Vadla
Shirish Vadla used Ask the Experts™
on
Hello ,

I am being part of a project based on Citrix Migration 6.5 to 7.15 LTSR.
We have planned to migrate SQL 2008 r2 to 2012 sql.
we have been working on 2016 dev environment.

please provide me the scripts for the above two cases.

Thanks,
Shirish
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ste5anSenior Developer
Commented:
Just a comment on SQL Server:

When there's no real (technical) reason, then I would migrate to at least to SQL Server 2016. There are many improvements (query store, JSON support). Or SQL Server 2017 (graph support).

Especially as the mainstream support for SQL Server 2012 has already ended.
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
>> We have planned to migrate SQL 2008 r2 to 2012 sql.

Since Citrix 7.15 LTSR support SQL Server 2017, I would recommend to go with SQL Server 2017 instead of SQL Server 2016. Please find Citrix 7.15 requirements under Database section.
https://docs.citrix.com/en-us/xenapp-and-xendesktop/7-15-ltsr/system-requirements.html

>> please provide me the scripts for the above two cases.

You can upgrade SQL Server directly from SQL Server 2008 R2 (if you have SP3 installed) to SQL Server 2017 via SQL Server installer. SQL Server installer automatically takes care of installation and no scripts required.

I'm not sure whether upgrade from Citrix 6.5 to 7.15 changes your table structures or not and if so, then whether Citrix 7.15 installer takes care of them or not for which I would recommend to check with Citrix support once.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial