• Since you want to do the "whole" db. Would it not be faster to just script all the tables and associated constraints & settings (or probably the whole DB), drop the old tables create new ones?

    I guess the potential pitfall is any internals (like hypotheticals) for performance are potentially lost but it could also be an improvement?