Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts
Thursday, May 18, 2017

Creating SQL Server database project from existing database

›
Many enterprise solutions have an existing database in place. To start working with SQL Server project developers have to migrate existing ...
Tuesday, May 16, 2017

Configuring SQL Server database project

›
The configuration of SQL Database project is important. It this article we will learn how to create a basic configuration for the project, ...
Monday, May 15, 2017

Compiling SQL Server Database project

›
One of the great features of SQL Server Database project is the compilation of the project. If the project setup up correctly, developers c...
Sunday, May 14, 2017

Creating stored procedures and additional objects in SQL Server Database Project

›
In the previous post  Creating a new SQL Server Database Project  we learned how to create SQL Database project, now we are going to show ...
Friday, May 12, 2017

Creating a new SQL Server Database Project

›
In my previous post  Migration-base vs State-based database development approach , I've shown two main approaches for database developm...
Thursday, May 11, 2017

Migration-base vs State-based database development approach

›
There are two main approaches for the development of SQL databases: Transformational (migrations) State-based (states) Transformati...
Monday, November 14, 2016

Set default filegroup for Microsoft Database project

›
1) First of all you have to create new filegroup. To do that add following file to your database project: DataFileGroup.sql /* Do...