BookmarkSubscribeRSS Feed
kakakapo
Calcite | Level 5

Hi,

We can export SAS DI Jobs from Development Server and Import the .spk file in the Production Server. This is something we do as normal easy pracise.

 

Is there any other way we can achive this but not exporting and import functionality in DI Studio?

 

Problem is we have a very huge list of jobs to migrate and it takes time to do it in a relatively small time frame in production implementation.

 

Thanks,

kakakapo..

 

 

 

 

 

3 REPLIES 3
LinusH
Tourmaline | Level 20

What version are you using?

There is a batch interface that does the same thing as the wizards.

When using a wizard, there's an option to save/create the corresponding batch code.

What is that takes time? The manual export/import, or the processing time in the metadata server?

And then you need to consider how/which jobs to redeploy.

And, as discussed in earlier threads, redeployment can often come with a need to run addition scripts manually - if you are changing a physical table layout for instance.

Data never sleeps
kakakapo
Calcite | Level 5

We use DI 4.6 version and the number of jobs modified/newly developed would be migrated between Dev, SIT and Prod. Most of the times, we have to take individual jobs as .spk  export and import the same in the next environment. Sometimes, bigger packages have to be imported one by one at job/ table level and its painfull task.

 

When it comes to migration of jobs, some of them would be small and some would be bigger, time taken is more in the import and the export to be more precise. Re-deployment does not take much time to what ws observed.

 

Overall, I feel the time is taken when there is a communication made between Windows machine and the Server, When its already in the UNIX server, why bring them to Windows machine as a package and import it back to UNIX server using DI? Hope Batch does not involve windows.

 

So how do we do the same in batch interface? Would like to know how and if this could improve performance, would be bigger achievement.

LinusH
Tourmaline | Level 20
How - check out the documentation.
Performance - try it, performance is always hard to predict.
Data never sleeps

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 connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

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