Skip to Content
author's profile photo Former Member
Former Member

Query to extract marketing documents to be used in the DTW upload

HI experts,

I would like to ask if anyone of you has already extracted some transactions / marketing documents from one database going to another database? I have to copy/duplicate the Sales/Purchases/Production/Payment transactions from one database to another for a specific date range only, is there a query I can use to extract only selected transactions and copy them in a DTW templates so that it can be uploaded on the new database.

Thanks in advance,


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2014 at 05:48 PM

    Hi Maria,

    Selected Transaction means what?

    Do you need transaction list for a particular period range?



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Maria,

      Extracting transactions isn't enought to reimport them correctly:

      • First you have to ensure that the definitions of both databases are the same, else it will fail,
      • Second, the links between documents have to be recreated while importing: so a static query won't do the job.

      I did it once for a customer in Algeria in 2009 (and have to redo it these days), and I can assure you this is not an easy task.

      On that time, the company for which I did it didn't want to ear anything about addon, but by far this is a much earcier job to do by programming than by pure SQL.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.