SQLDatabaseProject

This project showcase how to create SQL Database porject in VS to

• Manage the database scripts
• Generate deployment scripts for continous deployment
• Similar to code how to achieve Db scripts in souce control

Steps

1. Create a database/ Use the existing Database

2. Create a SQL Database Project

3. Import the database

4. Connect with database

5. All Database objects schemas are created

**6. dd to the data source –> Select Solution–> Add Solution to Source Control

7. Add/Alter the objects to view the changes

8. To Generate Db scripts for deployment/ Publish directly into connected db

9. Generated Scripts