IT:AD:Db Projects [Notes]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

# IT:AD:Db Projects #



<callout type="Navigation" class="small">

* [[../|(UP)]]
{{indexmenu>.#2|nsort tsort}}


</callout>


## Process ##
* A Quick Intro
    * **Tip:** After adding a Table, Right Click, Select 'View Objects in Schema View' to edit a little more easily.
    * See: [Blog](http://bit.ly/tQGbfO)
* In depth considerations on deployment:
    * [MSDN](http://bit.ly/sTyiFc)



####  Importing Existing Dbs

* Ensure its a Database Project (not a Server Project)...easy mistake to make
* Right Click Project, Import
* To Export, Publish, after setting a connection string, and new Db Name
* To Add Lookup and other Seed Info, 
* For more info:
    * [Importing Existing Dbs](http://bit.ly/twWIp4)

#### Adding Seed info to Deployment Projects
    * Right click PostDeployment Script
    * Select SqlCmd mode
    * Ref a file
        * :r .\seed.sql    
    * Add seed.sql and add statements there.
        * *Important:* *.sql file should contain if/else to not duplicate entries.  
    IF NOT EXISTS (SELECT 1 from dbo.DbSchemaVersionInfo WHERE NameLowered='comp.app' Where Version > '0.0.1') 
    BEGIN
    --Do something...
    END 




## Common DDL ##