How to automate backup procedure in Di Studio 4.2?

[deleted_user]

Right now I am using import export wizard to take backup of all the jobs and sas datasets. Can I some how right a script to automate this procedure? The %OMABAKUP takes only the meta data backup. It does not take backup of the physical content like jobs, datasets. So can this be acheived?

[LinusH]

Aren't mixing up a bit here?
Export wizard exports metadata into package files.
%omabakup copies metadata to different location.
Neither of these backups "physical" stuff like deployed jobs (.sas files) and tables.

So, %omabackup is probably a better choice if your environment is large a need an automated process for backing up metadata.

To backup physical files, you will probably use 3rd party software to do the job. If you have your data stored in external RDBMS or SPDS, refer to that products documentation regarding backup strategies.

Usually, backup jobs are not defined within DI Studio.

/Linus

[deleted_user]

Agreed. So can I some how automate the process of creating an spk file?
Also do you mean that %omabackup will take backup of metadata of entire repository, like jobs, datasets, db tables, libraries, user written transformations, etc.?

Also if I restore this metadata backup on a diff server will I be able to run the jobs in a similar way? (ofcourse considering that the physical tables are moved to that particular location and connections to rdbms is made.)

[LinusH]

In 4.2, I think there is a way to do export in batch manner. But I think the focus for this functionality is release management, that is promotion of metadata to another environment (dev/test/prod).

And yes, %omabakup will backup all metadata in specified repository. See documentation on suppert.sas.com for details.

/Linus