Forum Discussion

mithun_laha's avatar
mithun_laha
New Contributor III
7 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
    7 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
    7 months ago

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

  • Krishna's avatar
    Krishna
    Valued Contributor
    7 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.

    • mithun_laha's avatar
      mithun_laha
      New Contributor III
      7 months ago

      Hi Krishna - I did manual migrate from one environment to another. Ca you explain me Export and Import process? Is it using Table Data Manager?

      • Krishna's avatar
        Krishna
        Valued Contributor
        7 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
    6 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
      2 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
        2 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.