Migrate cube

mihai.valcea
mihai.valcea Member Posts: 95
Hello,

I designed a cube on a local Navision database and I need to migrate it on main SQL option database in order to configure it.
I tryied to export xml and import again on another database. Even is possible to view xml on main database, the cube structure wasn't imported in Navision tables.
Is this a limitation or I'm doing something wrong.

Thanks.

Comments

  • kriki
    kriki Member, Moderator Posts: 9,132
    If you mean objects, export and import them.
    If you mean data in some Navision-tables, make a dataport to export and import them (a lot easier then XML-ports).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • vjac
    vjac Member Posts: 18
    Uhh, I think the purpose is to use the tables (BA Db. Overview Line aso) to design the xml file, not the other way around.

    So, afaik there is no backward functionality, but you can import the xml and then run the configurator. If everything is ok you should get the AS database as per the imported xml. The limitation is ofcourse that you cannot redesign the xml.
  • ycobos
    ycobos Member Posts: 9
    But can I not import with the XML all the objects and the data together?? Have I to do in two steps as you said???
  • kriki
    kriki Member, Moderator Posts: 9,132
    ycobos wrote:
    But can I not import with the XML all the objects and the data together?? Have I to do in two steps as you said???
    XMLports are like dataports. They just import/export data, not objects.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • kine
    kine Member Posts: 12,562
    The XML is just description of the cube which are processed with the BA Configurator which create the cube structure and DTS packages which are transfering data from Navision DB into the cube.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.