Migrated Data Structure

Unknown

Migrated Data Structure

Unknown

Hello,

I’ve migrated a folder from Dev to Test which contains: flows, data structures, queries, truth tables etc…

However, a particular data structure that I’ve loaded with data in Dev came over to the Test environment without any data in it. So when I debug the flow it kept prompting me to input data into the data structure.

I’ve tried re-importing the data structure individually but it still didn’t work. Do I have to reload the data structure in Test and also in Prod?

Unknown

Hello,

The method of migrating data may depend on the type of data structure you are moving.

If you are moving an Entity from Dev to Test, you will also want to export the folder where this data lives in.

However, in the case of a Database Structure, you will need to manually transfer over this this data from one database. This is because a Database Structures data lives in the database, not in Decisions. There are a few ways you can move over this data.

One way to do this is to create a flow in Test that fetches the data from Dev through database integration steps. After receiving the data, you can save it into the Test database by looping through this data and using the save step for the respective data structure.
Another method would be to create a custom query to move or copy data from one database to another.

More information about database integration can be found on our documentation pages here:

Integrating Decisions with External Oracle Database: [url=https://documentation.decisions.com/integrating-decisions-external-oracle-database/]https://documentation.decisions.com/integrating-decisions-external-oracle-database/[/url]
Insert, Update, Delete Steps For Integration With Database: [url=https://documentation.decisions.com/insert-update-delete-steps-integration-database/]https://documentation.decisions.com/insert-update-delete-steps-integration-database/[/url]
Add Query to External Database: [url=https://documentation.decisions.com/add-query-external-database/]https://documentation.decisions.com/add-query-external-database/[/url]

Thank you.

Unknown

Hello,

I’m sure it’s a Database Structure and as you mention below I’ve attempted in migrating over just the structure by itself over and the data within it did not transfer over.

So I do not know what’s my next step.
Thanks.

Unknown

Hello,

If you are familiar with SQL, you can create a custom query that will copy data from your test database to another. More information about creating a query cab be found on our documentation page here: [url=https://documentation.decisions.com/add-query-external-database/]https://documentation.decisions.com/add-query-external-database/[/url]

Alternatively, you can create a flow in Test that fetches data from the Dev database through database integration. To set this up, please follow this documentation page: [url=https://documentation.decisions.com/integrating-decisions-external-oracle-database/]https://documentation.decisions.com/integrating-decisions-external-oracle-database/[/url]
After you setup the database integration, you can use a Get all from [Our Integrated Table Name] Step to receive the data from the Dev database. After that, you will want to use a ForEach loop to loop though each item from the Get all step. In the loop, use a Save step for the database structure you want to save it to and map it in with Build Data.

Thank you.