September 5, 2003 at 10:41 am
I tried to copy a view from one server to another using DTS. Instead of creating the view, it created a table. Did I did something wrong? and can view be copied using DTS? Thank you.
September 6, 2003 at 2:02 am
This is a very annoying thing about DTS. It's tripped me up so many times.
I don't think you've done anything wrong, except assume - like I have - that DTS will copy view definitions as view definitions, and NOT materialise them as actual tables.
You may need to resort to the "copy objects" option to get the view definitions.
Cheers,
- Mark
Cheers,
- Mark
September 6, 2003 at 10:06 am
Yes, it is very annoying. Personally, I usually just cut & paste the source View query into a new View on the target server. A bit old fashioned, maybe, but it's still quick and easy.
September 12, 2003 at 4:55 pm
Thank you, guys. Copy Objects worked. I wonder why Microsoft name it 'Copy Table(s) 'and view(s)' if all you copy is tables...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply