Transcript
Separating an ION Enterprise Server into a Distributed Application + Database Server
Página 1 de 7
RESOLUTION
Post a Comment
Separating an ION Enterprise Server into a Distributed Application + Database Server Applicable to Product Range(s) : ION Enterprise V5.6; ION Enterprise V5.5 Resolution Number: 189842
Revision: 1.0
Goals and Summary Symptoms This article describes the process to separate an existing ION Enterprise server (applications and databases on the same machine) into a distributed system (applications on one server, databases on another). Here is a broad overview of the process: 1. Create a new database server with the ION Enterprise installer. 2. Copy the ION Databases from the old server to the new database server. 3. Change settings on the application server to use the new database server. This procedure only applies to versions of ION Enterprise where the installer supports the “Database Server” option – 5.5 and 5.6. Facts and Keywords Changes 5.5 5.6 Distributed system Database server Causes Procedure and Fixes Create a new database server with the ION Enterprise installer. 1. Install & configure SQL Server for use with ION Enterprise. If you are using SQL Server 2005, refer to RESL188408 – How Should SQL Server 2005 Be Installed For Use With ION Enterprise? 2. On the new machine that is to be the database server, run the ION Enterprise installer. Choose the “Database Server” option. 5.5 Installer:
http://sopna01.aut.schneider-electric.com/Intranet/CustomerView/APS/PubRes.nsf/Index/c3f730cdd09cb8a0c12573a2005d9087?Opendo... 22/09/2009
Separating an ION Enterprise Server into a Distributed Application + Database Server
Página 2 de 7
5.6 Installer:
3. Let the installer run through to completion. Reboot when prompted to finish the installation.
Copy the ION Databases from the old server to the new database server. 1. On the old server, stop all the ION services in the Windows Services control panel. 2. Create backups of the ION_Data, ION_Network and ION_SystemLog databases before proceeding. 3. Detach the ION Databases from SQL Server. You can do this in the ION Database Manager, or in the SQL Server management tools. (For SQL Server
http://sopna01.aut.schneider-electric.com/Intranet/CustomerView/APS/PubRes.nsf/Index/c3f730cdd09cb8a0c12573a2005d9087?Opendo... 22/09/2009
Separating an ION Enterprise Server into a Distributed Application + Database Server
Página 3 de 7
2000, Enterprise Manager. For SQL Server 2005, Management Studio.) Detaching databases in the ION Database Manager:
Detach ION_Data, ION_Network, and ION_SystemLog. These are the 3 “live” databases that ION Enterprise needs for proper operation. You may also detach any ION_Data archives that you wish to copy over to the new database server. 4. On the new database server, repeat step 2; detach the ION databases from SQL Server. 5. Copy the database files from the old server to the new database server. The default location of these files is the folder \ION Enterprise\Database. Copy the entire folder & sub-folders to the corresponding location on the new database server. When prompted if you wish to overwrite existing files, reply Yes. You may also wish to copy database archives from the old server to the new database server. The default location of these files is the folder \ION Enterprise\config\cfg\Archives. Copy the entire folder & sub-folders to the corresponding location on the new database server. These database archives must be detached as in step 2 before you can copy them. By default, backups of the ION databases are generated on a regular basis by scheduled maintenance jobs. Their default location is the folder \ION Enterprise\config\cfg\DBBackups. At this point in the migration, you may also wish to move these backups to the new database server. Alternatively, you may be storing these backups in a different secure location. Consult your IT department regarding your company’s best practices for backup storage. 6. Attach the ION databases to SQL Server on the new database server. You can do this in the ION Database Manager, or in the SQL Server management tools. Attaching databases in the ION Database Manager:
http://sopna01.aut.schneider-electric.com/Intranet/CustomerView/APS/PubRes.nsf/Index/c3f730cdd09cb8a0c12573a2005d9087?Opendo... 22/09/2009
Separating an ION Enterprise Server into a Distributed Application + Database Server
Página 4 de 7
Attach the databases one at a time. Navigate to each of the ION_Data.mdf, ION_Network.mdf, and ION_SystemLog.mdf files from the location you copied them to. 7. You may also wish to attach any archive databases you copied from the old server. If you wish to access these archives through Reporter, you will have to update the ODBC DSNs for them on the application server to point to the new database server. On the application server, open the Data Sources (ODBC) control panel from Administrative Tools:
Switch to the “System DSN” tab. Select an ION_Data archive DSN. Click “Configure” to open its properties.
Update the selected Server to the desired SQL instance on the new database server. Click “Next”.
http://sopna01.aut.schneider-electric.com/Intranet/CustomerView/APS/PubRes.nsf/Index/c3f730cdd09cb8a0c12573a2005d9087?Opendo... 22/09/2009
Separating an ION Enterprise Server into a Distributed Application + Database Server
Página 5 de 7
Uncheck “Connect to SQL Server…” to proceed. Click “Next”, “Next”, “Finish” and “OK” to progress through the rest of the wizard to complete updating the DSN. Repeat this process for all ION_Data archive DSNs. Setup of the new database server is now complete.
Change settings on the application server to use the new database server. 1. Change the ION Enterprise Registry keys on the application server to point to the new database server. Open the Registry Editor (regedit.exe) and navigate to the key HKEY_LOCAL_MACHINE\SOFTWARE\Power Measurement\ION Enterprise\5.5\Databases (for 5.5) HKEY_LOCAL_MACHINE\SOFTWARE\Schneider Electric\ION Enterprise\5.6\Databases (for 5.6) Change the 3 values “IONServer” “NOMServer” and “SYSLOGServer” to the name of the SQL Server instance being used on the new database server. 2. At this point you can restart the ION services on the application server. In the Windows Services control panel, restart all the ION services you previously stopped. 3. Start Designer. Open the LOGINSERTER on your application server, and open “Log Acquisition Modules”. Open the Toolbox from the menu bar: check Options -> Show Toolbox. Right-click on the “LogAcquisition 1” module to edit it. Double-click on the “LAM1 Data Source” Setup Register and change the Data Source to the name of the SQL Server instance being used on the new database server:
http://sopna01.aut.schneider-electric.com/Intranet/CustomerView/APS/PubRes.nsf/Index/c3f730cdd09cb8a0c12573a2005d9087?Opendo... 22/09/2009
Separating an ION Enterprise Server into a Distributed Application + Database Server
Página 6 de 7
Click OK on the dialogs, and then from the menu bar choose File -> Send & Save All to save the changes. 4. In Designer, open the QUERYSERVER on your application server, and follow the same procedure as step 3 for its “Query 1” Query Module.
Close Designer when you are done saving the changes. 5. If you have created any reports using Reporter, you will have to update them to query the new database server. In Reporter in ION Enterprise 5.5, select your report, then click Properties, and Edit each Database query.
Reporter will pop up the Connection Properties dialog. Update the Server Name to the name of the SQL Server instance being used on the new database server:
http://sopna01.aut.schneider-electric.com/Intranet/CustomerView/APS/PubRes.nsf/Index/c3f730cdd09cb8a0c12573a2005d9087?Opendo... 22/09/2009
Separating an ION Enterprise Server into a Distributed Application + Database Server
Página 7 de 7
Click OK for this dialog and the next, then Save to update the report with the new database server information. You will have to do this for each of your reports. In Reporter in ION Enterprise 5.6, you can update your reports by using the “Manage Reports” function to Edit your reports:
Simply clicking on the Edit button in Reporter, and then clicking OK in the Edit Report dialog, will update the report with the new database server information. You will have to do this for each of your reports.
This procedure is now complete. All of the ION software on the application server is now using the databases on your new database server. Last Revised: November 21, 2007 Applies To: ION Enterprise 5.5, 5.6 Internal PMO/PMC All content © 1992-2007 Schneider Electric
http://sopna01.aut.schneider-electric.com/Intranet/CustomerView/APS/PubRes.nsf/Index/c3f730cdd09cb8a0c12573a2005d9087?Opendo... 22/09/2009
