Hello,

this is what I'm trying to do:

I have a database source2000 that I used to copy on the same sql2k (or
other sql2k) server to dest2000 with Enterprise Manager import/export.

Then I exported the source2000 in sql2k to source2005 in SQLServer
2005 using Management  Studio.

Now I'm trying to export source2005 to dest2005, both in SQLServer2005
with Export wizard of Management studio.
This takes a lifetime, 10/20 more time than doing the same operation
with Enterprise manager with sql2k.

What am I doing wrong?

Please don't suggest me to copy in other ways, this is the way I must
use, because sometimes I copy only certain tables.

Thanks,
Mattia

error importing data from Access to SQL Server
Upgrade connection issues
View results of Dynamic SQL in Management Studio
What does this mean?
install Performance Tools