Skip to main content
ianreid
Member
Aug 10, 2023 1:27 PM UTC

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?

2 replies

Employee - Sage
JackLacavaEmployee - Sage
Employee - Sage
Aug 10, 2023 3:37 PM UTC

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
Expert
Aug 15, 2023 1:27 PM UTC

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'.

Terms & ConditionsAccessibility statement