pdxJaxon


I'm trying to use the Generate Script Wizard to generate scripts for a relatively small DB.

I basically follow the same steps I would have in Sql 2k to generate the scripts but in 2k5 this takes FOREVER.

In fact, it's taking so long that I've stopped it every time (never has completed)

I have sp2 installed.

anyone else having this issue or am I an isolated case

basically, from what I can tell, the tool is completely unusable.

Greg Jackson

Portland, OR





Re: Generate Script Wizard takes FOREVER (SQL 2k5)

danschl


I have the same problem with a bigger database with about 1000 sp's and 1000 tables

in sql2000 it took about 15 minutes to script out, now it takes over and hour.

Plus if you watch the server it is hammering the server to 30 to 40 percent utilization

I have broken down the scripting to tables, then script views, then script sp'

It appears that if i change to sql2000 compatible scripts it runs some faster

and if you create drops, and rights it can add another 15 to 20 minutes