...
| Note |
|---|
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.If you are intending to utilize metadata imports it is advised that servers having SkySync installed on it be set to UTC time. This is because SkySync uses the timezone the SkySync server is set to as the 'starting' timezone, then converts to UTC, which can result in time stamps being shifted to the next day.It is important to note that the Operating System SkySync is installed needs to be set to a US English Local |
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.
...
| Note |
|---|
It is considered a best practice to utilize a SkySync Specific SQL User with Ownership rights to the SkySync Database |
10) Leave the Port: field blank to use the default port for SQL. If there is a resulting network issue and SQL server cannot be found, try port 1433 and verify if SQL ports are being blocked via security software/firewalls.
11) Click Validate followed by next to complete the install process
...
12) You will be prompted to enter your license key when first launching SkySync
Windows Defender Warning
It is possible when installing SkySync, that you will receive a message from Windows Defender blocking the install. This message can be manually bypassed by expanding the More Info.
...