ApexSQL Complete
General
|
What are the minimum Windows permissions required to install and use ApexSQL Complete?
|
|
|
What are the minimum SQL Server permissions required to use ApexSQL Complete?
|
The minimum permissions required to compare SQL objects are:
- Public role membership
- VIEW ANY DEFINITION on the SQL instance the code will be executed on
|
|
Does the add-in support encrypted objects?
|
Yes, the add-in fully supports encrypted objects including auto-completing their names, accessing their parameters and displaying their structure
|
|
Is it possible to disable the add-in completely?
|
Yes. To do so, click Disable auto-complete in the ApexSQL Complete menu
|
|
Can I use another key to insert an item from the auto-complete list?
|
In the ApexSQL Complete menu, click Code completion options and navigate to the Inserts tab. To specify which keys to be used as insertion keys, select the checkbox next to the displayed key
|
|
Can I set my own aliases?
|
Yes. In the ApexSQL Complete menu, click Code completion options and navigate to the Aliases tab where you can specify a custom alias for each object from all available SQL Server instances and databases
|
|
Can I control the formatting of the auto-completed code?
|
In the ApexSQL Complete menu, click Code completion options and navigate to the General tab. The automatically inserted keyword's case can be specified there. For more formatting and refactoring options, please see the ApexSQL Refactor product page
|
|
Can I control when the auto-complete list will pop-up?
|
In the ApexSQL Complete menu, click Code completion options and navigate to the Hints tab. To specify the scenarios in which you do not want auto-complete to appear, simply deselect the appropriate checkboxes
|
|
How do I invoke auto-complete manually?
|
You can invoke auto-complete at any time by pressing Ctrl+Space
|
|
How can I navigate through auto-complete's list?
|
Use the Up/Down keys or the mouse wheel to scroll through the auto-complete list
|
|
How can I improve the tool's performance?
|
In the ApexSQL Complete menu, click Refresh Cache to ensure that the auto-complete cache contains the latest database schema
SQL Server support
|
|
Does ApexSQL Complete support SQL Server 2012?
|
Yes. It supports SQL Server 2012 databases, objects and properties including:
- Contained databases
- FileTables
- Sequences
- Search property lists
- Columnstore indexes
- Poison message handling attribute for queues
- Geometry and geography auto grid tessellation scheme for spatial indexes
|
|
Which SQL Server versions are supported?
|
Support is provided for SQL Server 2012, 2008 and 2005
|
|
What SQL Server Management Studio versions does ApexSQL Complete integrate in?
|
Microsoft SQL Server Management Studio 2012, 2008 and 2005
|
|
What SQL Server editions are supported?
|
The tool supports all SQL Server 2012, 2008 and 2005 editions except Express editions
|
|
Can all ApexSQL add-ins co-exist in a single SQL Server Management Studio instance?
|
The add-in can be used directly from SSMS and Visual Studio alongside any other ApexSQL add-in
|
|
I have multiple SQL Server versions. Can the add-in run on all of them?
|
Yes. Select the SQL Server Management Studio versions the add-in should be integrated in during its installation process
Visual studio support
|
|
Does ApexSQL Complete support Visual Studio 2012?
|
Yes. It fully integrates with Visual Studio 2012
|
|
What Visual Studio version does the add-in support?
|
Support is offered for Visual Studio 2012, 2010, 2008 and 2005
|
|
Can the add-in run on multiple versions of Visual Studio?
|
Yes. Select the Visual Studio versions the add-in should be integrated in during its installation process