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 3 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

Steps and screenshots of multi-node installation starting with 

  • No labels