SAS 9.2 Migration – EG Migration Wizard not so wizzy

There is a migration wizard delivered with Enterprise Guide 4,2 (9.2) that enables you to convert your EG projects automatically when you upgrade.

It is a an exe file in your EG 4.2 directory.

This wizard scans the selected EG projects and allows you to do a global replace of Servers, Libraries and External files.

The alternative is to open each EG project and manually change these (or alternatively do a fully automated SAS 9.2 migration, where you dont change any of the server names, libnames or file paths ;-)

So I have found this wizard a bit hit and miss.  Don’t get me wrong it still saves you time, but I have found instances where it doesnt actually update the EG Projects (normally when trying to convert a lot of projects at once).

Also with project that have a lot of tabs, it sometimes forgets to do one.

Another issue is it changes the libname of a source table, bit if the query saves the result table in a permanent libname (i.e. not work) then it doesn’t seem to update those ones.

So all fixable and the wizard is better than no wizard, but don’t under estimated the effort required to convert these projects.

Share
Tags:

2 Responses to SAS 9.2 Migration – EG Migration Wizard not so wizzy

  1. Amol on May 19, 2010 at 12:22 pm

    We can see more serious problem related to Query Builder when you want to export a project containing PROMPTs of date type. When the value of these Date prompts are used in filter the migrated query builder fails to execute due to the new nature of Prompts. In new form the selected date will be in form of DDMONYYYY when you migrate that project from 4.1 to 4.2 which will give you syntax error. I explained the solution in my blog.

    sasbiworld.blogspot.com

    Thanks,
    Amol

  2. Shane Gibson on May 19, 2010 at 8:47 pm

    Thanks Amol, great post and looks like a trick for young migrators ;-)

Leave a Reply

Your email address will not be published. Required fields are marked *

*