自存一份备用.原文在 http://www.manageengine.com/products/eventlog/help/appendix/migrating-data-mysql-mssql-database.html
|
Post database change steps for Managed Server
When the Managed Server is installed, it is registered with Admin Server as Managed Server with MySQL.
If the database of the Managed Server is changed from MySQL to MSSQL, it has to be re-registerd with Admin Server as Managed Server with MSSQL.
After changing the database, when the Managed Server is started as application, it will prompt the user to re-register with the Admin Server.
After changing the database, when the Managed Server is started as service, there will not be any prompt to re-register. User has to ensure that the Managed Server is re-registered with the Admin Server.
|
EventLog Analyzer lets users to migrate the existing EventLog Analyzer data available in MySQL database to MSSQL database.
This procedure is applicable only if you are already using the EventLog Analyzer with MySQL and you want to change the database to MSSQL.
If you want to configure the MSSQL for fresh installation of EventLog Analyzer server, please refer the Configuring MSSQL Database page and follow the procedure given there.
The steps to migrate and run the Eventlog Analyzer server with SQLSERVER as the database is given below:
- Stop the Eventlog Analyzer Server/Service.
- Invoke the <Eventlog Analyzer Home>/tools/backUpDatabase.bat in command prompt, to backup the data available in MySQL database and wait till the data backup is getting completed. By default backup file will be stored under <Eventlog Analyzer Home>/backup directory with the file name like ‘backup_eventlog_<Build_Number>_MM_DD_YYYY_hh_mm.data‘.
- From the installed MS SQLSERVER, copy the files bcp.exe and bcp.rll to <Eventlog Analyzer Home>/mysql/bin folder.
|
Note: If you are copying the above file from SQL Server (Version 2005 & above) installed server and the EventLog Analyzer is installed in other machine, please install the following SQL Native Client in the EventLog Analyzer machine as per the SQL vesion and CPU type of EventLog Analyzer machine.
MSSQL 2005 (32 bit)
http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-a67d-48053b8f9fad/sqlncli.msi
MSSQL 2005 (64 bit)
http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-a67d-48053b8f9fad/sqlncli_x64.msi
MSSQL 2008 (32 bit)
http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0×409
MSSQL 2008 (64 bit)
http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0×409
|
- Invoke the <Eventlog Analyzer Home>/tools/changeDBServer.bat in command prompt, to configure the MS SQLSERVER credentials like ServerName, Port, UserName and Password.
-
Database Setup Wizard pops-up.
- In the wizard screen, select Server Type as SQL Server. Available SQL Server Instances are listed in a combo box. Enter the Host Name and Port of the SQL Server from the instances.
- Select the authentication type using the “Connect Using:” options.
- The options are:
- Windows Authentication
For Windows Authentication, enter the Domain Name, User Name and Password. Ensure that both EventLog Analyzer server and SQL Server are in the same domain and logged in with the same Domain Administrator account.
-
- SQL Server Authentication
For SQL Server Authentication, enter the User Name and Password.
- Click Test button to check whether the credentials are correct. If the test fails, the credentials may be wrong, recheck and enter the correct credentials.
- Click Save button to save the SQL Server configuration. Note that, it will take few minutes to configure the settings of the SQL Server database.
- Invoke the <Eventlog Analyzer Home>/bin/run.bat to start the Eventlog Analyzer server in the command prompt.
- After the server is started completely, stop the server by terminating the run.bat in the command prompt or invoke the <Eventlog Analyzer Home>/bin/shutdown.bat
- Invoke the <Eventlog Analyzer Home>/tools/restoreDatabase.bat, browse and select the created backup file. Now click on ‘OK‘ and wait till the database is completely restored.
|
Executing the restoreDatabase.bat will delete the existing data, if any. |
- Start the Eventlog Analyzer Server/Service to work with the MS SQLSERVER as the database.
|
You can also change the backup directory. Execute the batch file to backup by passing the absolute path of the directory as argument in the command prompt. Example command execution as follows: <Eventlog Analyzer Home>/tools:/>backUpDatabase.bat D:/Mysql
|
分享到:
相关推荐
many MySQL customers are migrating from Oracle because they have reached the conclusion that the combination of cost-savings and feature set of MySQL make for a compelling business case to offload ...
Migrating Jboss ESB from hsql to mysql
Migrating to MariaDB describes the process and lessons learned during a migration from a proprietary database management engine to the MariaDB open source solution. The book discusses the drivers for ...
Migrating Unity applications from Oculus to OSVR
Migrating IBM Spectrum Protect Servers from One Operating System to Another 非常详细的跨平台迁移手册(适用版本v6.2 ~ v8.1) 目录如下 Introduction . 1 Prerequisites . 1 Database backup and restore...
Migrating to Microservice Databases-From Relational Monolith to Distributed Data 介绍微服务架构下的数据库分别策略和设计开发模式,对于传统单体应用迁移到微服务架构的数据库设计模式进行提炼总结。
Migrating to Swift From Web Development gives you the ability to create native iOS apps using the latest Swift programming language. Starting with preparing your latest Xcode 6 Integrated Development ...
MigratingFromStruts1ToStruts2.pdf
1. Migrating JEE Applications to tc Server?. 3 2. Planning and Cost Analysis. 3 3. JEE Specification and JEE Application Servers. 6 4. Java EE 5.0 API Support. 7 5. Code Migration Strategies. 9 6. ...
Migrating to Cloud-Native App Architectures Pivotal.........................
Migrating to Swift From Web Development gives you the ability to create native iOS apps using the latest Swift programming language. Starting with preparing your latest Xcode 6 Integrated Development ...
Migrating Applications to IPv6
Migrating to .NET: A Pragmatic Path to Visual Basic .NET, Visual C++ .NET, and ASP.NET Find out how to migrate your legacy software to the powerful Microsoft .NET framework Provides for a complete,...
A Visual Guide for Migrating to Postgres Plus from MySQL
The primary objective of this book is to help experienced Android developers leap into native iOS–Swift mobile development. It is easier than you think, and this book will make it even easier with ...
Estimates vary but the message is clear: cloud spending worldwide is soaring, and much of the demand is coming from companies looking to migrate existing systems. Transforming a monolithic legacy ...
Apress.Migrating.to.MariaDB
Once you are fully comfortable with Nginx, you will start learning about migrating applications (or its part) from IIS or Apache web servers. Finally, you will learn to troubleshoot and maintain your...
Migrating-VxWorks-apps-to-embedded-Linux-slides-with-notes.pdf
The supported way to accomplish this in prior releases of the Oracle database was to export the data from the database on the old platform, create a new database on the new platform, and import the ...