BookmarkSubscribeRSS Feed
thomash123
Calcite | Level 5

Dear all,

I am wondering what the best practise in a developement/maintenance setup with DI Studio 4.21M2 is.

What I am talking about is:

There are two repositories: "Development (DEV)" and "Maintenance (MAINT)". A release (being e.g. 250 jobs) is developed in DEV and, once tested successfully, copied over to MAINT. From there the jobs are planned to SAS code and then deployed to the Production (PROD) environment (batch mode). When a bug in PROD needs to be fixed, it is done in MAINT, while the next release is being developed in DEV.

What is the best or common way to copy all relevant jobs, tables, utilities, macros etc. from DEV to MAINT? I know about exporting everything into multiple SPKs, which need to be imported in the correct order (tables, utilities, macros, jobs) and - as happened in the past often - loose mappings or connections to included utilities or jobs due to some DI Studio bugs.

How do you guys handle such a scenario?

Thanks,

Thomas

3 REPLIES 3
Daryl
SAS Employee

Metadata export packages are the typical vehicle for migrating jobs.  Can you be more specific about the mappings and connections that you are losing?  You might also try posting this question to the data management forum at  http://communities.sas.com/community/sas_enterprise_data_management_integration.

thomash123
Calcite | Level 5

Hi,

what I am referring to are e.g. included jobs or custom transactions, which are not included anymore for whatever reason or cannot be imported as they exist in the other repository on the same machine. There exist bug reports for it, but actually we dont actually have to worry about that in this thread.

What I am asking myself is this: Our data warehouse is (at the moment) quite small, so it is somehow manageable to build SPKs for tables, macros, jobs etc. and import them in the correct order. But this always takes a while and is pretty much manual effort.

How is this solved in bigger setups where it is not possible to export 1000 jobs and 300 tables into a huge number of SPKs and import them separately back into the other repository?

Can this be done automatically?

Thomas

Daryl
SAS Employee

SAS 9.2 provides utilities for batch promotion of metadata.  This would allow you to build scripts to do partial promotions.  See http://support.sas.com/resources/papers/sgf2008/migratemetadata.pdf and go to page 6 ("Batch Partial Promotion").

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 885 views
  • 0 likes
  • 2 in conversation