Converting table PK from INT to GUID in SQL Server 2005

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

LVL 19
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
that's the way to go. you need a "mapping" table of the INT and the GUID table, and update from there.
elimesikaAuthor Commented:
Thanks angelIII, bad news for me, but I will go for it ....
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.