Visual Studio 2017 Project – RDLC Designer Missing

I recently upgraded visual studio 2015 to Vs 2017 and after this upgrade, I noticed that RDLC file is  opening only in XML editor , not in RDLC designer and then I found the below package to resolve this problem

• MicrosoftRdlc Report Designer for Visual Studio (Rdlc Designer and projects for ASP.Net and Windows Forms for Reporting Services Report Viewer Control)

Thanks for visiting!!

Difference between Build Solution, Rebuild Solution, and Clean Solution in Visual Studio

This blog will explain the difference between Build, Rebuild and Clean solution in visual studio:

Build vs Rebuild

Build: it complies and links only those source code files DLL /EXE that have changed since the last build. So normally build is faster than Rebuild and it build only those project, which have changed source code.

Rebuild : it clean all project artifices (clean bin folder)  and compile and link all source code files from scratch regardless of whether they changed or not.

Clean: it deletes all compiled files (DLL and EXE files)

Thanks for visiting!!

Visual Studio Database Project for comparing Dev and QA Schema

This post will demonstarte how to setup database project and compare two different envoirement (QA and Dev) database schema by using Visual Studio Database Project.

 

Setup Database : 

We created two database projects
- EMP_MASTER ( Development Database Project)
- EMP_MASTER_QA ( QA Database Project)
Perform the following steps to compare the Dev and QA Schema
EMP_MASTER :
- Create Database Project
- Import the database schema from database to database project.
- Remove the following scripts related to User Settings and Role settings.
 rolememberships.sql
 user.sql
- Build the database project (Output: EMP_MASTER .dbschema )
EMP_MASTER_QA:
- Create Database Project
- Import the database schema from database to database project.
- Remove the following scripts related to User Settings and Role settings.
 rolememberships.sql
 user.sql
- Build the database project (Output: EMP_MASTER _QA.dbschema )


Schema Comparison:
Now, with help of Schema Comparison option (Data Schema Compare) we can compare the both database’s object schema (Tables, Stored procedure, View) and also generate alter script for deployment process

>