Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eurob
Posting Yak Master
100 Posts |
 Posted - 2006-05-03 : 10:19:32
|
Using a DTS 'Copy Objects] I copied objects from a database between two servers.When I do a select myField from myView on the destination serverit takes 3 minutes, whereas on the source server it took 0 seconds.What can I do to fix this ?robert |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-03 : 10:21:43
|
| Did you copy the indexes?If so then update statistics and if no joy compare the two query plans.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
eurob
Posting Yak Master
100 Posts |
Posted - 2006-05-03 : 10:50:33
|
| I did, but I discovered why it doesn't work right. It copied the views to the destination but created them as tables. Is this some bug in the DTS tool ?robert |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-03 : 12:40:37
|
| I think it's considered a feature.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
eurob
Posting Yak Master
100 Posts |
Posted - 2006-05-03 : 14:13:14
|
| I wonder where I can disable that feature.robert |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-03 : 14:16:48
|
| I would redo everything. Instead of using DTS to copy your objects, use BACKUP DATABASE on the source server, copy the file to the destination server, then use RESTORE DATABASE on the destination server. This gives you an identical copy of the database. Then you'd need to create the logins since they are contained in master. You can use this:http://www.sqlmag.com/articles/index.cfm?articleid=16090&Tara Kizeraka tduggan |
|
|
|
eurob
Posting Yak Master
100 Posts |
Posted - 2006-05-03 : 14:19:36
|
| Thanks,I'll give it a try.robert |
|
|
|
|
|
|
Performance issue after copy objects