Massive update email addresses in the Content Store

[koukise]

Hi All,

Please we plan to migrate our email addresses and we would like to massive update the scheduling of the reports.
We used that sql to udpate ntext column on SQL Server 2012 SP3

begin tran t;
update  cm.CMOBJPROPS26
set DELIVOPTIONS=   cast(replace(cast(DELIVOPTIONS as nvarchar(max)),'@old.com','@new.com') as ntext)
where CMID = '1';
commit tran t;

Unfortunately update is not correct and we break the report scheduling and the Schedules view in cogadmin. We are able to revert database.

Please does one of you already perform this kind of update successfully?

Thanks for support

[Eric.Pleiss]

Hi - MetaManager from BSP Software can help with bulk updates from the schedules.  If you've defined the emailed address directly our schedule Blaster tool can help update schedules, sent to a specific user, or adding and removing users.  We can also adjust individual schedules and sort on objects sent to a specific user (by CAMID or email address), or run against a specific user's credential. 

We can also document all of the scheduled content, so you can start from a master list of all scheduled objects and recipients, and ensure you're only spending time updating active and valid schedules that run successfully.

Check out https://www.bspsoftware.com/ or email us  directly at BSPSoftware@TechData.com and we can send you off with a quick demo and a fully functional trial key to tackle this use case.

[koukise]

Hi Thanks Eric,
We will check product functionalities, migration is now soon, so we will manually do that job, not really interesting :)