Web pages table with .cfm links needs to be changed to .aspx

[robreil]

I have successfully upgraded my 5.5 CFMX cart to 7.0 ASP.

I notice that to get my HTML listed in the WEBPAGES table I will have to find ever "content" in that table and manually change the .cfm extension to a .aspx extention. Im sure I can do a find and replace where ".cfm" is changed to ".aspx"

Furthermore I see that I will also have to do a find and replace with
"images/ with "assets/images/

I am using MSSQL2005 full version.

Is there any automated way to do this on the DB level other than a cell extraction in an SQL manager, select all, copy, alt tab, paste to dreamweaver, find and replace, select all, copy, alt tab, paste to the DB cell?

If so could some one point me to a tool that can do it?

Thanks.

[robreil]

Seems I need an MSSQL DBA to do this..

Heres an example of the code. Learn your SQL Query Language.
Start here as a tweak. It will show you In SQL Server Management Studio Express (New Query) what it will do if you change the code a bit. Google your SQL language examples and reverse engineer your code.

DONT FORGET TO B/U YOUR DB!

Select Description, replace (Description, '%.cfm%', '%.aspx%') from ac_webpages where Description like '%.cfm%'

Also worth considering:

Table: ac_webpages
Column: Description
Need:
Change:
.cfm to .aspx
_P to -P
_C to -C
_W to -W
"Images/" or "images/" to "Assets/Images/"

Table: ac_products
Column: Description, and ExtendedDescription
Need:
Change:
.cfm to .aspx
_P to -P
_C to -C
_W to -W
"Images/" or "images/" to "Assets/Images/"

Table: ac_Categories
Column: Description
Need:
Change:
.cfm to .aspx
_P to -P
_C to -C
_W to -W
"Images/" or "images/" to "Assets/Images/"

Hope this helps someone.