Skip to Content
author's profile photo Former Member
Former Member

PI 7.0 DB migration


We are using PI 7.0 (Windows environment).This is HA/Distributed environment

PI Application and DB both are running on different host with Microsft Cluster technology for HA

We wanted to move DB instance (only DB as we do not want to make any change into Application) on Linux or Solaris Server

Do we just need to use statndard OS/DB Migration system copy Guide for DB instance move to another server? We also want to have HA for DB after moving to new server

In addition to DB migration do we need to make any changes for below configuration after DB move to new server?

1. Change in PI Exchange profile file

2. SLD Configuration Changes

3. JCO Connection configuration Change

4. Visual and Configtool related changes

I appreciate expert opinion on this

Thanks in advance



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Feb 05, 2012 at 06:37 AM

    Hi Deelip,

    You need to use standard OS/DB migration, though in this case you are just migrating your DB and not application, but it is advisable to run sapinst on both servers because I am assuming that generally hostname naming convention for Windows and Unix/Linux changes plus your listener settings on application server will also change,

    ....but if you do not wish to run migration sapinst on your app server then you need to do manual changes on app. server for listener and your DB hostname should not change.

    Then you need to check "R3trans -d" for ABAP part and you need to check Configtool is getting connected or not.

    Let say you will be successful in making your java up in that case also you need to send your new data to SLD, check your SMSY, LMDB for correctness of DB server information.

    When your java will be up, then VA and JCo should not be an issue.

    Unless you don't have enough time to go through this experimental process. Please run migration on both servers and follow PI db copy documents also for few missing post steps.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      Thanks for your prompt response

      Need couple of clarification

      you have mentioned to run sapinst on both host, are you taking about running sapinst on source DB Server and Target DB Server?

      I am assuming that once DB is migrated to new host then HA Cluster configuration needs to be done, right??

      Do we need to make any changes to PI Exchange profile files?

      What is LMDB?



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.