Database good practice
- Tools to use:
- SSMS – sql server management studio
- Visual Studio
- The following video is the best to describe the process
- How To Create a Database Deployment Project in 10 minutes
- In short:
- Using VisualStudio connect to Database.
- Right click on the DB and select create new project.
- At this point there are schemes without data.
- The following links explains how to generate script of database with data
- The following script explains how to create Visual studio first time database project:
Creating A New Database Project
- Very good link for creating and managing every aspect of SQL Server database by Visual Studio IDE.