Exporting views

I'm trying to export views from one server to another but
it exports views as tables...
Any suggestion?
Thanx in advance
MartynCould you explain what you're doing? SQL Server doesn't export views as
tables. What tool are you using?
Did yuo try to simply script the views using the Generate SQL Script option
from SQL Enterprise Manager?
--
Brian
"Martyn" <anonymous@.discussions.microsoft.com> wrote in message
news:047601c399d3$8a962230$a601280a@.phx.gbl...
> I'm trying to export views from one server to another but
> it exports views as tables...
> Any suggestion?
> Thanx in advance
> Martyn|||I used SQL Server2000 Enterprise mangaer.
From one server, I selected export data and copy tables
and views option. Then selected 4 views which lies in
view folder but it exported as table at the destination
server.
>--Original Message--
>Could you explain what you're doing? SQL Server doesn't
export views as
>tables. What tool are you using?
>Did yuo try to simply script the views using the
Generate SQL Script option
>from SQL Enterprise Manager?
>--
>Brian
>
>"Martyn" <anonymous@.discussions.microsoft.com> wrote in
message
>news:047601c399d3$8a962230$a601280a@.phx.gbl...
>> I'm trying to export views from one server to another
but
>> it exports views as tables...
>> Any suggestion?
>> Thanx in advance
>> Martyn
>
>.
>|||It sounds like you might be doing this using the DTS Export
Wizard. When the dialog box comes up to select what to copy
and you select the option for "copy table(s) and view(s)
from the source database, you will be copying data not
copying objects. If you need the views to be copied as views
- not just the data - you need to use the option for "copy
objects and data between SQL Server databases"
-Sue
On Thu, 23 Oct 2003 19:43:43 -0700, "Martyn"
<anonymous@.discussions.microsoft.com> wrote:
>I used SQL Server2000 Enterprise mangaer.
>From one server, I selected export data and copy tables
>and views option. Then selected 4 views which lies in
>view folder but it exported as table at the destination
>server.
>>--Original Message--
>>Could you explain what you're doing? SQL Server doesn't
>export views as
>>tables. What tool are you using?
>>Did yuo try to simply script the views using the
>Generate SQL Script option
>>from SQL Enterprise Manager?
>>--
>>Brian
>>
>>"Martyn" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:047601c399d3$8a962230$a601280a@.phx.gbl...
>> I'm trying to export views from one server to another
>but
>> it exports views as tables...
>> Any suggestion?
>> Thanx in advance
>> Martyn
>>
>>.