General information
Title:
Converting IncrementBase36 to SQL Server
Environment versions
Network:
Windows 2008 Server
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only