SMO scripting

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • =?Utf-8?B?RGl2eWEgVmlqYXlhbg==?=

    SMO scripting

    Hi,
    I am creating a windows application in VS 2005 using C# and Sql Sever
    2005 as back end. It is for generating scripts for tables,views,st ored
    procedures and userdefineddata types. The main issue with this SMO scripting
    is it takes much time to generate script, compared to SQL-DMO. I have set
    SetDefaultInitF ields for smo objects, then also it takes nearly 45 minutes
    for scripting all smo objects. Please give me a solution as soon as possible.

    Thanks .
Working...