>Hello all. I am currently re-writing some legacy VFP apps into .NET web applications.
>My current problem exists with migrating over legacy data into SQL server.
>Most of these tables use character based prime keys, and are auto-incremented with the MM newid function using IncrementBase36.
>
>Since these prime keys are deployed into user data, there is no easy way to completely eliminate them until they are gradually phased out. As such, I am trying to use both a new integer based system and replicate any necessary legacy structure in SQL Server. Has anyone had any experience with writing a new equivalent for IncrementBase36?
>Thanks.
Have you tried using uniqueidentifier?
If it's not broken, fix it until it is.
My Blog