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

[former_member476966]

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?

[former_member208402]

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.

[former_member476966]

Thanks for your suggestion but i want to refresh everytime when the new data come to prodcution, so 2 datastore creation is good in my scenario. Thanks for your suggestion

[former_member490928]

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.