Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Views(script) migrating Expand / Collapse
Author
Message
Posted Friday, September 05, 2008 3:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 11:45 AM
Points: 12, Visits: 159
Is there any wizard to migrate views(script) from one database to another database
Post #564405
Posted Friday, September 05, 2008 7:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 5:31 AM
Points: 10,910, Visits: 12,548
Sure right-click the database select Tasks (Or All tasks) -> Generate Scripts. As you walk through the wizard just select script views.



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #564540
Posted Sunday, September 07, 2008 10:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 11:45 AM
Points: 12, Visits: 159
Thanks for replay.........
I already konw this procedure.I want to the wizard which will actomatically migrata the views(Script) not data from one instance to another instance.
Post #565203
Posted Sunday, September 07, 2008 11:41 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Friday, March 28, 2014 2:25 PM
Points: 9,902, Visits: 9,479
anand (9/7/2008)
Thanks for replay.........
I already konw this procedure.I want to the wizard which will actomatically migrata the views(Script) not data from one instance to another instance.


What Jack told you is how to do this.


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #565217
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse