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 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"_ -------------------------------------------------------------------------------- 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"