Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Matching Table Case Between Windows And Linux Servers

forums › forums › SQLyog › Using SQLyog › Matching Table Case Between Windows And Linux Servers

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • June 20, 2007 at 9:50 pm #10409
      jcmonty
      Member

      I am using SQLYog Enterprise v6.03.

      My local development machine runs Windows XP. My remote production server is on Linux.

      If I name tables using mixed case on the Linux database (e.g. MyTableName) and dump the database to a backup SQL file, and then import the dumped SQL file into my local database on my Windows machine, the names of tables are all lowercased (e.g. mytablename). How can I maintain the mixed case table names on my Windows machine? The way things are now, it's not possible to synchronize the databases. Or do I just need to set the table names on my Linux server to all lowercase, too?

      Thanks.

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.