Creating a Translation Memory Database

Before you can take advantage of translation memory, you need to create at least one database. You can create a local TM database (using SQLite), which is stored locally on your computer. Alternatively, you can create a server TM database (using SQL Express), which can be stored on an external server.

How to Create a Translation Memory Database

  1. Do one of the following, depending on the part of the user interface you are using:
    • Ribbon Select the Resources ribbon. In the Translation Memory section, select Create TM.

    • Start New Project Wizard On the second page of the wizard, select Create TM.
  2. From the submenu, select one of the following:

    • Local Select this option if you want to use SQLite for a local TM database. This option opens a simple dialog that lets you give the new database a name and choose where to store it. By default, the location for SQLite databases is in Documents\Lingo Translation Memories on your computer. However, you can choose a different location if you like.
    • Server Select this option if you want to use SQL Server Express for a TM database to be stored on a server. This opens a dialog with fields for the name, server, and security information related to the database.

      Note If you do not already have SQL Server Express installed and you try to install a server termbase or server translation memory, Lingo will prompt you to install SQL Server Express 2012. This version of SQL Server Express is supported on Windows 7, Windows Server 2008 R2, and Windows Server 2008 Service Pack 2,. However, it is not supported on Windows 8. If necessary, you can manually install another version of SQL.

      To download and install the latest version of SQL Server Express, go to:

      http://www.microsoft.com/downloads/

      Note In order to create a server translation memory or termbase, you must have both db_datareader and db_datawriter roles , or you must have the dbcreator role. This is set in your SQL management tool.

      In the following user mapping image, the user has both db_datareader and db_datawriter selected:

      In the following server role image, the user has dbcreator selected:

    For a server TM, in the Name of new database field, type a name for the TM database. Next to the Database server field, click . The Connect to SQL Server dialog opens, displaying a list of usable servers after Lingo scans your network. In the Connection timeout field, you can adjust the number of seconds to allow a connection to the server to be successful. In the Authentication section, you can use Windows Integrated Security (the default), or you can enter a specific user name and password for the server (if necessary). If you elect to use Windows Integrated Security, leave the user name and password fields blank. Otherwise, if your server requires specific credentials, enter them in the fields provided.

  3. After completing the fields in the appropriate dialog, click OK.

What's Next?

After creating a TM, make sure to choose it in whatever project you have open (see Choosing a Translation Memory Database). You can then use that TM to translate your project (see Applying Translation Memory Suggestions).

You can also import a Translation Memory eXchange file (TMX) into your TM. See Importing TMX Files.