Skip to Content

How to copy table data from prod environment to dev environment?

I want to copy only one table data from Production environment to Development environment.

1. I have one solution using BODS job where i can create two data stores one for dev and one for prod.then i will create job to load data from production to dev.

2. Apart from Import and export.

Is there any other ways to do this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 31, 2017 at 01:57 PM

    If you have full access to Prod environment. just export the table ATL.

    else make a Flat file as target and get it in your server. then create flat file in your Dev and target it with dev table.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 31, 2017 at 09:26 PM

    Hi Sandeep Adagal,

    No need to create 2 data stores, make data store default config to prod and load data to temp table/staging table and then use this table as source to load DEV table ( by changing data store default config to DEV). Make sure you create this temp table/staging table in staging data store. Dont use datastore in which you are extracting and loading data. Or use Flat file as Charity Cajigas suggested.

    Add comment
    10|10000 characters needed characters exceeded