Sql Server management studio generate scripts RRS feed

  • Question

  • Hi, I'm trying to generate a script that will recreate an empty database with a specific schema, but the Generate Scripts task in SQL Server Management studio creates a script that fails due to the order it attempts to create certain objects, such as view objects.  I have many views in my database with some nested several layers deep and they depend on having parent views in a certain order.  I

    s there some other method of creating an empty database with the appropriate schema?
    Wednesday, February 13, 2008 9:14 PM


  • The best option to manage sequencing of scripts is to use one of the Third party products that are designed properly.


    And you could also use: Visual Studio Team System for Database Professionals.




    Thursday, February 14, 2008 1:35 AM