The following databases are used by GroupShare:
- A GroupShare system database, all installations; default name: <servername>_SDLSystem.
- A MultiTerm master database, if MultiTerm Server component is installed; default name: <servername>_MTMaster.
- Termbase databases, if MultiTerm Server component is installed and at least one termbase is created; default names: <servername>_MTMaster_X.
- Translation Memory Service database, if TM Service component is installed; default name: <servername>_TMService.
- Translation Memory container databases, if TM Service component is installed; one default container name: <servername>_TMContainer | further container databases may be available, with freely chosen database names during creation by the user.
- {Only used by SDL Trados GroupShare 2017 SR1 or later} - Translation Memory Model management database, if TM Service component is installed; default name: <servernamse>_TMModel.
- {Only used by SDL Trados GroupShare 2017 SR1 or later} - Translation Memory Model databases, if TM Server component is installed and at least one TM was prepared for upLIFT; the database names will always begin with: TranslationModelsContainer_ followed by a generated ID.
Refer to below instructions to identify all databases used by your SDL Trados GroupShare 2017 SR1 instance:
SDL Trados GroupShare System Database
The default name for the GroupShare system database is
SDLSystem. If the name differs, you can identify it on the server where
SDL Trados GroupShare is installed:
- Start the SDL GroupShare Console.
- Go to Console Root > SDL Trados GroupShare > Databases.
- Check the Database Name in section GroupShare System Database.
MultiTerm Master Database
The default name for the MultiTerm Master database is
MTMaster. If the name differs, you can identify it on the server where
SDL Trados GroupShare is installed:
- Start the SDL GroupShare Console.
- Go to Console Root > SDL Trados GroupShare > Databases.
- Check the Database Name in section MultiTerm Master Database.
Note: If the section
MultiTerm Master Database is grayed out, your GroupShare installation does not include a MultiTerm Server component and thus no MultiTerm master database.
Termbase Databases
If your SDL Trados GroupShare instance includes a MultiTerm Server component, each termbase's data is stored in a separate database.
Via SDL MultiTerm
The name of each termbase database can be identified in the
Administrator and
Termbase Management view). The database name is displayed as
Physical name when clicking on the termbase.
Via MultiTerm Master Database
- Identify the MultiTerm master database according to above instructions.
- In the MultiTerm master database, retrieve all entries of the table dbo.Termbases.
- The names of all termbase databases used by SDL Trados GroupShare are listed in the column PhysicalName.
Translation Memory Service Database
Via SDL Trados GroupShare configuration files
- {Only relevant for SDL Trados GroupShare 2017 SR1 or later} - Open the configuration files C:\Program Files\SDL\SDL Server\TMService\Sdl.TMService.Agent.exe.config and C:\Program Files\SDL\SDL Server\TMService\Sdl.TMService.Host.exe.config and look for the following configuration line:
<add name="systemDatabase" connectionString="data source=<your_sql_server_address>;initial catalog=<servername>_TMService;integrated security=True;connect timeout=30" />
The value for the attribute "initial catalog" represents the name of your Translation Memory Service database.
- {Only relevant for SDL Trados GroupShare 2017} - Open the configuration files C:\Program Files (x86)\SDL\SDL Server\TMService\Sdl.TMService.Agent.exe.config and C:\Program Files (x86)\SDL\SDL Server\TMService\Sdl.RestApi.Host.exe.config and look for the following configuration line:
<add name="systemDatabase" connectionString="data source=<your_sql_server_address>;initial catalog=<servername>_TMService;integrated security=True;connect timeout=30" />
The value for the attribute "initial catalog" represents the name of your Translation Memory Service database.
Translation Memory Container Databases
Via SDL Trados GroupShare website
- Log into the SDL Trados GroupShare website by opening your server's URL in a web browser.
- Go to System Configuration, Containers.
- For each container listed, the Database Name corresponds to a database used by SDL Trados GroupShare.
Via SDL Trados GroupShare Translation Memory Service Database
- Identify the SDL Trados GroupShare Translation Memory Service database according to above instructions.
- In the SDL Trados GroupShare Translation Memory Service database, retrieve all entries of the table dbo.Container.
- The names of all Translation Memory Container databases used by SDL Trados GroupShare are listed in the column ContainerName.
Note: If your SDL Trados GroupShare instance misses the Translation Memory Service database, then your SDL Trados GroupShare instance does not use the TM Service component as well as no Translation Memory Container databases.
{Only used by SDL Trados GroupShare 2017 SR1 or later} - Translation Memory Model Management Database
Via SDL Trados GroupShare configuration files
- Open the configuration files C:\Program Files\SDL\SDL Server\TranslationModelService\Sdl.TranslationModelService.Builder.exe.config and C:\Program Files\SDL\SDL Server\TranslationModelService\Sdl.TranslationModelService.Host.exe.config and look for the following configuration line:
<add name="modelDatabase" connectionString="data source=<your_sql_server_address>;initial catalog=<servername>_TMModel;integrated security=True;connect timeout=30" />
The value for the attribute "initial catalog" represents the name of your Translation Memory Model management database.
