Information générale
Catégorie:
Bases de données
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.
>
>Have you tried using uniqueidentifier?
I thought uniqueidentifier only returned a 16 digit GUID. I need to increment an existing range - example 00001A to 00001B.
Précédent
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