As I'm migrating Silverstripe databases on a regular basis I've encountered the same issue. I created a little helper Excel sheet, that converts tables to the correct Camel case until the issue is resolved in version 2.4.0.

Grrr... looks like my post timed out. I'll try again.
Live server 'A', test server 'B'.

a) export DB from 'A'
b) copy all public_html recursively from 'A'
c) create db on 'B'
d) import db previously exported from 'A' to 'B'
e) fixup _config.php to point to the db on 'B' with the right credentials
f) fixup .htaccess to allow php5 for files with .php extension on 'B'

Now since this is my first run with SilverStripe (I have done lots of Joomla) I cannot easliy see what might be wrong.
In IE and Chrome the site 'B' basically works but is missing the main masthead area completely as well as footer links.
In FF there is a failure (which must be suppressed by the other browsers).

[Warning] HTTP::add_cache_headers() must be passed an HTTPResponse object
GET /

Line 286 in /home/sites/zwww.co.uk/public_html/sapphire/core/HTTP.php

Anyone have any pointers?
Thanks in advance.
Lee

I just tried that patch for renaming the tables, but it doesn't work for me. It doesn't seem to do anything.

AFAICS it doesn't really do any uppercase renaming or am I missing something obvious?

http://open.silverstripe.org/attachment/ticket/2476/MySQLDatabase.diff

I'm not sure if I would want to manually rename 100 tablenames...