Web URLs changes

Squiz Matrix Installation
1

Hi


I've successfully copied and updated from our production environment (3.6.5) to new testing environment (3.8.2).



However is there any quick way for me to change "every" web site from old web URL to new URL - instead of going through acquiring lock and updating it from "every" web site?



Thanks.

2

You can mass replace old url with new url by running manual SQL queries:

    UPDATE sq_ast_url SET url = REPLACE(url, 'old.url.com', 'new.url.com') WHERE
    url LIKE 'old.url.com%';
    UPDATE sq_ast_lookup SET url = REPLACE(url, 'old.url.com', 'new.url.com')
    WHERE url LIKE 'old.url.com%';
    UPDATE sq_ast_lookup_value SET url = REPLACE(url, 'old.url.com',
    'new.url.com') WHERE url LIKE 'old.url.com%';


** Use this at your own risk! **

I can't assure you that this will work on your system as it has done on my test systems. Keep a copy of your DB so you can restore this easily. Good luck Stan :)

Someone may be able to confirm if this will work on your oracle system...
3

Thanks Anthony,


It works well for me.