Skip to Content
0

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

Jul 07, 2017 at 08:01 PM

177

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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.

Share
10 |10000 characters needed characters left characters exceeded
Ravi kiran Pagidi Jul 31, 2017 at 09:26 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded