Copy Datasets from old Project to New Porject

kkumardatastage · Post by **kkumardatastage** » Fri Oct 15, 2010 12:43 pm

Hi

How do i copy a DataSets from old Project to New Porject they are on differen servers.

Please could any one help me in this

Thanks
k

ray.wurlod · Post by **ray.wurlod** » Fri Oct 15, 2010 3:51 pm

Not easy. Much easier to use DataStage jobs to dump the Data Set contents into a file on one server and load the Data Set from this file on the other server.

agpt · Post by **agpt** » Sat Oct 16, 2010 1:03 am

Ray,

It's not easy or not possible at all? As I know we can't copy datasets from one to other as it's saved in internal format which is very much server specific. Only thing possible is the solution you suggested.

Is there any way at all to copy them?

ray.wurlod · Post by **ray.wurlod** » Sat Oct 16, 2010 5:14 pm

Copy is always within the one server. To move the structures to another server the pathnames of every segment file, and the name of the descriptor file (which is part of the segment file name), would need to be identical to those used on the source server.