You are here: User Interface Elements > Creating a Translation Memory Database
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 tm database
- 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.
Switching between ribbons and the tool strip… You can use the Options dialog to switch between ribbons and the classic tool strip layout. See Switching Between Ribbons and the Tool Strip.
More about ribbon options… Keep in mind that the smaller the application window becomes, the more the options in a ribbon shrink. Therefore, you might only see a small icon instead of text, or you might see only a section name displayed with a down arrow to access the options in it. You can hover over small icons to see tooltips that describe them. You can also enlarge the application window or click one of the section drop-downs in the ribbon to locate a hidden feature.
- Menu Select Resources>Create TM.
Translate Toolbar Click .
To open the Translate toolbar from the menu view, you can select View>Toolbars>Translate.
- Start New Project Wizard On the second page of the wizard, select Create TM.
-
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, Windows Server 2008 Service Pack 2, and Windows Vista Service Pack 2. However, it is not supported on Windows XP or 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/.
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.
- 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 TM Suggestions to Segments).
You can also import a Translation Memory eXchange file (TMX) into your TM. See Importing TMX Files.
SEE ALSO