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

Multiple Queries In Migration Odbc Sql Query

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Multiple Queries In Migration Odbc Sql Query

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 5, 2006 at 10:09 pm #9839
      Tony
      Member

      I'm using the Migration Toolkit to import data fom an ODBC compliant data source (RETS) where the max number of records returned for any query is limitied to 2500.

      Fortunately the data source provides an OFFSET command. The first query would contain OFFSET 0, next OFFSET 2501, next OFFSET 5002, etc.

      Question is there anyway to do several queriers in the migration SQL?

    • September 5, 2006 at 10:31 pm #22280
      peterlaursen
      Participant

      You will have to build a batch file with more instances of the SJA like described here:

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

      Once you got one jobfile you can easily generate anotehr by 'search and replace' in a text editor.

      A more advance solution is to execute the SJA from within an aplication/a script that does a 'loop'. Inside this loop you will then basically have two statements

      1) execute SJA

      2) replace in the jobfile

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