Re: Moving/copying data from one server to another...
Although copying the DB does not physically move the MAC ID, it will move the server license key associated with the copied servers Host ID (MAC). This is easily fixed by adding the correct license after the copy. If you plan to do this regularly, you can add both the prod and dev server license keys to the prod server. Then when the DB is copied it will ignore the incorrect key and use the correct dev key. Todd Arner Great Lakes From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 4:10 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** -- Coping a database doesnt copy the mac ID.. as long as the database is free of any hard coded server references, it should work. And off course the versions should match both of the ARS server and the database.. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 3:49:54 PM Subject: Re: Moving/copying data from one server to another... -- The server is local - about 20 feet away. I was told that copying via an SQL database copy wouldn't work due to mac addresses being copied from the old to the new database, etc. - hence it seemed like Migrator would be the way to gobut that's a guess - hence asking on the list. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions...such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
That is correct. And even if there is a license with a wrong MAC Id in the License form, the system will ignore that license. It only looks for a license that matches its own host ID. That is how the server picks up the right license in case of a server group. Joe From: Arner, Todd tar...@glhec.org To: arslist@ARSLIST.ORG Sent: Wed, July 28, 2010 7:55:49 AM Subject: Re: Moving/copying data from one server to another... ** Although copying the DB does not physically move the MAC ID, it will move the server license key associated with the copied servers Host ID (MAC). This is easily fixed by adding the correct license after the copy. If you plan to do this regularly, you can add both the prod and dev server license keys to the prod server. Then when the DB is copied it will ignore the incorrect key and use the correct dev key. Todd Arner Great Lakes From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 4:10 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** -- Coping a database doesnt copy the mac ID.. as long as the database is free of any hard coded server references, it should work. And off course the versions should match both of the ARS server and the database.. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 3:49:54 PM Subject: Re: Moving/copying data from one server to another... -- The server is local – about 20 feet away. I was told that copying via an SQL database copy wouldn’t work due to mac addresses being copied from theold to the new database, etc. – hence it seemed like Migrator would be the way to go….but that’s a guess– hence asking on the list….. From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From:Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ The information contained in this communication may be confidential, is intended only for the use of the recipient(s) named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please notify the sender immediately and destroy or delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10
Re: Moving/copying data from one server to another...
A couple questions. OS, Database, and ARS level? Darrell Reading Systems Engineer Phone 479.204.5739 dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: Tuesday, July 27, 2010 12:42 To: arslist@ARSLIST.ORG Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions...such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. *** Walmart Confidential *** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
Also . Is this a one-time copy on an ongoing thing (daily/weekly/monthly/.)? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Darrell Reading Sent: Tuesday, July 27, 2010 12:54 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... A couple questions. OS, Database, and ARS level? Darrell Reading Systems Engineer Phone 479.204.5739 dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: Tuesday, July 27, 2010 12:42 To: arslist@ARSLIST.ORG Subject: Moving/copying data from one server to another... We need to copy data from one server to another but have a few questions.such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
Windows 2003 server MS Sql 2005 AR 7.5 patch 01 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Darrell Reading Sent: Tuesday, July 27, 2010 1:54 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** A couple questions. OS, Database, and ARS level? Darrell Reading Systems Engineer Phone 479.204.5739 dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: Tuesday, July 27, 2010 12:42 To: arslist@ARSLIST.ORG Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions...such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. *** Walmart Confidential *** _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
One time, but the way that things tend to go it may be biweekly from production to development test server. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Tuesday, July 27, 2010 2:02 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... Also . Is this a one-time copy on an ongoing thing (daily/weekly/monthly/.)? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Darrell Reading Sent: Tuesday, July 27, 2010 12:54 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... A couple questions. OS, Database, and ARS level? Darrell Reading Systems Engineer Phone 479.204.5739 dere...@wal-mart.com Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: Tuesday, July 27, 2010 12:42 To: arslist@ARSLIST.ORG Subject: Moving/copying data from one server to another... We need to copy data from one server to another but have a few questions.such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
Richard, There are plenty of ways to do this. One of them is implementing DSO (Distributed Server Object) server. Based on configuration, DSO can move data from 1 server to another instantaneously. More information can be found in 6.3 documentation(DSOAdminGuide-630.pdf). Thanks Chintan. --- On Tue, 7/27/10, Richard Copits richard@bwc.state.oh.us wrote: From: Richard Copits richard@bwc.state.oh.us Subject: Moving/copying data from one server to another... To: arslist@ARSLIST.ORG Date: Tuesday, July 27, 2010, 10:42 AM ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
Will that work with a 7.5 database? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chintan Shah Sent: Tuesday, July 27, 2010 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, There are plenty of ways to do this. One of them is implementing DSO (Distributed Server Object) server. Based on configuration, DSO can move data from 1 server to another instantaneously. More information can be found in 6.3 documentation(DSOAdminGuide-630.pdf). Thanks Chintan. --- On Tue, 7/27/10, Richard Copits richard@bwc.state.oh.us wrote: From: Richard Copits richard@bwc.state.oh.us Subject: Moving/copying data from one server to another... To: arslist@ARSLIST.ORG Date: Tuesday, July 27, 2010, 10:42 AM ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message.
Re: Moving/copying data from one server to another...
Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
The server is local – about 20 feet away. I was told that copying via an SQL database copy wouldn’t work due to mac addresses being copied from the old to the new database, etc. – hence it seemed like Migrator would be the way to go….but that’s a guess – hence asking on the list….. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From: Richard Copits richard@bwc.state.oh.usmailto:richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message.
Re: Moving/copying data from one server to another...
If you check the archives you will see lots of threads on db copying. Personally, that would be my 1st choice for this type of replication. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: Tuesday, July 27, 2010 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... The server is local – about 20 feet away. I was told that copying via an SQL database copy wouldn’t work due to mac addresses being copied from the old to the new database, etc. – hence it seemed like Migrator would be the way to go….but that’s a guess – hence asking on the list….. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From: Richard Copits richard@bwc.state.oh.usmailto:richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated…..
Re: Moving/copying data from one server to another...
Joe, I once used DSO to keep my reporting server up to date J…..so it’s not necessarily just for follow the sun J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 1:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe _ From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. _ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
Already done….just looking for current/recent experiences….thanks anyway…. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Tuesday, July 27, 2010 4:16 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... If you check the archives you will see lots of threads on db copying. Personally, that would be my 1st choice for this type of replication. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: Tuesday, July 27, 2010 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... The server is local – about 20 feet away. I was told that copying via an SQL database copy wouldn’t work due to mac addresses being copied from the old to the new database, etc. – hence it seemed like Migrator would be the way to go….but that’s a guess – hence asking on the list….. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From: Richard Copits richard@bwc.state.oh.usmailto:richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message.
Re: Moving/copying data from one server to another...
Coping a database doesnt copy the mac ID.. as long as the database is free of any hard coded server references, it should work. And off course the versions should match both of the ARS server and the database.. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 3:49:54 PM Subject: Re: Moving/copying data from one server to another... The server is local – about 20 feet away. I was told that copying via an SQL database copy wouldn’t work due to mac addresses being copied from theold to the new database, etc. – hence it seemed like Migrator would be the way to go….but that’s a guess– hence asking on the list….. From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From:Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
We do a P to V (Physical to VM) every once in a while. It’s not the kind of thing you want to do every week, but it does create an exactly replica of the production environment. Once the VM is up running, we have a checklist of things to edit like ar.cfg, armonitor.cfg, emaildeaemon.properties, etc. Look for both server name and the IP address. We also have to uninstall and re-install AIE. HTH, Rebecca From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 5:10 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Coping a database doesnt copy the mac ID.. as long as the database is free of any hard coded server references, it should work. And off course the versions should match both of the ARS server and the database.. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 3:49:54 PM Subject: Re: Moving/copying data from one server to another... The server is local – about 20 feet away. I was told that copying via an SQL database copy wouldn’t work due to mac addresses being copied from the old to the new database, etc. – hence it seemed like Migrator would be the way to go….but that’s a guess – hence asking on the list….. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_
Re: Moving/copying data from one server to another...
Hi, Do have a look at RRR|Chive. It can do incremental data transfers of the forms you need (probably most forms but not all) very quickly. https://www.rrr.se/cgi/rrrchive/rrrchive https://www.rrr.se/cgi/rrrchive/config https://www.rrr.se/c/doc/rrrchive/ Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. We need to copy data from one server to another but have a few questions...such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
That is an innovative use of it :-) Joe From: LJ LongWing lj.longw...@gmail.com To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 4:19:29 PM Subject: Re: Moving/copying data from one server to another... ** Joe, I once used DSO to keep my reporting server up to date J…..so it’s not necessarily just for follow the sun J From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 1:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From:Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
We have stared using Meta-Update for transferring (and transforming) data. You can script record updates, creates and deletes (say if the record no longer exists in the source server). It is nice to have the ability to do more traditional loops and if then else statements and still use the Remedy API. Jason On Tue, Jul 27, 2010 at 10:42 AM, Richard Copits richard@bwc.state.oh.us wrote: ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. -- Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
Like Fred, I'd second DB replication too.. There may be server names that 'accidentally' gets hard-coded into the definitions.. There may also be some server names embedded in configuration data like AIE, Help Files configuration in the application properties form, etc.. The process for removing these can be scripted, and perfected over a few iterations if you choose to remove these using DB scripts.. Joe From: Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 4:20:39 PM Subject: Re: Moving/copying data from one server to another... Already done….just looking for current/recent experiences….thanks anyway…. From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Tuesday, July 27, 2010 4:16 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... If you check the archives you will see lots of threads on db copying. Personally, that would be my 1st choice for this type of replication. From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Richard Copits Sent: Tuesday, July 27, 2010 2:50 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... The server is local – about 20 feet away. I was told that copying via an SQL database copy wouldn’t work due to mac addresses being copied from the old to the new database, etc. – hence it seemed like Migrator would be the way to go….but that’s a guess – hence asking on the list….. From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, July 27, 2010 3:45 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, What is the purpose of copying this data? Depending on that your tools and hence the method would vary.. DSO is for copying data to 'follow the sun' to ensure business continuity irrespective of the time locally in case you have global operations. DB / system Replication is another alternative. For replication there is more than one method and your choice really depends on the resources available. Joe From:Richard Copits richard@bwc.state.oh.us To: arslist@ARSLIST.ORG Sent: Tue, July 27, 2010 1:42:07 PM Subject: Moving/copying data from one server to another... ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Moving/copying data from one server to another...
Yes. --- On Tue, 7/27/10, Richard Copits richard@bwc.state.oh.us wrote: From: Richard Copits richard@bwc.state.oh.us Subject: Re: Moving/copying data from one server to another... To: arslist@ARSLIST.ORG Date: Tuesday, July 27, 2010, 11:51 AM Will that work with a 7.5 database? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chintan Shah Sent: Tuesday, July 27, 2010 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: Moving/copying data from one server to another... ** Richard, There are plenty of ways to do this. One of them is implementing DSO (Distributed Server Object) server. Based on configuration, DSO can move data from 1 server to another instantaneously. More information can be found in 6.3 documentation(DSOAdminGuide-630.pdf). Thanks Chintan. --- On Tue, 7/27/10, Richard Copits richard@bwc.state.oh.us wrote: From: Richard Copits richard@bwc.state.oh.us Subject: Moving/copying data from one server to another... To: arslist@ARSLIST.ORG Date: Tuesday, July 27, 2010, 10:42 AM ** We need to copy data from one server to another but have a few questions…such as is the migrator robust/reliable enough to do it, and at what version and patch level? Is there a specific procedure that we need to follow/a particular order to have the best chance for success? Any/all help/suggestions/cautions are appreciated….. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are