PhraseExpress supports Microsoft SQL Server connections to share phrases with a client-/server architecture in professional/enterprise networks.
Benefits of using a SQL server:
- Phrase changes are immediately available to all users.
- SQL servers are designed to handle a large number of clients and large databases.
- Multiple users can edit the phrase database simultaneously. No need to wait until a user has finished editing.
- The client-/server architecture prevents write collisions and version conflicts.
- Clients load the phrase contents on demand in the moment of text insertion to minimize memory consumption on the local clients.
- The phrase database is centrally stored and can be included in your existing SQL backup system.
- License keys are centrally managed. No need to walk from computer to computer to enter license keys or change PhraseExpress configuration.
- You can define "master users" with extra credentials. Those have general access to all phrases and can centrally configure client program settings of all users.
- Each user can have a personal phrase folder to store their personal phrases.
- Also works over the internet if using a Amazon/Azure SQL cloud server (Azure ActiveDirectory is not supported, though).
- Phrases are inserted with a small delay as the content is dynamically loaded from the SQL server over the network connection. If the SQL server is accessed through VPN or if using a cloud based Azure or Amazon AWS SQL server, there can be extra lag due to the slower internet transmission. For timing-critical applications such as spelling correction text replacements, PhraseExpress clients can be configured to load the entire SQL database upfront on startup. Alternatively, you can use a separate additional local phrase file for all phrases, that is loaded into the fast local memory for instant insertion.
- The SQL database is not available if the network connection is interrupted. However, you can cache the SQL phrase database on your device with a single click.
- PhraseExpress for iOS cannot access a SQL server due to Apple's App restrictions. Please use cloud sharing for Apple devices.
- PhraseExpress is very easy-to-use with a SQL Server, but setup in customized system environments may require advanced IT skills. We kindly ask for your understanding, that installation support is not free-of-charge. If you are overwhelmed with SQL, consider using PhraseExpress with cloud sharing which is easy to setup.