OK, I worked out the issue, what I thought was a database connection issue is actually down to the way data is now aded to pages from Power CMS. In the old system if you moved servers you simply had to redirect the Globals file to the new location, now you have to change every entry that relates to database content so the files have the correct URL. This means 24 changes on an 8 page site with 3 content areas on each page instead of the old single change.
Not an issue I know if you do find and replace across the site but that wont work if I want to keep a local version of the site as well.