I have a SQL Server 2000 database with several tables that use a social
security number as a primary key. I am working to update this system to no longer use social
security numbers as a key, but to instead use another assigned number. What would be the best way
to update the existing records in the database with the new key?
Requires Free Membership to View
Create a mapping table that maps the old ID to the new ID, generate a new ID for each one, and then use that to populate your new column to ensure all of the relationships come across intact.
For More Information
- Dozens more answers to tough SQL Server questions from Michael Hotek are available here.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in April 2003
Join the conversationComment
Share
Comments
Results
Contribute to the conversation