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

Automate Table Copy To Several Servers

forums › forums › SQLyog › Using SQLyog › Automate Table Copy To Several Servers

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • November 13, 2015 at 11:15 pm #13442
      Mitch
      Participant

      I have a handful of tables that I regularly copy from one server to several others. Is there a way to streamline this to just a few clicks?

      Currently I have to

      1. Open the copy dialog

      2. Select the source server

      3. Select the source table(s)

      4. Select each destination server, click copy, wait for result

    • November 20, 2015 at 12:15 pm #35547
      Kartik Grover
      Spectator

      As of now there is no way to streamline this into any less no. of clicks.

    • November 20, 2015 at 3:46 pm #35548
      Mitch
      Participant

      Please consider this an Enhancement Request for this feature.  Here’s my wish list:

      • Be able to select multiple destination databases, spread across 1 or more servers

      • Initiate copy to all selected databases at once

      • Results of copy in a summary list or table, with ability to drill down to detailed results per database if desired

      • Ability to store the source database/tables and the destinations as a job and retrieve that job and re-execute later

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