VSDB to SSDT Part 2 : SQL Server 2008 Server Project … with SSDT
        Posted  
        
            by Etienne Giust
        on Geeks with Blogs
        
        See other posts from Geeks with Blogs
        
            or by Etienne Giust
        
        
        
        Published on Wed, 12 Sep 2012 13:07:23 GMT
        Indexed on 
            2012/09/12
            15:39 UTC
        
        
        Read the original article
        Hit count: 832
        
With Visual Studio 2012 and the use of SSDT technology, there is only one type of database project : SQL Server Database Project.
With Visual Studio 2010, we used to have SQL Server 2008 Server Project which we used to define server-level objects, mostly logins and linked servers. A convenient wizard allowed for creation of this type of projects. It does not exists anymore. Here is how to create an equivalent of the SQL Server 2008 Server Project with Visual Studio 2012:
- Create a new SQL Server Database Project : it will be created empty
- Create a new SQL Schema Compare ( SQL menu item > Schema Compare > New Schema Comparison )
- As a source, select any database on the SQL server you want to mimic
- Set the target to be your newly Database Project
- In the Schema Compare options (cog-like icon), Object Types pane, set the options as below. You might want to tweak those and select only the object types you want. Then, run the comparison, review and select your changes and apply them to the project.
© Geeks with Blogs or respective owner
