topic Re: How to do migration of data quality jobs from Data Management Studio 2.4 to 2.6 in SAS Data Management

How to do migration of data quality jobs from Data Management Studio 2.4 to 2.6

Kal_ETL — Tue, 06 Aug 2019 16:54:58 GMT

Good day data community,

I am currently on the task to migrate a dataflux server from sas 9.3 to sas 9.4 I am not sure on how to start with this, since my previous migration experience was on codes in 9.3 to grid, or from codes to data integration jobs.

The scenario is:

- Server on 9.3 it's using Dataflux Data Management Server on a Linux environment.

- Server on 9.4 it's using Dataflux Data Management Server on a Linux and Grid environment.

- Data management studio version for sas 9.3 users it's 2.4, with current jobs for names, address and phone numbers, and cutomized QKB.

- A couple of sas codes that uses data quality macros like %dqload, codes should be migrated too, but I think these codes doesn't require any special treatment to move them.

- Data management studio version for sas 9.4 users it's 2.6 (where existing jobs and QKB should be migrated).

Questions:

1.- Is there a special process to migrate Data Management jobs from 2.4 to 2.7 or a higher version?

2.- Is it possible to backup the current jobs (maybe create an spk in Management Console) and then restore them in new server running on 9.4? Or should I recreate the jobs and existing rules?

3.- Customized QKB should require an special treatment to migrate?

Any advice, previous experience or document with this will be great!

Thank you.

Many thanks in advance for your reply/replies.

Re: How to do migration of data quality jobs from Data Management Studio 2.4 to 2.6

AnandVyas — Wed, 07 Aug 2019 03:58:11 GMT

Hi @Kal_ETL,

Did you check this Data Flux migration guide?

http://support.sas.com/documentation/onlinedoc/dfdmstudio/2.7/dmpmig.pdf

It has detailed explanation on which content can be automatically migrated and which has to be modified a bit. I think this should be a good place to start and plan an effective migration.

Since you have also mentioned about migration to a newer version of SAS Platform, there is an guide to start of that as well. Here's the link to that:
https://go.documentation.sas.com/?docsetId=bimig&docsetTarget=titlepage.htm&docsetVersion=9.4&locale=en

Hope this helps!

Thanks!

Re: How to do migration of data quality jobs from Data Management Studio 2.4 to 2.6

Kal_ETL — Fri, 09 Aug 2019 17:32:51 GMT

Thank you Anand,

It will help I guess, I just reviewed that document but for 2.6 and it seems it can not be all backup, some manual job.

Regards.

Re: How to do migration of data quality jobs from Data Management Studio 2.4 to 2.6

AnandVyas — Sat, 10 Aug 2019 02:57:01 GMT

Great @Kal_ETL. HTH