September 29, 2008 at 10:23 am
Guys,
I have 500 views in the database, some of these views are referenced by the other views.
I am trying to develop DDL script for all the views to be run in another database copy, but when I generate the DDL script for all the views from SQL Server Management Studio
it does not order by Parent (referenced) and Child (referring) views. Is there any to generate the DDL scripts for the views in right order (referenced views first).
Any suggestions and inputs might help
Thanks
September 29, 2008 at 10:44 am
Out of the box...No.
- you could search SSC for some scripts to help you out 😉
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61340/
http://www.sqlservercentral.com/scripts/Miscellaneous/31893/
- You could build your own SQLSMO application, generating dependent objects and then using the SMO script method to script out the views individually into a file.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply