Moving a Datastage Project

Hemant_Kulkarni · Post by **Hemant_Kulkarni** » Wed Sep 10, 2008 9:10 am

Due to diskspace constraints on our UNIX box, we are needed to move the Datastage projects from the path

/ascential/datastage/Projects/ProjectName
to
/san/datastage/Projects/ProjectName

One way of doing this is to create a New Project, Export the Old Project and Import into the New Project.

Considering that there are many datastage projects hosted currently, this exercise of moving the projects is a time consuming and I believe that this is the hard way of doing things.

Is there any smarter way of moving the projects around ? Like changing the VOC ?

Any thoughts on this would be helpful.

WoMaWil · Post by **WoMaWil** » Wed Sep 10, 2008 2:39 pm

Dear Hermant,

Do it as you described. The VOC has many undocumented secrets and and everybody will blame you when there is a mistake.

Tell everybody to leave the project, check if there is no broken link to the project, then make one full export with for example dscmdexport as commandline-tool.

Then reimport. And you can go to town shopping during the export and later on during the import.

K

ray.wurlod · Post by **ray.wurlod** » Wed Sep 10, 2008 3:14 pm

Export/import is the only way. Any other "easy" way will involve you having to make repairs which will take even longer.

You can use the format.conv command to export and import, but this is messier and slower than the DataStage command.

Have you looked at other ways of recovering disk space, such as deleting files and hashed files that are no longer required?