Users must ensure their use of this technology/standard is consistent with VA policies and standards, including, but not limited to, VA Handbooks 61 VA Directives 6004, 6513, and 6517 and National Institute of Standards and Technology (NIST) standards, including Federal Information Processing Standards (FIPS).

This technology may store data on a Microsoft Structured Query Language (SQL) server database. SQL Source Control can push and pull database changes in SQL Server Management Studio, check development history and access specific database versions, store and share scripts to handle complex changes, such as column splits, and undo SQL Server changes. SQL Source Control for SQL (Structured Query Language) databases, allows for database source control within SQL Server Management Studio (SSMS) and connects existing databases to a version control system. More information on the proper use of the TRM can be found on the Visual object editor for SqlObjClass.Technologies must be operated and maintained in accordance with Federal and Department security and SqlObjClass.Procedure (except CLR Procedure) SqlObjClass.DDLTrigger (except CLR DDL Trigger) SqlObjClass.Function (except Aggregate and CLR) The following SQL objects can be edited using the Visual Object editor: The Visual object editor allows editing SQL database objects using the graphical interface SSMS users further benefit from the Visual object editor feature that is unique to ApexSQL Source Control. 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 However, over time, ApexSQL Source Control has become even more popular than our IDE, ApexSQL Edit.

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). Unlike ApexSQL Edit, ApexSQL Source Control fully supports SQL Server 2012 objects and has significantly improved performance (up to 300% faster in some cases) 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. 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.

Apex sql deploy sql from source control