3 Replies Latest reply on Jan 9, 2013 9:21 PM by JeffJon

    FDM Data  Migration

    Praveen. A
      Hi All

      We are going to do Migration from 11.1.1.3 to 11.1.2.2 Version ,We have data in FDM in 11.1.1.3,after doing FDM migration to 11.1.2.2. we want to load data of 11.1.1.3 to 11.1.2.2 Version. can we take FDM database backup from SQL server and restore the same in 11.1.2.2 version in new FDM application database. by doing this will data will be loaded or not?

      Thanks in advance
        • 1. Re: FDM Data  Migration
          JeffJon
          Yes, you can move the SQL Server Database from the 11.1.1.3 environment to the 11.1.2.2 environment. You will also need to move the application folder associated with the application and use the <Add Application> option to add the application to the 11.1.2.2 environment.

          From there you can then use the schema update utility to update the database to the 11.1.2.2 service level.

          There are multiple KM's in the knowledge base on this process.
          • 2. Re: FDM Data  Migration 11.1.1.3 to 11.1.2.2
            Praveen. A
            Thanks for your Reply

            Hi

            This is the procedure i am going to follow ,can u tell me whether it is correct or not ?

            1.     Create FDQM application in Target machine using FDQM workbench client.

            2.     Login to Source Machine where FDM is installed and launch workbench client.

            3.     Export as XML file.

            4.     Login to Target machine where FDM is installed and launch workbench client.
            5.     Import as XML file.

            6.     Login to Source RDBMS server and take a backup of the SQL DB.

            7.     Restore the SQL DB in the target machine.

            8.     Copy the Application path folder structure from Source machine to target machine.

            use the <Add Application> option to add the application to the 11.1.2.2 environment. *(Is this required if we have already created a application in target system )*

            Is anything esle i have to do other than these. Please let me know.
            • 3. Re: FDM Data  Migration 11.1.1.3 to 11.1.2.2
              JeffJon
              This process is not correct. This is what you need to do:

              a) In the source environment choose <Add Application> and login
              b) Highlight the application to be moved to 11.1.2.2 and choose "modify"
              c) Note the Application Path. The application folder will need to be copied to the application folder share in the 11.1.2.2 environment
              d) Click on the database tab and note the database information
              e) Move the database from the 11.1.1.3 environment to the 11.1.2.2 envionment

              If this is SQL Server, backup the DB and restore it in the 11.1.2.2 db environment
              If this is Oracle, create a new DB Schema in the 11.1.2.2 enviornment and in the 11.1.1.3 environment use the DB tools to export the current DB to a .dmp and import into the new schema

              f) In the 11.1.2.2 environment use "<Add Application>"
              g) Enter the name for the application, path to the copied application folder and choose the "FDM" application group
              h) Click on the database tab and enter the database information for the db in the 11.1.2.2 environment
              i) Run the schema update utility to update the DB from the 11.1.1.3 level to the 11.1.2.2 level.


              Need to Migrate an FDM Application Including Data (Doc ID 806173.1)