DB Case conflicts

Background


Tequila framework favors Upper case for db names because of
  • DB compatibility (Oracle uses uppercase)
  • Reduced conflicts when exchanging databases between unix/linux - windows systems.
Problem.When database servers are mixed *nix, windows. MySQL in windows will not respect table casing. When a script is exported from win the system will be damaged (As PHP is also case sensitive)

Recommendation:
You should generate AND code your application using UPPERCASE flag (in sunrise /addpage) to improve support in different platforms

If you have a win script:

Import the windows script into a new database and follow the next steps

Steps

  1. Run this SQL:   
    Select concat('rename table ', table_name, ' to ' , upper(table_name) , ';') from information_schema.tables where table_schema = '
    your_schema_name';
  2. Copy the resultset and run it again on the SQL window (In some installs you will need to add this first line:
    USE your_schema_name;


You can use the same sql to rename to lower just replace upper with lower

Our main page

Recent site activity