Data movement from one environment to anotherin JDE 8.12

kiran g

kiran g

Well Known Member
Hi,

For testing purpose, we need to move data from some of the database tables present in PS812 env to DV812 env of JDE OneWorld 8.12.

What are the possible and easiest ways of doing this data transfer? Is there any utility or application present in JDE through which tables can be copied from one env to other?


Thanks,
Kiran
 
If you're wanting to replace all the data in the tables, typically your standard database tools will perform these tasks the quickest.
 
You can use OMW and copy from one datasource to another - either using OMW Data Tools to do this one table at a time - or, to do a large number of tables or to create a routine that is going to be used a number of times - you can create a Table Conversion UBE. Both are simplistic if all you are doing is moving from one environment to another.
 
Well, you can refresh your environments in E1 using the R98403 batch, but it is very very slow. It is better to work with your database tools (make sure the JDE services are stopped to avoid data locks). What kind of database are you using?
 
Thank you all for giving me the direction.

We are using SQL Server 2000 as an underlying database for JDE 8.12.

Thanks,
Kiran
 
You have to pay attention if there are data dependencies between the tables and if the are data dependencies to the respective environment. Once you checked it, you can easily create a sql-script, which copies the desired tables. Be sure to backup your database before running any SQL!!!

truncate ps_dev.testdta.fXXXX;
insert into ps_dev.testdta.fXXXX select * from ps_prist.ps812dta.fXXXX;

This will copy all the table content from PRISTINE to DEVELOPMENT. Make sure that "ps_dev" corresponds to your development database and "ps_prist" corresponds to your pristine database. Verify if "testdta" is the table owner for your development data tables and that ps812dta is the table owner for your pristine data tables. If you want to copy control tables replace 'dta' with 'ctl'. Youi can look at the COM to see where a table is located.

Good luck!
 
Back
Top