HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Copying View in Management Studio

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
managementcopyingviewstudio

Problem

I want to copy a VIEW from one server to another. I could copy tables but I can't copy views. Is there a way to do so?
Thanks

Solution

The easiest way if you just want to do a quick CREATE VIEW on your destination server would be to script it out:

  • Right-click your view



  • Script View as -> CREATE to -> (select your choice here)



The possible choices as a destination for the CREATE VIEW script can be a new query window, a file, the clipboard, or an agent job. If you need to run this create script at a later date, the file destination is probably your best bet. But if you want to run it immediately, and you have access to the server, just script it to a new query window and connect to your destination instance/database and run the CREATE VIEW script.

Context

StackExchange Database Administrators Q#22137, answer score: 6

Revisions (0)

No revisions yet.