Need to move db to a new SQL server

[WebGuyz]

Hi,

Have sitebuilder 4.2.3 and its installed on a SQL 2005 server and I need to move it over to a SQL 2008 server on another server and IP. What do I need to do to get this done?

Should I detach / reattach? Do I have to go in and change the IP address in the *.config files in the /sitebuilder/utils directory?

Any help would be appreciated.

Thanks!
Andy