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

Data Synchronisation Different Tablenames

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Data Synchronisation Different Tablenames

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • May 29, 2007 at 4:12 pm #10348
      Musicman75
      Member

      Hello,

      I'm trying out the Enterprise Trial.

      Is it possible to synchronize the data of tables with different names?

      My server database table has an other name than the local table and I can't change the names.

    • May 29, 2007 at 8:22 pm #24033
      peterlaursen
      Participant

      No. Unfortunately it is currently not possible.

    • June 4, 2007 at 9:38 pm #24034
      Musicman75
      Member

      I thinks that's a feature many users could use.

      Is this a feature planned for future versions?

    • June 5, 2007 at 7:44 am #24035
      peterlaursen
      Participant

      We have no such plans.  We never encountered this request before.

      I don't think it will be very hard to implement however, so if it really is a common need/request we can discuss.

    • September 4, 2007 at 10:45 am #24036
      Marjolein Katsma
      Member
      peterlaursen wrote on Jun 5 2007, 09:44 AM:
      We have no such plans. We never encountered this request before.

      I don't think it will be very hard to implement however, so if it really is a common need/request we can discuss.

      I can see how this could be quite useful!

      In many cases applications during installation allow the user to create a set of tables for it in an existing database, and let them choose a table prefix to avoid name clashes within that database. Now install the application again (say, two different forums running the same software, or two different wikis), and if you still have a single database (or just want to keep all wikis together in a single database) you just choose a different prefix. Then consider some migration scenarios (test to live, or one server to another) and it's easy to end up with two sets of tables with exactly the same structure where table names differ by prefix.

      Regards,

    • September 4, 2007 at 11:02 am #24037
      peterlaursen
      Participant

      It is true that cheaper hosting plans often only give a user a single databse. Prefixing is then the common solution to keep some kind of structure when more aplications have tables in that database!

      Currently the same prefix will have to be used on every host!

    • September 4, 2007 at 3:18 pm #24038
      Marjolein Katsma
      Member
      peterlaursen wrote on Sep 4 2007, 01:02 PM:
      Currently the same prefix will have to be used on every host!

      I understand about “currently”. I was just giving a hint about a hopefully different future. 😛

    • September 4, 2007 at 8:18 pm #24039
      peterlaursen
      Participant

      Once we get trained reading as fast as you can write we will consider this … 😛

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