Forum Discussion

mithun_laha's avatar
mithun_laha
New Contributor III
8 months ago

How to migrate Application Table from one application to another application.

I am getting error "Unable to access database table 'ABC'. Database table 'ABC' does not exist". If we create a table with extensibility. Does it solve the problem?
Data Integration
  • Krishna's avatar
    Krishna
    8 months ago

    mithun_laha  - How did you create the table? Using the Table Data Manager? or Using BR.

    1.Typically, if you use the CAT (Cloud Admin Tool) it will copy all the tables from one application to another.

    2. If it is cloud you can create a support ticket to migrate. 

    3. Export and Import would also work.

  • Krishna's avatar
    Krishna
    8 months ago

    Yes you can export and import using TDM. It will be exported as XML and you can upload the same.

Brooks's avatar
Brooks
New Contributor II
7 months ago

I am having similar problems with XFT tables that were apparently created when implementing Guided Reporting.  I need to migrate them from our development application to our test application, but get an error "Only and XFC table or view can be dowloaded.  Guided Reporting won't work without these tables (for instance, XFT_GRT_ReportColumnSets).  How do I migrate these tables?

  • BernardoN's avatar
    BernardoN
    New Contributor II
    3 months ago

    Hey, did you manage to solve your issue ? We have the same problem, we developed guided reporting on a DEV app and now we can't find a way to migrate it to our Prod app. It looks like the only way to do it is start from scratch.

    Thanks

    • Brooks's avatar
      Brooks
      New Contributor II
      3 months ago

      I did solve it.  The solution is you have to put in a ticket through ServiceNow and specify the tables to copy.  You may need to escalate it as some techs will tell you they can't do just tables, only the entire application.  That is not true.