Ok, after some serious digging into the database itself, I’ve come up with
two lines of SQL that need to be run if you should change your $rtname and
$Organization variables. Not sure it this is perfect but it fixed my
problem at least.
set Base = replace(Base, ‘Old text’, ‘newdomain.com’)
where Base like ‘%Old text%’ ;
set Target = replace(Target, ‘Old text’, ‘newdomain.com’) where Target like
’%Old text%’ ;