Forum Discussion

ianreid's avatar
ianreid
New Contributor III
2 years ago

Database table copy

We have built a custom model in a dev environment and now want to migrate this to a user test environment.  The build includes a number of database tables that we want to copy between the environments as they contain a large amount of data that needs to be used by the user test and will also be required to be migrated to the production environment.  Is there a way to copy database tables between environments, there doesn't seem to be anything obvious in the Load/Extract object list?

Metadata
  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago

    No, anything related to custom tables is up to you, I'm afraid. You can use SQLServer tools for it, or do like Marketplace solutions - i.e. have CREATE scripts triggered from Dashboards on first run.

  • MarcusH's avatar
    MarcusH
    Contributor III
    2 years ago

    You can use the XFT Excel templates to import data into custom tables. The Design and Reference guide has a section on 'Loading Excel Templates to Custom Tables'.