Re: Migrating data from DEV to QA
** Hi, Will I be able load the data using the data load wizard. Clean up the data, and then export out selected foundation data records from DEV into QA? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Goodall, Andrew C Sent: Friday, July 20, 2012 1:35 PM To: arslist@ARSLIST.ORG Subject: Re: Migrating data from DEV to QA ** 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_ _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
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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Migrating data from DEV to QA
** We have DEV and QA already in place. We want to copy the foundation data from DEV to QA and modify the configuration data for multi-tenancy to support multiple companies. Just not 100% sure what the gotchas are and what the best approach is. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Wednesday, July 18, 2012 7:14 PM To: arslist@ARSLIST.ORG Subject: Re: Migrating data from DEV to QA ** For our initial QA build we restored a db backup of DEV after installing ARS. There were a number of forms that needed server references updated. Jason On Wed, Jul 18, 2012 at 2:09 PM, ravi rai ravira...@hotmail.com wrote: ** We used RRRchive tool. Ravi _ Date: Wed, 18 Jul 2012 16:58:48 -0400 From: ago...@jcp.com Subject: Re: Migrating data from DEV to QA To: arslist@ARSLIST.ORG ** 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_ _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
Re: Migrating data from DEV to QA
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
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_ font face=monospacesize=-3brThe information transmitted is intended only for the person or entity to which it is addressed and brmay contain confidential and/or privileged material. If the reader of this message is not the intendedbrrecipient, you are hereby notified that your access is unauthorized, and any review, dissemination,brdistribution or copying of this message including any attachments is strictly prohibited. If you are notbrthe intended recipient, please contact the sender and delete the material from any computer.br ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Migrating data from DEV to QA
We used RRRchive tool. Ravi Date: Wed, 18 Jul 2012 16:58:48 -0400 From: ago...@jcp.com Subject: Re: Migrating data from DEV to QA To: arslist@ARSLIST.ORG ** 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are