SSMS / Visual Studio Sql server database project

Database good practice

Tools to use:
1. SSMS – sql server management studio
2. Visual Studio
The following video is the best to describe the process
1. How To Create a Database Deployment Project in 10 minutes
2. In short:
  1. Using VisualStudio connect to Database.
  2. Right click on the DB and select create new project.
    1. At this point there are schemes without data.
The following links explains how to generate script of database with data
1. Auto-generate INSERT statements for a SQL Server table
The following script explains how to create Visual studio first time database project:
1. Create Your First Visual Studio Database Project