IT:AD:Data:Db:Projects:HowTo:Create a Project from an Existing Database [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:Data:Db:Projects:HowTo:Create a Project from an Existing Database #



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



## Using Visual Studio 2012 ##

In `Solution Explorer`. create a new `Project`, of type `Sql Server Database Project`

Once created, in `Solution Explorer`, right click the `Project` node.

Select `Import... `, `From Database...`

Specify a `New Connection...` and enter the relevant connection details:

    eg:
      Windows Authentication
      STNSI02
      NSI_DEV

Before continuing on, check the import settings (Objects, Logins, Permissions)

Go...

The final result will contain a link to a document containing the summary:

>Eg:  
A summary of the import was saved to the following location: c:\users\admsigals\documents\visual studio 2012\Projects\Database1\Database1\Import Schema Logs\Database1_20120926035800.log      


Once the import is complete:

* Select Properties and rename the output db name.
* Build it, and see what happens.