Linchi Shea : SMO, Performance

Performance impact: Speeding up SMO script generation – the test code

Linchi Shea — Tue, 15 Dec 2009 19:10:00 GMT

The attached is the C# code that I used for generating the test results charted in my previous post . Note that for testing no generated script is actually persisted into a file by this program. The Script() method is applied, but the resulting script...(read more)

Performance impact: Speeding up SMO script generation

Linchi Shea — Sun, 13 Dec 2009 22:18:00 GMT

Generating scripts through SMO can be as simple as walking down the database object tree and applying the Script() method to each scriptable object. Well, that is until you start to try it on a database that has a large number of objects (say a few thousands),...(read more)