Calling up dialog SQL server setting:- Options > Settings > User > Translation > Dictionary. Select the SQL server option and click [...].
- Utilities > Translation > Edit dictionary. Select the Management tab. Select the SQL server option and click [...].
- Options > Settings > User > Management > Project Management Database. Select the SQL server option and click [...].
In this dialog, you define the default settings for the SQL server that is to be used when working with the dictionary or project management.
- Utilities > Parts > Management > [Extras] > Settings. Select the SQL server option and click [...].
- Options > Settings > User > Management > Parts. Select the SQL server option and click [...].
- You have opened a project and selected a main function in the graphical editor or in a navigator. Edit > Properties. You clicked [...] in the Parts tab next to the Data source field. In the dialog Settings: Parts (user) select the SQL server option, and click [...].
In this dialog, you define the default settings for the SQL server that is to be used when working with parts management and / or part selection. These settings are exclusive, i.e. settings made for the parts management do not automatically apply to the part selection.
- Utilities > Translation > Edit dictionary. Select the Management tab. Select the SQL server option. [Extras] > New.
- Options > Settings > User > Management > Project Management Database. Select the SQL server option. Click
(New).
In this dialog you can generate a new, still empty, SQL server database.
Note:
As for the conversion of the dictionary to an SQL server, the EPLAN platform supports the versions of the Microsoft SQL server approved in the performance description. This also applies for conversion of the parts database and for setting of the internal part selection to an SQL server.
Overview of the main dialog elements:
Here you define the name of the server on which the databases are managed.
Select the type of logon used for the SQL server from this drop-down list:
- Windows authentication: This setting allows you to access the SQL server as soon as you have logged on as a Windows user. A separate password for the SQL server is then not required.
- SQL server: With this setting, you can only access the SQL server after providing user authentication in the two fields below. To do this, an appropriate access rights database must be created and filled with data on the SQL server.
These fields are only active when you have selected the SQL server option under Logon!
Here you enter the name and password to be used when access to the SQL server is to be password-protected. The characters entered are replaced with periods in order to preserve secrecy.
Store here the name of the database that is to be used for the dictionary or project management database. Or select the name of a database existing on the specified server from the drop-down list.
Tip:
If you wish to transfer entries from an existing Access database to an SQL server database, first export the data from the Access dictionary, generate a new SQL server database, and then import the data in the new database.
Use SQL server full-text search:
This check box can only be activated for the settings of the SQL server for the parts management / part selection.
If it is activated, parts management uses the full-text search integrated on the SQL server for the Full-text filter field. The search index is generated during the first full-text search routine and automatically updated by the SQL server whenever parts data is changed. Since the update is performed on the SQL server, no additional computing power is needed by EPLAN, thus accelerating the search.
Notes:
- "Advanced Services" must be installed and configured on the SQL server in order for full-text search to be running in the background.
- Unlike the "normal" full-text search, only search terms are found which are at the beginning of a word. When entering the search term INTER, e.g., you will therefore find parts with the designation INTERBUS, when entering BUS, however, you will not.
If the check box is deactivated, the same full-text search is used as for an Access parts database even when using the SQL server.
See also
Automatic / Manual Translation