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

[mithun_laha]

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?

[Krishna · Accepted solution]

@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 · Accepted solution]

@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]

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 · Accepted solution]

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

[mithun_laha]

Thank you for the solutions. 

[Brooks]

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?