Converting table PK from INT to GUID in SQL Server 2005

Posted on 2008-11-12
Last Modified: 2012-05-05
I need to convert production database table PK from INT to GUID.
The table PK is a FK in other database tables.

I have found this solution:

But, it seems too much complicated and risky.

I will be glad to accept any simpler & safe solution

Question by:elimesika
    LVL 142

    Accepted Solution

    that's the way to go. you need a "mapping" table of the INT and the GUID table, and update from there.
    LVL 19

    Author Closing Comment

    Thanks angelIII, bad news for me, but I will go for it ....

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now