General
ApexSQL add-ins general FAQs
SSMS and Visual Studio support
Can I perform data search on Azure SQL Database or SQL Server on Amazon RDS?
Does ApexSQL Search support Azure SQL Database Managed Instance?
Which version of SQL Server Management Studio ApexSQL Search support?
Microsoft SQL Server Management Studio 2012 and higher
- Please note: You can use the latest full-featured backwards compatible SQL Server Management Studio for free. Click here
Does ApexSQL Search support Active Directory - Password authentication?
Which versions of SQL Server does ApexSQL Search support?
Microsoft SQL Server 2005 and higher
Search
What can I search with the Text search feature?
With Text search feature can be search for text within database objects (including object names), data stored in tables and views (even encrypted ones)
Which objects can be searched with the Object search feature?
The full list can be founded under the Objects combo box of the Object search pane:
Does ApexSQL Search show search history?
Yes, search history allows users to repeat the exact used search, including the search phrase and the specified search options in a single click:
Can I filter data in the results grid?
Yes, The Object search and Text search features has the option to quickly identify the desired results by filtering out unwanted results using the Filter row option. Right-click on result grid and from the popup menu choose the Filter row command:
Can I export data from the result grid?
Yes, data can be exported in one of the following formats:
Can I find a SQL Server database object in the Object Explorer pane form a result grid?
Yes, to quick find the location, in Object Explorer, of the object found during Object search or Text search result grid, right click on the object in the result grid and, from the context menu, choose the Navigate to object explorer node command:
Can I additionally configure the search?
Yes, there are several parameters that you can set to narrow down your search. The search phrase can be adjusted by specifying whether to match (e.g. Exact match, Object name, Object body) to the searched text. Wildcards can also be used e.g. %
What wildcards are supported?
ApexSQL Search supports the same wildcards as the LIKE operator in SQL Server.
Does ApexSQL Search support searching with regular expressions?
Is search case sensitive?
No, for example, the result for the search phrase person will be the same as the search which is done with the search phrase PERSON
Renaming
Can I see the actual script that will be executed before I perform a Safe rename?
Yes, you can generate a preview and see exactly what will be executed
If I rename an object, will this change be applied to all its parent and child objects?
Yes, you can rename tables, procedures, views, functions, parameters and columns without breaking any dependencies
Can I replace all keywords from a search, or said another way, replace a batch of objects vs just one at a time?
No. Safe rename works on object names only and only one object at a time. Other strings that are found, besides object names, can’t be replaced within the tool
Extended property editor
Can I add or edit extended properties for database objects?
Yes, ApexSQL Search has the Extended property editor feature which allows to quick review, edit or add a new description for SQL Server database object: