This documentation refers to PhraseExpress v17 beta. The documentation for the production version 16 is available here.

SQL Server

PhraseExpress supports Microsoft SQL Server connections to share phrases with a client-/server architecture in professional/enterprise networks.

Features

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

Limitations

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

Table of Contents


Table of Contents