Yes you would need to delete from or truncate the tables specified on the target in the sql before starting.
Not sure it is the best, but it sure was quick from my standpoint. I used it to stand up a fresh DEV and QA environment. >From what I hear the RRR | Chive is pretty good at keeping the data in sync, else you might want to look at DDM. Regards, Andrew C. Goodall Software Engineer Development Services ago...@jcpenney.com jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of KathyMorris Sent: Friday, July 20, 2012 12:25 PM To: arslist@arslist.org Subject: Re: Migrating data from DEV to QA ** How can this be done via the dataload, without cleaning up the data or DEV, then re-cleaning the data on QA? Is this the best and quickest way to replicate foundation data from DEV to QA? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Goodall, Andrew C Sent: Wednesday, July 18, 2012 4:59 PM To: arslist@ARSLIST.ORG Subject: Re: Migrating data from DEV to QA ** The data load wizard See if this helps: https://communities.bmc.com/communities/docs/DOC-14224 This contains SQL statements for SQL server that will enable you to cut and paste your foundation data into the load spreadsheets. Regards, Andrew C. Goodall Software Engineer Development Services ago...@jcpenney.com jcpenney 6501 Legacy Drive Plano, TX 75024 jcp.com From: Action Request System discussion list(ARSList) [mailto:arslist@arslist.org] On Behalf Of KathyMorris Sent: Wednesday, July 18, 2012 3:31 PM To: arslist@arslist.org Subject: Migrating data from DEV to QA ** Hi, On 7.6.4, we are going to copy the foundation data from DEV to QA . We are also using multi-tenancy. What is the best method to do this? How do we get our foundation data safely over to QA without messing up data? Are there any major things that we should be really careful of? _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"