08-10-2023 09:27 AM
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?
08-10-2023 11:37 AM
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.
08-15-2023 09:27 AM
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'.