Skip to content

karmakarmala/SQLDatabaseProject

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

Step1

2. Create a SQL Database Project

Step2

3. Import the database

Step3a

Step3b

4. Connect with database

Step4

5. All Database objects schemas are created

Step5

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

Step6

7. Add/Alter the objects to view the changes

Step7

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

Step8a

Step8b

9. Generated Scripts

Step9a Step9b

About

VS Project to manage db scripts

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages