Information générale
Catégorie:
Bases de données
Titre:
Converting IncrementBase36 to SQL Server
Versions des environnements
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement