ApexSQL Source Control, derived directly from the ApexSQL Edit’s Source control integration feature, is an SSMS and VS add-in that can source control SQL Server databases from SSMS. They share the same functionality, but the newer ApexSQL Source Control add-in has an improved and better-optimized engine that makes it more reliable. Unlike ApexSQL Edit, ApexSQL Source Control fully supports SQL Server 2012 objects and has significantly improved performance (up to 300% faster in some cases)
This is because over the past few years, one of the top requests from our customers has been to create add-ins for SSMS and Visual Studio (including the latest Visual Studio 2012). However, over time, ApexSQL Source Control has become even more popular than our IDE, ApexSQL Edit. As such, it has enjoyed a higher level of support and resources, so that today, it is a compelling alternative to using the standalone IDE
SSMS users further benefit from the Visual object editor feature that is unique to ApexSQL Source Control. The Visual object editor allows editing SQL database objects using the graphical interface
The following SQL objects can be edited using the Visual Object editor:
SqlObjClass.AppRole
SqlObjClass.Assembly
SqlObjClass.Certificate
SqlObjClass.Contract
SqlObjClass.Default
SqlObjClass.EventNotification
SqlObjClass.FulltextCatalog
SqlObjClass.FulltextStopList
SqlObjClass.MessageType
SqlObjClass.PartitionScheme
SqlObjClass.PartitionFunction
SqlObjClass.Role
SqlObjClass.RemoteServiceBinding
SqlObjClass.Queue
SqlObjClass.Route
SqlObjClass.Rule
SqlObjClass.Schema
SqlObjClass.SearchPropertyList
SqlObjClass.Sequence
SqlObjClass.Service
SqlObjClass.Synonym
SqlObjClass.User
SqlObjClass.View
SqlObjClass.XmlSchemaCollection
SqlObjClass.Function (except Aggregate and CLR)
SqlObjClass.DDLTrigger (except CLR DDL Trigger)
SqlObjClass.Procedure (except CLR Procedure)
SqlObjClass.Trigger (except CLR Trigger)
Visual object editor for SqlObjClass.Table is the only visual editor implemented in the ApexSQL Edit, and is used in the same form in ApexSQL Source Control
Visual object editor consists of the following tabs:
- SQL body – allows object structure editing
- Extended properties – allows changing, adding and removing extended properties of an object
- Permissions – lists database roles and available permissions that can be granted or denied
- DDL – allows previewing the future DDL file contents
- Warnings – contains a warning list about the script execution
- Generated script – contains a read-only script that must be executed to create the DDL file
Also, when you edit a SQL object, additional tabs specific to that SQL object type are included
In line with the growing security demands, we have improved the ApexSQL Source Control security by preventing Certificate versioning
Once installed ApexSQL Source Control is easily accessible via the SSMS main menu or the SSMS Object Explorer contextual menu
If you are already using ApexSQL Edit as a version-control solution, you can advance to the next level with ApexSQL Source Control, which, being a new generation ApexSQL tool actually makes SQL database version control a painless experience
April 1, 2013
