The user default configuration in database source control

The Object filtering tab - choosing the SQL Server and linked database

Applies to

ApexSQL Source Control

Summary

This article will explain the user default configuration when the database source control is done with ApexSQL Source Control.

Description

In this article, default options from this database source control tool will be explained. The default options are predefined options that are used for work with a database in the database source control.

How to make a comparison between SQL Server instances and snapshots

Added roles to logins shown as a results of SQL Server comparison

Applies to

ApexSQL Manage

Summary

SQL Server configuration is not something that is meant to be changed on a frequent basis. Once the optimum configuration settings have been set, altering them can lead to potential performance and security issues. Keeping track of all changes is time-consuming and prone to human error. This article describes how to create SQL Server comparison between two SQL Server instances or SQL Server snapshots to determine which SQL Server settings have been changed.

How to view user changes for the shared development model in the database source control

The Database change log window

Applies to

ApexSQL Source Control

Summary

This article explains how to view by whom (database developers) are database objects changed in the database source control.

Description

When a database is linked in the shared development model, all database developers are working on the same shared database. It is essential for a team of database developers to keep track of changes, as well as who made those changes on objects in that shared database. This database source control tool allows database developers to follow and view those types of information.

How to document specific database objects using the SQL documentation software

Select a database for documentation

Applies to

ApexSQL Doc

When there is a need to show new or altered objects to other developers or managers, who don’t have access to a database on which development process is done, it’s helpful to have a way of presenting them as a documentation file. This documentation should contain only these specific objects, rather than including all database objects, as the latter would be time-consuming, unreadable, and tedious.