| Author |
Topic |
|
RAVEman
Starting Member
4 Posts |
 Posted - 2008-06-10 : 07:21:47
|
| i was using sql 2000, the database contains 500+ tables, 3000+ sp.i moved to sql 2005 and found problem on generating script (right click database -> tasks -> generate scripts).i need to generate the table relations.... it is very very slow compared to sql 2000 which is done in about 30 seconds to few minutes.i already tried many ways including set options to false which in my thought could speed up a lot...but still very slow.average generate script time with sql 2005 (sp 2): 70-90 minutes.average generate script time with sql 2000 (sp 4): 2-3 minutes.can anyone tell why ? thx in advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-10 : 07:24:33
|
Are you using same settings? Like including DROP statements and other settings.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
RAVEman
Starting Member
4 Posts |
Posted - 2008-06-10 : 09:41:23
|
| i use default settings of "Generate Scripts..." wizard |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-10 : 19:29:42
|
| Yes it is slow in SQL 2005. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
RAVEman
Starting Member
4 Posts |
Posted - 2008-06-11 : 03:17:29
|
| But is there any standart tweak to increase the speed of it? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
RAVEman
Starting Member
4 Posts |
Posted - 2008-06-11 : 11:25:18
|
| i haven't deal with ms sql server 2008, but is there the same problems with script generation? |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2008-08-15 : 16:41:32
|
| Sorry to chime in so late on this topic, but you're not alone. We can't stand the tool. How in the world Microsoft could consider this performance acceptable is beyond us. I'll be calling MS next week to complain. To script a 5GB database takes about 2 hours, depending on the number of objects in the database. Then it gets really bad if you determine you want to add or remove an option from the script and you have to re-run it (another 2 hour delay). It also hits the CPU fairly hard. It will be interesting to hear their reasoning. I'll also be bring this to the attention of our Microsoft TAM and give everyone an update once I know more. Are there other scripting tools to consider purchasing? Dave |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
VERY Slow generate scripts on SQL 2005 compared to