SQL Scripting

• Thomas Foster-Baker

  SSChasing Mays

  Points: 616

  More actions

  October 28, 2005 at 2:14 am

  #166115

  How do I script a SQL Server database when procedures are programmed alphabetically if views reference other views that are alphabetically later they will not be created when the script is run.

  Is there a method of sorting the views without having to resort to manual labour.

• Johan Bijnens

  SSC Guru

  Points: 135446

  More actions

  October 28, 2005 at 4:09 am

  #600841

  Nope

  - take a look at SQLDMO

  - maybe this can help you out ...

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=107508

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1

   

  "C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe" /s yourserver /d yourdb /I /F filepath

  

  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