PROC-X.com
An online (unofficial) SAS® journal – written by bloggers

Main menu

Skip to content
  • About
  • add your blog
  • Contact us
SAS

Farewell to the SAS 9.2 Replication Wizard

by Paul Homes • September 29, 2010 • Comments Off on Farewell to the SAS 9.2 Replication Wizard

This post was kindly contributed by platformadmin.com - go there to comment and to read the full post.

It looks like the SAS® 9.2 Replication Wizard has recently been deprecated. I spotted a new SAS usage note about it the other day: Usage Note 40834: The Replication Wizard in SAS® 9.2 has been deprecated.

The Replication Wizard is, or perhaps I should now say was, a feature available in the SAS 9.2 Management Console (via Metadata Manager > Metadata Utilities > Replication) that could be used to completely replicate metadata from a source environment into a target environment (such as Development to Test , Lev3 to Lev2 etc). The alternative to replication is to promote selected subsets of metadata using the import/export wizards and SAS package (.SPK) files. This selective promotion method is sometimes known as partial promotion. Although replication might sound tempting initially, in practice the import/export methods are much more versatile (as long as they support the metadata you want to promote – significant improvements with SAS 9.2).

Unlike import/export where you promote a subset of metadata, with replication you were promoting all of the metadata in one hit (with optional substitution of things like host names, ports, paths etc), completely discarding any existing metadata in the target environment. You had to configure a fair bit of infrastructure in order to use replication, perform a few manual steps and then manually promote any associated physical (non-metadata) content. It seemed like a lot of work (and knowledge) for something you would probably only ever use once or twice (if ever), so I think it’s understandable why SAS Institute would retire this feature. I don’t imagine it got used enough to warrant continued development and testing. I suspect that most people used import/export (partial) promotion almost exclusively, even for the initial promotion into a newly installed environment.

I was always a little bit worried with replication that someone might accidentally get the 2 environments reversed and totally wipe out their source environment, overwriting it with metadata from their old or empty target environment! Another good reason to backup both environments before replicating :)

One of the benefits to replication was that it allowed you to promote portal pages (which are not currently supported with import/export as far as I know). Although it sounds like a good reason to use replication, you could only ever realistically use it once due to the all-or-nothing nature of replication. After the first replication any portal changes in the target environment (e.g. Production/Lev1) would be lost on subsequent replications. I had heard a rumour that promotion of portal pages was in the pipeline but haven’t heard anything more since. Does anyone reading this know what the current status of support for portal promotion is?

I personally hope that the list of supported metadata objects for the import/export promotion facility is extended in future to include things like ACTs, Users, Groups, Roles, Servers and Portal Pages – things that don’t reside in folders. That would round it out very nicely I think.

Updated 30Sep2010: I just spotted some information about portal content promotion in the SAS® 9.2 Intelligence Platform: Web Application Administration Guide, Third Edition. You can find it in Chapter 20 Introduction to SAS Information Delivery Portal Administration under Main Tasks for Administering the Portal in the section named Promote Portal Content. It states (in part) “Beginning with SAS Information Delivery Portal 4.3, a content promotion tool is available. This tool consists of stand-alone batch scripts, shell scripts, and metadata extraction templates.”

Updated 08Oct2010: In this SAS Discussion Forum comment Technolero mentions that it may be possible to get an early (potentially unsupported) version of the portal content promotion tool by contacting SAS Technical Support.

This post was kindly contributed by platformadmin.com - go there to comment and to read the full post.

Tags: Interesting SAS Usage Notes Metadata Migration SAS 9.2 SAS Management Console SAS Usage Notes

Post navigation

← SAS 9.1, Windows 2003, I/O and 32 bit limitations
Deprecated = dead, nadda, gone burgers, elvis has left the building (and so has SAS 9.2 replication) →

Popular Posts

  • SAS – Lowercase (lowcase) / Uppercase (upcase) / Proper Case (propcase)
  • How do I export from SAS to Excel files: Let me count the ways
  • How to Get Row Numbers in SAS Proc SQL (and DO NOT Use the Undocumented MONOTONIC Function)
  • How to convert the datetime character string to SAS datetime value? (ANYDTDTM and MDYAMPM formats)
  • Using SAS Enterprise Guide to run programs in batch
  • Clear the Results viewer in SAS 9.3

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com

Contributors

  • AFHood Group Blog » SAS
  • Avocet Solutions
  • BI Notes
  • Blogging about all things SAS
  • BusinessKen
  • Computing from Out in Left Field
  • Data Steps
  • Enterprise Software Doesn’t Have to Suck
  • Gregor Gorjanc (gg)
  • Heuristic Andrew
  • Jared Prins’ Blog – SAS
  • Ken's SAS tricks
  • Michael @ Scorpio
  • Musings From an Outlier: The SAS Users Blog
  • NOTE: Development With SAS
  • Numbermonger » SAS
  • Peer Revue
  • Peter Flom blog (Statistical Analysis Consulting)
  • platformadmin.com
  • ProcRun;
  • SAS – BioStatMatt
  • SAS – Confounded by Confounding
  • SAS – From a Logical Point of View
  • SAS & Statistics
  • SAS | r4stats.com
  • SAS and R
  • SAS Learning Post
  • SAS Live!
  • Sas on Melinda Higgins, Ph.D
  • SAS Programming for Data Mining
  • SAS support site – SAS Users
  • SAS Users
  • SAS-BI Business Layers
  • SASopedia
  • SASTechies
  • Software & Service
  • Statistical Analysis Consulting
  • StudySAS Blog
  • The SAS Dummy

Recent Posts

  • New certification alert: SAS® Certified Specialist: Administration of SAS® Viya®
  • SAS training: 5 free sessions technologists love
  • Creating a Microsoft Excel report using SAS, Python and SQL!
  • Decode your SAS® macro code with the MFILE and MPRINT options
  • ESM and S9CA: Useful Tools for Migration from SAS 9 to SAS Viya
  • CAS-Action! Advanced Frequency Tables – Part 4
  • CAS-Action! Grouping Frequency Tables – Part 3
  • Using SAS to score a test
  • CAS-Action! Saving Frequency Tables – Part 2
  • CAS-Action! Simple Frequency Tables – Part 1
  • CAS-Action! Rename Columns in a CAS Table
  • Details, details: Updates to The Little SAS Book
  • SAS administrator tip: How to identify and prevent duplicate librefs in SAS metadata
  • Building an Open Source Software Community
  • Unexpected results from missing values with PROC SQL

Copyright © 2023 PROC-X.com. All Rights Reserved. The Magazine Basic Theme by bavotasan.com.

0