Free download ApexSQL Edit

ApexSQL Edit

2011
ApexSQL Edit is a SQL Server code editor with advanced SQL formatting, refactoring and autocomplete functions
Free Download
User rating
4.3/10
7 votes
License
Shareware
OS
Windows
Developer
Version
2011.02
Language
English
Release date
11 January 2013

Editor's review

This is a SQL server code editor.

ApexSQL Edit is an SQL Server code editor. The editor includes advanced SQL formatting, refactoring and auto-complete features. SQL using code snippets, templates and more could be used for editing operations. The editor also provides for translation of SQL code into a many programming languages. Auto-completion lets you create code fragments and constructs. Auto-complete feature is supplemented by a drop down pick list making the process even faster. Auto-complete object details will let you view details. Long runs of code can be encapsulated into database objects. Pre-written code snippets and templates could be saved and re-used. Performance profiling of the code gives you clues for SQL formatting and re-factoring. Code refactoring support has some meaningful features. These include change parameters, encapsulate as view, one-to-many relationships could be replaced with associative tables and surrogate keys could be added.

Syntax highlighting, version aware editing, object search, in-built support of source control systems are some of the useful features. The editor supports all MSSCCI compliant versioning systems. Expansion of wild cards, code profiler, code snippets, auto-replacement, SQL debug, copy SQL code as, are some of the other useful features. This has a simple and easy to use interface. It is intuitive enough that most users should get familiar with it quite easily. Getting productive with it should not take much time. This is a very good product. If you are looking for a similar solution, you should try it in your exact workflow.

Publisher's description

ApexSQL Edit is an SQL Server code editor with advanced SQL formatting, refactoring and autocomplete functions. Edit SQL using code snippets, templates and more. Translate SQL code into a variety of programming languages. Encapsulate lengthy blocks of code as database objects. Auto-complete SQL code fragments and constructs. Leverage pre-written code snippets and templates to avoid writing frequently used code over and over.

Develop faster with SQL code auto-complete, snippets and tags

Integrate seamlessly with any source control system

Improve your SQL code with formatting and refactoring

Performance profile your SQL at the line level
Features:
- Improved performance
- SQL Server 2012 support
- Enhanced auto-complete
- Auto-complete pick list
- Auto-complete object details
- Improved formatting engine
- Version-aware editing
- Syntax highlighting
- Improved object search
- Find unused variables and parameters (code refactor)
- Encapsulate as view (code refactor)
- Change parameters (code refactor)
- Replace one-to-many relationships with associative tables (code refactor)
- Add surrogate key (code refactor)
- Additional support for SQL 2008 and SQL 2005 object types
- Advanced SQL formatting
- Native support for the most popular source control providers
- Support for all MSSCCI compliant versioning systems
- SQL templates
- Snippets
- Auto-replacements
- Visual query builder
- SQL debugging
- Code profiler
- Expand wildcards
- Qualify object names
- Copy SQL code as
- Encapsulate as (code refactor)
- Smart rename (code refactor)
- Object search
- Text search
- Graphical dependencies
- Customizable shortcuts
- Transparent decryption
- Support for all SQL Server versions
ApexSQL Edit
ApexSQL Edit
Version 2011
Free Download

User comments

Rate this program