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