Voltar
-
Título
Migrating SQL Server and Oracle database agents to a different Foglight Agent Manager (FglAM) -
Descrição
How can a SQL Server or Oracle agent be moved to a different Agent Manager?
How can I migrate an Oracle or SQL Server Database agent between FglAMs?
How can SQL Server or Oracle Database agents be migrated from one FglAM (Foglight Agent Manager) to another?
-
Causa
A migration utility for SQL Server and Oracle became available beginning with the 5.7.1.1 Oracle and SQL Server cartridges.The new migrated agents will keep submitting data to the existing topologies so no data will be lost. -
Resolução
To migrate an agent to a different Agent Manager:
- Open the migration wizard by navigating to Databases| Support Dashboard | Databases Technical Support
- Expand Databases Agent Migration and then select Oracle or SQL Server
- Select the Agent Manager that is the destination host for the migrated SQL Agents. Click Next.
- On the SQL Agents for Migration pane, the left-hand column displays a list of available Agent Managers. Select an Agent Manager to view a list of the agents installed on it.
- From the list, select the agents that you want to migrate and move them to the Agent Manager Destination column.
- If necessary, select agents and set the Windows credentials.
- Click Next to migrate the agents.
- When migration has completed, click Finish to exit the Wizard.
Please refer to KB 260251 for additional notes on migrating SQL Server and Oracle database agents which have SQL PI enabled.
-
Informações adicionais
Please refer to KB 260251 for details on migrating database agents to a different Agent Manager when SQL PI is enabled.