backup of DataStage project

akrzy · Post by **akrzy** » Mon Dec 27, 2004 8:44 am

Hi,
Could you tell me what is the best prtactice of making the DataStage project backup?
I don't know what the best way is, maybe exporting jobs or maybe coping all directory.
I don't have any experiece so please give me an advise.

Regards,
Anka

kcbland · Post by **kcbland** » Mon Dec 27, 2004 8:51 am

Exports. No question about it. Since everything about job designs, metadata, and functions, are in binary files, the only way to do a "selective" restore is from an export file. A directory copy or backup is simply a bitwise image at that point in time.

chulett · Post by **chulett** » Mon Dec 27, 2004 10:13 am

And there's a nice little DOS batch file over in the file library on ADN that will automate the exports of all project on a server.

akrzy · Post by **akrzy** » Tue Dec 28, 2004 2:38 am

Thanks a lot.
I've found this backup script.

Best Regards,
Anka :D

T42 · Post by **T42** » Wed Dec 29, 2004 9:28 pm

Do let us know if you have any problems with this script, or would like to suggest any feature upgrades.

Thanks.

chulett · Post by **chulett** » Wed Dec 29, 2004 9:45 pm

FWIW, I use it with a registered version of WinZip, which gives you access to WinZip's Command Line Interface. I hooked this into the backup script with the (off the top of my head) 'move' option in WinZip and so now instead of ending up with 15 exported projects taking up almost a Gig of disk space, I get a single zip with all projects in it. The compressed file is date stamped and takes up a little less than 200MB.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 29, 2004 10:37 pm

We use a BAT file that exports to a shared drive (one that is backed up daily), first taking a copy of yesterday's export. So at any time we've got DSExport.dsx and DSExport.dsx.bak on disk, and anything older can be recovered from backup. We don't bother with compression; there's plenty of free disk space, and it's more convenient to restore from.

gauravb · Post by **gauravb** » Thu Dec 30, 2004 4:03 am

Hi All,
where can i find this DOS batch file ( ADN )that will automate the exports of all project on a server.
Please can you specify the exact Location?
Is is avaliable some where is in default datastage repository??

chulett · Post by **chulett** » Thu Dec 30, 2004 8:43 am

ADN is the Ascential Developer Network and is here. It is Ascential's official version of a site like this one and registering gives you access to their File Library.

You'll find the file in question is called DataStageBackup.zip in the Product Application category.