| News |
| By label |
| By team |
| By product |
|
ApexSQL Blog Product announcements, promotions and other ApexSQL news ApexSQL Edit vs. Add-ins - Part 1: SQL object and text search ApexSQL Edit is a rather complex SQL development environment, equipped with various features to deal with many tasks such as source control integration, SQL debugging, profiling, formatting, refactoring, and auto-complete Over the past few years one of the biggest requests our customers have given us is to create add-ins for SSMS and Visual Studio. Over time those add-ins have become even more popular than our IDE, ApexSQL Edit. As such our add-ins have enjoyed a higher level of support and resources, so that today, they are a compelling alternative to using a standalone IDE One of these add-ins is ApexSQL Search – a SSMS and Visual Studio add-in derived from ApexSQL Edit’s Object search and Text search features. ApexSQL Search capabilities are extended even further than the original feature set in ApexSQL Edit Compared to ApexSQL Edit’s Object search feature, ApexSQL Search gained an advantage from additional refinement of the search filters, and additional features introduced during the development Let’s take a closer look at the advantages of ApexSQL Search by comparing its Database object search feature with ApexSQL Edit’s Object search 
Just like ApexSQL Edit, ApexSQL Search can find all SQL objects containing the specified phrase, including encrypted objects, system objects, SQL 2012 objects or objects stored in databases encrypted with Transparent Data Encryption (TDE). However, unlike the ApexSQL Edit’s Object search feature, the add-in‘s search can additionally be refined by using the following filters:
The search results can easily be filtered from a search by selecting/deselecting the appropriate check boxes. For example, if Object names and Object bodies are deselected, searching for product will show a column named ProductID and an index named IX_ProductID. However, the table Product containing that column and index, as well as a stored procedure containing the word product in its body, will not be displayed Coupled with the better object search functionality, additional features that ApexSQL Search brings to the table are the improved Database text search and the new Search history feature 
Database text search allows finding data in SQL tables and views by matching the specified phrase, including data stored in encrypted views, or databases encrypted with Transparent Data Encryption (TDE). The scope of the search can be controlled in several ways:
Search history allows repeating the exact search that was used before; including the search phrase and the specified search options, and it is available from both Database object search and Database text search features of ApexSQL Search. If you’ve searched for the term price with the Exact match option selected, the next time you want to perform the same search, simply select price from the Search text drop-down menu. Only the results that match price exactly will be displayed. If you search for the same phrase but change the search options (e.g. select a different database or disable a filter) you will be prompted to update the saved search. If you chose to do so, the saved search options will be overwritten with the new ones Other features ApexSQL Search has at its disposal are Dependency viewer and Smart rename. And the latest release of ApexSQL Search brings us useful and practical new features of Automatic query editor renaming and Extended properties editor In the next article, we will present the differences and similarities between the possibilities of ApexSQL Search and ApexSQL Edit to visually display SQL objects’ dependencies Author Sasa Krausovic Labels: ApexSQL Edit, ApexSQL Search, Support team |
