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

Bulk/duplicated Insert Of Data?

forums › forums › SQLyog › Using SQLyog › Bulk/duplicated Insert Of Data?

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • December 30, 2009 at 11:11 pm #30279
      peterlaursen
      Participant

      I understand that the data to be inserted in each of the 50 databases/tables are not the same? 

      What I can think of is using a scripting system to call SJA with different parameters and also call Windows system commands (copy file, rename file etc.).  Such scripting system could be 'Windows Powershell' (Vista/2008/7) or 'Windows Scripting host' (2K/2003/XP) – or just VB or a .NET language of course.

      Did you consider putting all data into one table and just add one column identifying the state? That would be easier, I believe. But also generating one jobfile and generating 50 new using 'search and replace' will probably not take much time). Next generate a batch file of 50 jobs and execute the batch file.

      BTW: has US now 'shrunk' to 50 states? My personal opinion: keep it going! 🙂 

      (but not sure if we would be happy to get Nebraska back as a Danish province – it almost was 110 years ago!) 🙂 

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