Generating a .NET SqlSMOObject from INFORMATION_SCHEMA information

• Babu Mannaravalappil

  Mr or Mrs. 500

  Points: 519

  More actions

  September 29, 2007 at 12:46 pm

  #181979

  Hi All,

  Is there a way to generate a "URN" out of IFORMATION_SCHEMA resultset? (or system objects, for that matter). I need to generate SMO objects for a Database. Doing it purely using the SMO namespace is horribly slow. In my test, it took almost two hours before I could build a complete tree structure for every single object in the database. Retrieving the schema info with INFORMATION_SCHEMA is a snap. But I still need to populate my tree with SMO objects. The only way I know to create a SMO object is by passing an "URN" parameter to the Server.GetSmoObject() method. Can somebody help me with this issue please?

  Babu.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 29, 2007 at 12:50 pm

  #737409

  As suggested by someone else. DROP SMO ALTOGETHER. You have to do all of this manually if you want performance. Believe I've been there.