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