General
Which source control systems are supported?
What SQL Server versions are supported?
Microsoft SQL Server 2019, 2017, 2016, 2014, 2012, 2008 and 2005
Does ApexSQL Source Control support Amazon SQL Database and Amazon RDS?
Yes, ApexSQL Source Control supports Amazon SQL Database and Amazon RDS
Permissions and requirements
What are the minimum Windows permissions required to install and use ApexSQL Source Control?
What are the required permissions for working with the database in ApexSQL Source Control?
Based on the Server host (Microsoft SQL Server, Azure SQL Database, Amazon RDS), different permissions will be required. In these articles you can find more about needed permissions:
Licensing and evaluation
How is ApexSQL Source Control licensed?
ApexSQL Source Control is licensed per user. Regardless of the number of SQL Server instances the user is connecting in SQL Server Management Studio, only one licence will be needed. The number of licenses is equal to the number of users/developers that will be using the tool
Are there any restrictions or limitations on the evaluation version of ApexSQL Source Control?
No, during the evaluation period of the 14 days, ApexSQL Source Control is fully functional. After the evaluation period is over, to continue using it, you must purchase the license
Configuration and setup
How is integration with a source control system managed?
ApexSQL Source Control provides native support with the latest application control interfaces for all supported source control systems which do not need a separate installation of a client in order to work (except for Mercurial)
Can all ApexSQL add-ins co-exist in a single SQL Server Management Studio instance?
ApexSQL Source Control can be used alongside any other ApexSQL add-in
What SQL Server objects can be version controlled?
All SQL Server non-system objects can be version controlled through ApexSQL Source Control
Source control
What types of authentication are supported for linking a database to source control?
ApexSQL Source Control supports three types of authentication for linking a database to source control, HTTP(s), SSH, and File based on the chosen source control system
What source control models are supported?
ApexSQL Source Control supports both shared and dedicated database development models
How do I initially script my entire database into source control?
After the database is linked to source control with ApexSQL Source Control, by default all objects in the Action center tab will be selected for the initial commit. Click the Apply button to perform the initial commit
Can I version control encrypted objects?
Currently not, but we are working on implementing this functionality
How can I build a database directly from my versioned objects?
Use ApexSQL Build to create a database directly from the scripts stored under source control with a few clicks, or use ApexSQL Source Control to link an empty database to the repository where the scripts are stored and apply all from source control through the Action center tab
How do I manage change conflicts?
Can I track changes made against static data?
Yes, ApexSQL Source Control tracks changes made against static data as well. More about this can be found in the Working with static data article
