 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008How 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 > 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 > [quoted text clipped - 12 lines] >> >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 > What is SSIS? > How can I do that? [quoted text clipped - 16 lines] > >> >I want to copy some views (not data) from one server to another. > >> > How can I do that? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.