Hi,

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?

I'm fairly new to this thing, but had the same problem.

The fix offered in ticket 2476 almost works, but I had to manually rename the table Permission and the table Member, before it can go through and "repair" all the tables.

Thought I'd put it out there in case someone had the same issue. (or someone wants to reopen the ticket and add these two tables; although I don't know why they are not included in the other loop)

JuLo