Export whole PALO DB

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Export whole PALO DB

    hello,

    I want to know if there is any option to export the whole PALO DB and import it in an another PALO Instance. Incase the DB can't be still if i get the DImensions,cubes etc will also do.
    I am using version 3.2 currently, i tried the cube export but not sure if i can import it directly to an new instance without creating the dimensions or elements.


    regards,
    FX
  • If you are creating a new database then you will have to export the dimensions first to new database.
    If you are exporting cube to a new cube in the same database then cube export with Load having import with load type as create will create cube
    with all dimensions.
    Also handy is to export the rules from one cube and import it in your new cube.


    Hope it helps!

    Best regards,
    Noel.
  • Add to it - to copy database you can simply copy the cube data folder for the database and paste it in your new instance.
    data folder will be under <Palo Home>/OLAP/Data with folder having database name.

    Before copying - Stop PaloMolapService
    Copy the folder
    Start the PaloMolapService
    Stop destination PaloMolapService
    Paste it in destination instance
    Start the destination PaloMolapService.


    Best regards,
    Noel.