We were primarily trying to keep consistency between the million or so records we already have with the old format that will still be there. We'll investigate the UUID function on MySQL and see if that will work. Having never used MySQL, I wasn't aware that existed.
Craig Carter Information Technology Manager, RSP -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Wednesday, December 30, 2009 2:24 PM To: [email protected] Subject: Re: Q: GUID Generation I'm not exactly clear why you need to use Remedy's GUID. On MS SQL server you could use the NewID() function to generate a unique ID On MySQL you can use UUID() function Either one of those will give you a "Unique" ID to work with. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Craig Carter Sent: Wednesday, December 30, 2009 2:57 PM To: [email protected] Subject: Re: Q: GUID Generation We're actually on SQL Server and they are on MySQL and we can't use a simple sequencer anyway. After reviewing GUID and UUID, there are several variances on this and I'd like to basically duplicate what the BMC/Remedy function does rather than have them call a Remedy web service and pass one back. We're basically migrating certain processes to another system but keeping them integrated so it would be easier if their system could generate a like value going forward. Craig Carter Information Technology Manager, RSP -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, December 30, 2009 1:49 PM To: [email protected] Subject: Re: Q: GUID Generation ** Hi, I don´t know, what you want to do with this information. But you can also use the sequence generation function of the database (Oracle). Cheers Tristan -----Original Message----- Date: Wed, 30 Dec 2009 21:28:07 +0100 Subject: Q: GUID Generation From: Craig Carter <[email protected]> To: [email protected] ** _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ Anyone know if the actual code behind "Application_Generate_GUID" is available anywhere? We need to try and duplicate this functionality in a different system for integration purposes and wondered if this information is available anywhere? Regards, Craig Carter Information Technology Manager, RSP _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
