The Auros Blog

Auros: the internet consultancy and technology company

12Mar2012

Umbraco website migration for SYHA

SYHA Homepage

We have just completed an exciting project for the Scottish Youth Hostel Association. Their website which used to run on Alterian CMC (formerly Immediacy), now is powered by Umbraco!

This was an absolutely perfect candidate for an Umbraco website migration. Other than being a great CMS for Immediacy customers to migrate too, the project gave us the opportunity to use some of the great add-ons from the Umbraco Community. Here is just a few that really made the job much easier for us.

21Dec2011

A Christmas tale of migrating content from Alterian CMC to EPiServer

If Auros were Santa Claus our children would be well happy this year. We are delivering a host of goodies to our customers this Christmas, and one which is top of the pile is a solid and proven strategy for migrating content from Alterian CMC (formerly Immediacy) to our favourite flavour of enterprise CMS – EPiServer.

What will I get this year?

Feel the need to migrate? So many upgrades are needed as CMC creaks and crumbles and the upgrade paths are more wide spread than ever before. It’s our job to improve the process and reduce the pain and worry. Can we do that? We think so, and we have with Virgin Media Business.

9Aug2011

Alterian CMC SQL Toolkit

Over the many years Auros has worked with Alterian CMC, we have gathered together a number of useful SQL files we use for querying, re-setting, and reporting against the Alterian CMC databases.  Time and time again developers, installers and the support team at Auros find a use for some of these scripts so It would seem silly not to share these with the wider Alterian community!

Download Alterian CMC SQL Toolkit

The file names of the scripts within give a good overview of what's contained:

  • LogoffAdmin.sql
  • ShowAuthenticatedPages.sql
  • ShowDeletedPages.sql
  • ShowNewAndUpdatedPagesByYearMonth.sql
  • ShowPageEdits.sql
  • ShowPagesByTemplate.sql
  • ShowPagesSubmittedForApproval.sql
  • TruncateAuditTrail.sql

Please let us know if you find this useful, and whether you have any others you think would be worth adding.

Please note - absolutely no warranties are provided with these scripts and you use them completely at your own risk.