Hello,

So I finally gave in to all the good advice about uniqueidentifiers and need to reorganize my database using ints in all the primary and foreign keys.

Anyone have any good advice about how to go about such a refactoring?

Right now I'm at a good point: not yet in production, only a few tables with data, none more than 100K rows.

I'm hoping for suggestions that include links to refactoring scripts.

I also am using Visual Studio 2008 Database version but I'm concerned it may be a bit clumsy for major refactoring in this (early) SP1 incarnation.

Thanks,

Kimball