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

Inserting new rows ONLY

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Inserting new rows ONLY

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • November 22, 2004 at 2:50 pm #8664
      jdhr
      Member

      Hi,

      Does anyone know how can I configure an XML schema for SJA to INSERT ONLY (new rows) into the target DB?

      Thanks a lot,

    • November 22, 2004 at 5:54 pm #16577
      Ritesh
      Member

      Currently, this feature is not available in SJA.

    • November 25, 2004 at 4:34 pm #16578
      Erik
      Member

      Maybe you can add a timestamp / date column in your source DB and construct a XML script with a sqlwhere tag like :

      Code:
      date = CURDATE()

      or something similar. This will only get the rows with date = today. You'll just have to run the script daily 😉

      Hth

    • November 25, 2004 at 6:19 pm #16579
      Ritesh
      Member

      Sounds cool 🙄

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