Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

SkySync creates its database using SQL software. The versions and their uses are explained briefly below and a more in depth explanation can be found in our Best Practices article. It is advised to read the best practices article prior to installing as it contains the hardware and OS requirements for properly using SkySync. This will allow you to ensure that you have optimized your computer and database infrastructure to best suit your needs. 

SQL CE 

SQL Compact Edition or CE is the default database used when utilizing the standard installation, which is the simplest SkySync installation possible. SQL CE and the standard installation are best used for smaller customers as there are some inherent limitations. SQL CE can only have up to 3 million folder and file objects and is limited to a 4GB database size. Additionally it is more difficult to move a SQL CE database to a new server, where as SQL express and Full SQL are much more portable. Additionally the use of SQL CE will also limit SkySync to running no more then 2 jobs simultaneously. 


SQL Express, Full SQL and SQL Enterprise

SQL Express, Full SQL and SQL Enterprise allow for 6 jobs to run simultaneously and is required for larger installations. The major difference between the first 2 is that SQL Express has a maximum database size of 10GB where as full SQL had a max size of 524PB (petabyte). Additionally Full SQL is capable of using multiple computers to create its database. In order to use SQL or SQL Express is must be first installed and setup on the server containing it. Additionally a "SkySync" database will need to be created and it is advised that a user specific to SkySync be created with ownership rights to the Database as well. The user, database name, and user password will all be required during the install. SQL Enterprise is best used for massively large scale implementations of SkySync as it provides additional tools and capabilities that the other options do not. Examples of this are automated reports of the file migrations. 


Typical Installation

The Steps illustrated below assume that all other Hardware and OS configurations have been completed. Completing the below process will utilize SQL CE, and use the windows account currently being utilized by the user. Ensure that you have your License Key available, and it is a best practice to utilize a windows user/account specific to SkySync.

1) Download the most current version of SkySync from the link provided by your Service Representative. This link will be sent to the contact associated with the purchased license and if you are not the contact you will need to get the link from them or contact services or support to obtain a link. (insert image of email here)

2) Unzip the folder and open the SkySync application file (depending on the security settings of the computer you may need to run the file as administrator) 

3) When the Installer pops up read the License Agreement before checking the box accepting the terms. 

4) Ensure that Typical installation is selected and then click Install

5) Once the installation is complete a screen should appear announcing this. Check the box "Launch application on exit" before clicking "Exit" to immediately launch and begin using SkySync

Note: that the database configuration is SQL Server CE and the location of the program folders are automatically selected with a typical installation. Additionally the user used by the SkySync service will always be integrated authentication by default.


More Information

Different User Login custom potentially Firewall information, Proxy server (Expandable)


Steps for Custom installation utilizing a SQL Database

Re-iteration of specific requirements for this install and best practices ie user specific to SkySync

Steps and Screenshots of the install process


More Information

Proxy Server, Firewall



Multi-Node Install

Re-iteration of what is required as well as additional requirements unique to multi node


Special Note: Always make sure all SkySync nodes are running the same software version. Failing to do so could cause complications with the database.


 

Installing a multiple node setup

Please follow these instructions to setup a multinode SkySync installation when connecting to a single Full SQL database or a SQL Express database.

1. Ensure that you have a sufficient number of activation(s) on your license key for the number of nodes you will be installing. Each node will use one activation of your license. If you are unsure about the number of activation(s) remaining on your license please contact your sales representative or Portal Architects technical support.

2. Install and configure the Full SQL or SQL Express database on a separate server or virtual machine. Do not install any SkySync nodes on the machine containing the database. The hardware requirements for the database server increases as the number of nodes attached increases.

3. Install SkySync on the first node and activate the software.

4. Copy the keys folder from the first node to the desktop of every other node. The default location for the keys folder is: C:\ProgramData\PortalArchitects\Data\Keys

5. Install SkySync on the rest of the nodes but do not launch or activate the software on the secondary nodes.  Stop the SkySync service on each node.

6. Overwrite the keys folder on the secondary nodes with the copy made in step 4.

7. Restart the SkySync service.

8. Enter your license key on the nodes to activate the software.

Your multiple node setup should now be complete and ready for use.

Steps and screenshots of multi-node installation starting with 

  • No labels