How to copy views between servers?

I want to copy some views (not data) from one server to another.
How can I do that?Sorry! I am using Sqlserver 2005
"ad" <flying@.wfes.tcc.edu.tw> ¼¶¼g©ó¶l¥ó·s»D:ePT0y4ZhIHA.3940@.TK2MSFTNGP05.phx.gbl...
>I want to copy some views (not data) from one server to another.
> How can I do that?
>|||Hi
Probably the easiest way is to script them and run the scripts. If you are
using version control you could just run the scripts you have already
(assuming they are autonomous).
Alternatively you can use SSIS and a "transfer object" task or SMO.
John
"ad" wrote:
> Sorry! I am using Sqlserver 2005
> "ad" <flying@.wfes.tcc.edu.tw> ¼¶¼g©ó¶l¥ó·s»D:ePT0y4ZhIHA.3940@.TK2MSFTNGP05.phx.gbl...
> >I want to copy some views (not data) from one server to another.
> > How can I do that?
> >
>
>|||What is SSIS?
How can I do that?
"John Bell" <jbellnewsposts@.hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:8C605E23-915D-4E44-9626-1E720FA3BE2F@.microsoft.com...
> Hi
> Probably the easiest way is to script them and run the scripts. If you are
> using version control you could just run the scripts you have already
> (assuming they are autonomous).
> Alternatively you can use SSIS and a "transfer object" task or SMO.
> John
> "ad" wrote:
>> Sorry! I am using Sqlserver 2005
>> "ad" <flying@.wfes.tcc.edu.tw> ?gco?l¢Do¡Ps?D:ePT0y4ZhIHA.3940@.TK2MSFTNGP05.phx.gbl...
>> >I want to copy some views (not data) from one server to another.
>> > How can I do that?
>> >
>>|||Hi
SSIS is SQL Server Integration Services, it is only available on the
Standard and Enterprise Editions and you use SQL Server Business Intelligence
Development Studio (BIDS) to write the packages. You have not said which
version of SQL Server you are using! If you are on Express or Workgroup you
would need to script the procedures or use SMO. If you don't have Books
Online it can be downloaded from
http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en
This has sections on SMO (just look it up in the index!)
John
"ad" wrote:
> What is SSIS?
> How can I do that?
> "John Bell" <jbellnewsposts@.hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:8C605E23-915D-4E44-9626-1E720FA3BE2F@.microsoft.com...
> > Hi
> >
> > Probably the easiest way is to script them and run the scripts. If you are
> > using version control you could just run the scripts you have already
> > (assuming they are autonomous).
> >
> > Alternatively you can use SSIS and a "transfer object" task or SMO.
> >
> > John
> >
> > "ad" wrote:
> >
> >> Sorry! I am using Sqlserver 2005
> >>
> >> "ad" <flying@.wfes.tcc.edu.tw> ?gco?l¢Do¡Ps?D:ePT0y4ZhIHA.3940@.TK2MSFTNGP05.phx.gbl...
> >>
> >> >I want to copy some views (not data) from one server to another.
> >> > How can I do that?
> >> >
> >>
> >>
> >>
>
>