Environment Refresh

Hi

I am trying to find the best way to do a environment refresh
one of my client using SQL server takes about 3 days to do a env refreesh....

I would like to suggest the best way to do it
1) Presently we run R98403 ( appropriate version)
2) Can I break R98403 in three version ( giving in the different range of tables) and run it from three different machines) or probably more range
3) I use DTS .. I heard its more faster... I am only copying business and control data .. does it consist of any environment specific data in these table which require it to be copied thur R98403...

Pls advice

I always found using R98403 the EASIEST way to copy the data. However, if
the data volume is very big it may take too long time.
I have succussfully done this:
use R98403 to copy Control Tables
use R98403 with data selection excluding the largest tables (like F0911),
copy these large tables using database tools, while R98403 is running.

My two centavos, Gerd



B732 - ERP8, Unix, Windows, Oracle, SQL, WTS, JAS

Hello,

The business data and control data do not contain environment specific data so it is fine and indeed much faster to use the uderlying database tools to perform the copy than it is through OneWorld. The OneWorld version performs it's work through the middleware layer allowing copies to take place between different platforms and databases if necessary.

The best way we found was to use the DB's EXPORT and IMPORT tools to move the data. Then modify the F983051, F9861 to make the target environment the same as the one copied from.