Versions Compared

Version Old Version 11 New Version Current
Changes made by

Peter Ransom (Deactivated)

Chad Glitz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Section


Column
width75%

The processes and scenarios in this article provide instructions on how to move a SkySync or SQL node from one server to another. If migrating multiple SkySync nodes the process explained below will need to be repeated on each one. If migrating multiple clusters, then the migration should be done one cluster at a time.


Column
width25%




Warning

The below processes are for SQL Express and Full SQL only, and are not relevant to SQL CE.

Before any actions are taken, SkySync Files should be backed up to a folder on the desktop to prevent loss of connections and configurations

C:\Program Files (x86)\SkySync\appSettings.config

C:\Program Files (x86)\SkySync\connections.config

C:\ProgramData\PortalArchitects\Data\Keys

To prevent discrepancies between the SQL Servers the SkySync Service will need to be stopped on every node accessing the SQL database. If any programs are in place that automatically start the SkySync service they will need to be disabled. All activity on the SQL database should also be avoided until the migration is complete to prevent database discrepancies.

...

4) Restore the SQL database on the new server 

Note

If SkySync is not being moved

and therefore

or reinstalled, the connections.config file located at C:\Program Files (x86)\SkySync will need to be adjusted to reflect the new SQL Server and database.


Info

This Microsoft support article explains how to transfer SQL databases in greater detail and can be used for reference if needed additionally individual articles on backup and restore have been added below.

For Steps on how to backup a SQL database see this Microsoft support article here.

For Steps on how to restore a SQL database see this Microsoft support article here.

...