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

Add Extra Fields While Importing Data?

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Add Extra Fields While Importing Data?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • April 5, 2006 at 4:49 pm #21168
      peterlaursen
      Participant

      the best way would be .. I think …

      1) Run the Migration

      2) ALTER TABLE

      if you want it fully automated you can create a batch file that 1)first executes a SJA-importjob 2)next executes a SJA-notify job doing the ALTER TABLE.

      just like

      *******************

      sja myimportjob.xml

      sja mynotifyjob.xml

      *******************

      http://www.webyog.com/faq/27_35_en.html

    • April 5, 2006 at 6:27 pm #21169
      TGKnIght
      Member

      Ahh nice, the batch file suggestion is what I need…

      I'll try to import the client data as is to a temp table, then run a second job which will populate the production table correctly.

      Thanks alot!

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.