Upgrade to newer version of SQL Clone

andrewgibson

Looking to upgrade to a new version of SQL Clone but never carried out an upgrade, just asking for some assistance. 

Currently on v5.x and looking to go to v5.4.21 so we are 1 version behind the latest version. Is this do-able?

Also how does the agent get upgraded automatically? Does the server that has the agent installed need to be internet facing? 

And is SQL Server 2012 still supported on v5.4.21 as we have a fair amount of SQL 2012 source and targets?

Eddie D

Hi, thank you for your forum post.

To answer your questions:
Currently on v5.x and looking to go to v5.4.21 so we are 1 version behind the latest version. Is this do-able?

Yes this is do-able.  May I confirm the exact version you are upgrading from?  If required, you can download SQL Clone V5.4.21.6521 using this link.  PLEASE NOTE the link will expire on 16th August 2024.

Extract the executable from the zip archive and run it on the machine that hosts your SQL Server.  Follow the on-screen instructions.

Also how does the agent get upgraded automatically?

On upgrading the SQL Clone Server, each SQL Clone Agent will communicate and connect with the V5.4.21 server over port 14146.  The Cone Server will detect that the Clone Agent connecting is on an earlier version and will attempt to automatically update the Clone Agent version by sending to it the single use SQL Clone Agent installer.

Does the server that has the agent installed need to be internet facing? 

No the machine hosting a SQL Clone Agent does not need to be Internet facing, it simply requires a connection to the SQL Clone Server over port 14146.

And is SQL Server 2012 still supported on v5.4.21 as we have a fair amount of SQL 2012 source and targets?

SQL Server 2012 is still supported.  You will find the requirements for both the SQL Clone Server and SQL Clone Agent in this help article.

If you require any further assistance or encounter problems during the upgrade, please submit a support request, either by email - support@red-gate.com or via the support portable on the redgate web site and click the "Submit a request" option.

Many Thanks
Eddie