Converting table PK from INT to GUID in SQL Server 2005

HI
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:
http://beyondthispoint.blogspot.com/2007/04/converting-primary-key-type-in-sql.html

But, it seems too much complicated and risky.

I will be glad to accept any simpler & safe solution

Thanks
LVL 19
elimesikaAsked:
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.
0
 
elimesikaAuthor Commented:
Thanks angelIII, bad news for me, but I will go for it ....
0
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.