First of, pardon me for my bad English...
I'm usually developing my Silverstripe applications on windows, and i always hosting them on different Linux distributions.
The problem is that since Windows is not case sensitive the database tables all becomes lowercased. Then when i deploy to the Live servers all data is gone.
That is because:
1) All imported tables containing data is lowercased.
2) Mysql on linux is case sensitive on table names.
3) Silverstripe uses camelcased database tables.
Currently i'm using an ugly skript where i have two databases, one with the /dev/build created database and one with the lowercased, imported data. The script then compares those two, renaming the lowercased tables to uppercased versions taken from the tables created from the dev/build.
But this is getting really annoying, especialy on shared hosts, where you don't have direct shell access and can do the procedure quickly, but have to do everything in some kind of web admin.
I'm sure im not the only one having this issue.
How does the rest of the Silverstripe community deploy sites developed on Windows to *nix servers?