{"searchBar":{"inputPlaceholder":"Search by keyword or ask a question","searchBtn":"Search","error":"Please enter a keyword to search"}}

Welcome to the Schneider Electric Website

Welcome to our website.

Select your location

Welcome the the Schneider Electric French website. It looks like you are located in the United States, would you like to change your location?

Traduisez en francais
{"support":{"yesButton":"Yes","noButton":"No","feedback":{"title":"What can we do to improve?"},"submitButton":"Submit","successMessage":"Thank you for your feedback","title":"Was this helpful?","feedbackPercentLabel":"of people found this helpful","captcha":{"error":"Please check the box"}}}
Search FAQs

Switching database in ION EEM

Goals and Symptoms

ION EEM is a database driven application, there might be the need to change the database with which an EEM installation has been working, some reasons might be:

    • Want to set up a test system, but commissioning an EEM installation will take too long in order to get current data or a significant amount of it, so if there is an existing database available then switching is a good idea.
    • Need to reproduce a behavior of another EEM install.
    • Technical support.
    • General development tasks.

Facts and Changes

database, EEM, switch, attach, change

Causes and Fixes

For switching databases you first have to get the second database, for this you will need to have the database files (.mdf and the .ldf) for a database or the backup file (.bak). If you have the database files follow this steps:

    1. Open SQL Server Management Studio
    2. In the database instance right click the Databases folder
    3. Select Attach...
    4. In the new window select a .MDF file by clicking the Add... button and browsing to the location of the file.
    5. SQL Server Management Studio will try to load an .LDF file with the same name as the .MDF, if it wasn't found it will indicate it with a message.
    6. Click OK.

This will attach the database and it should appear in the list of available databases. If in another case you have a backup file (.bak) follow this steps to restore it:
    1. Open SQL Server Management Studio
    2. Create a new empty database, choose any name
    3. Right click on your newly created database then click:

  • 1. To specify the source and location of the backup sets to restore, click one of the following options:
        • From database
          Enter a database name in the list box.
        • From device
          Click the browse button, which opens the Specify Backup dialog box. In the Backup media list box, select one of the listed device types. To select one or more devices for the Backup location list box, click Add.
          After you add the devices you want to the Backup location list box, click OK to return to the General page.
    2. In the Select the backup sets to restore grid, select the backups to restore. This grid displays the backups available for the specified location. By default, a recovery plan is suggested. To override the suggested recovery plan, you can change the selections in the grid. Any backups that depend on a deselected backup are deselected automatically.

    3. To view or select the advanced options, click Options in the Select a page pane.
    4. In the Restore options panel select Overwrite the existing database. Finally go back to the main panel and click Ok, this will restore the database.
After you have attached or restored the database, you need to point EEM to the new database, this is done by changing the following settings in the database.config file located on bin folder of the installation, change the following lines:

<key xsi:type="xsd:string">MeasurementStore</key>
<value xsi:type="xsd:string">server=<SERVER>;database=<DATABASE NAME>;uid=<USERNAME>;pwd=<PASSWORD>;</value>

<key xsi:type="xsd:string">EEM_Database</key>
<value xsi:type="xsd:string">server=<SERVER>;database=<DATABASE NAME>;uid=<USERNAME>;pwd=<PASSWORD>;</value>

<key xsi:type="xsd:string">connStr</key>
<value xsi:type="xsd:string">server=<SERVER>;database=<DATABASE NAME>;uid=<USERNAME>;pwd=<PASSWORD>;Provider=SQLOLEDB;</value>

Once the database.config file is modified, you will need to restart IIS to ensure the changes take effect. At this point if you access EEM website or the Admin Tool you will see that the data now comes from the new database.

Reporting Services Databases

If you want to move the Reporting Services databases from one computer to another too, you should back them up and restore them the same way as you did with the EEM databases, however, if you had saved reports there's an extra step to do. Reporting Services encrypts all the saved reports using a key, in order to be able to use the saved reports in another server, you need to