Depending on your need.
You could just write a filter to generate 1,000,000 GUIDs -- then copy
them over to MySQL.
Then -- pluck them off one at a time.
(There -- you get the exact GUID :)
(I like to throw out ideas -- that are crazy -- but would work --
kinda fun)
-John
On Dec 30, 2009, at 4:52 PM, Craig Carter wrote:
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:arslist@ARSLIST.ORG
] On Behalf Of Grooms, Frederick W
Sent: Wednesday, December 30, 2009 2:24 PM
To: arslist@ARSLIST.ORG
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:arslist@ARSLIST.ORG
] On Behalf Of Craig Carter
Sent: Wednesday, December 30, 2009 2:57 PM
To: arslist@ARSLIST.ORG
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:arslist@ARSLIST.ORG
] On Behalf Of tristan.rop...@t-online.de
Sent: Wednesday, December 30, 2009 1:49 PM
To: arslist@ARSLIST.ORG
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 <craig.car...@arpc.denver.af.mil>
To: arslist@ARSLIST.ORG
**
_Platinum Sponsor: rmisoluti...@verizon.net 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: rmisoluti...@verizon.net ARSlist: "Where the
Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"
--
John Sundberg
Kinetic Data, Inc.
"Building a Better Service Experience"
Recipient of the WWRUG09 Innovator of the Year Award
john.sundb...@kineticdata.com
651.556.0930 I www.kineticdata.com
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
