patternsqlMinor
Copying View in Management Studio
Viewed 0 times
managementcopyingviewstudio
Problem
I want to copy a
Thanks
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
The possible choices as a destination for the
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.