ApexSQL Refactor 2013.04
ApexSQL Refactor is a free SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code, database tables. It expands wildcard, fully qualifies object names, renames SQL database objects. Supports SQL Server 2012.
Publishers DescriptionApexSQL Refactor is a free SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code and database tables with ease. It can format and refactor code directly in SSMS or VS, qualify objects, expand wildcards, encapsulate SQL, locate and highlight unused variables and parameters, and much more for FREE.
- SQL Server 2012 support: Format and refactor your code directly in SQL Server 2012 Management Studio. Refactor SQL Server 2012 objects including FileTables
- Support for all Visual Studio versions: Format and refactor SQL code in Visual Studio 2012, 2010, 2008 and 2005
- Split table: Improve your database design and make large tables more manageable by partitioning them
- Advanced SQL formatting: Create custom formatting profiles and share them across your team
- Customizable options: Layout your SQL code with over 160 customizable options and preview the impact of the changes
- Impact analysis: Preview the impact of changes with difference highlighting
- Expand wildcards: Transform * wildcards into explicit lists of column names
- Qualify object names: Qualify columns with schema table names and schema or aliases
- Copy SQL code as: Render T-SQL into its Java, C#, C++, VB .NET, PHP, Ruby, Delphi or PowerBuilder equivalent. Copy and paste it into your applications data access layer
- Add surrogate key: Replace complex, multi-column primary keys with a single column surrogate key
- Find unused variables and parameters: Clean up your code by identifying and removing parameters and variables that aren?t used
- Replace one-to-many relationships: Add a new associative table to replace one-to-many relationships
- Change parameters: Add, remove or change parameters without breaking dependencies from referencing objects
- Encapsulate SQL: Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters
|Requirements:||Microsoft SQL Server 2012, 2008 or 2005 with Client tools (SQL Server Management Studio)|
|Release Info:||Major Update on Nov 19, 2013|
|Release Notes:||Major feature, medium fix release|
|Related Tags:||format sql sql formatter sql server refactor sql sql refactor encapsulate sql code database tools format sql code sql code formatting database software refactoring sql code sql query formatting format sql query|
ApexSQL Audit Viewer is an Audit Trail generation and reporting tool for Microsoft SQL Server 7.0, 2000, 2005 or 2008.ApexSQL Audit Viewer includes powerful reporting utilities that can extract the audit data into meaningful reports.Apex SQL Code 2008.05
Apex SQL Code is a Rapid Application Development (RAD) Code Generation tool for Microsoft SQL Server that enables you to automatically generate thousands of lines of perfect ASP, VB, C#, SQL (& more) code in just seconds using familiar ASP.NET syntaxApex SQL Debug 2008.06
ApexSQL Debug is an Add-in to SQL Server Management Studio that offers step into, step out of, step through debugging with support for conditional break points, watches, call stacks and more.Apex SQL Enforce 2008.04
ApexSQL Enforce is designed to allow users automate custom designed database reviews in an objective, unbiased and repeatable way. ApexSQL Enforce empowers end users to design their own internal policies and set their own standards etc.Apex SQL SSIS Compare 2008.03
ApexSQL SSIS Compare is a powerful tool to quickly identify differences in your SQL Server Integration Services (SSIS) packages. The tool features fast comparison of multiple SSIS packages which makes it especially helpful for troubleshooting SSIS paApexSQL Audit 2013.01.
ApexSQL Audit allows you to seamlessly integrate data auditing and reporting into your client applications, audit and undo SQL database changes and easily determine who and when changed the data. It is also compatible with all SQL Server databases.ApexSQL Audit 2013.01.
ApexSQL Audit allows you to seamlessly integrate data auditing and reporting into your client applications, audit and undo SQL database changes and easily determine who and when changed the data. It is also compatible with all SQL Server databases.ApexSQL Build 2015.02
ApexSQL Build-builds or updates existing SQL Server databases, creates deployment SQL scripts, C# projects and packages. It creates deployment scripts, projects and packages from SQL scripts, script folders, snapshots, or directly from source controlApexSQL Clean 2011.01
ApexSQL Clean analyzes SQL Server database objects, dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself.ApexSQL Complete 2014.12
ApexSQL Complete can automatically fill in SQL keywords, statements and identifiers. It integrates seamlessly with SSMS and MSVS. ApexSQL Complete helps with object script and description reviews without coding interruptionApexSQL Data Diff 2012.03
ApexSQL Data Diff is a SQL Server database comparison tool used to compare and synchronize database data and manage database version control. It also supports comparing database backups, CLI, and moreApexSQL Diff 2013.01
ApexSQL Diff is a SQL development tool that can compare SQL Server database tables, views and all other SQL Server objects. Compare and synchronize Windows Azure SQL Databases as well as SQL databases, backups, source control labels and scripts.ApexSQL Diff API 2011.02
ApexSQL Diff API programmatically compares and synchronizes SQL Server database tables, views and all other SQL Server objects as well as database data. Compare and synchronize directly from a custom application. SQL Server 2012 support.ApexSQL Doc 2013.02
ApexSQL Doc documents SQL Servers, databases, objects, and SSIS packages in a single document. Create database documentation in CHM, HTML, HXS, DOC or DOCX formats. SQL Server 2012 support.ApexSQL Edit 2011.02
ApexSQL Edit is a SQL Server code editor with advanced SQL formatting, refactoring and autocomplete functions. Edit SQL using code snippets, templates and more. SQL Server 2012 support.ApexSQL Log 2013.01
ApexSQL Log, an SQL Server Transaction Log reader, lets you view transaction log data, audit SQL database changes and undo SQL database changes. ApexSQL Log reads SQL Server 2000, 2005 and 2008 (R2) transaction logs. SQL Server 2012 support.ApexSQL Log API 2013.01
ApexSQL Log API programmatically reads SQL Server Transaction Log. View transaction log data and audit changes programmatically. SQL Server 2012 support.ApexSQL Profile 2012.01
Profiles SQL code directly in SSMS. Find out how long each SQL statement takes to execute visually. Identify bottlenecks at a glance. View parameters and variable changes over time and find out the exact lines where those changes occur.ApexSQL Recover 2011.03
ApexSQL Recover can recover lost data due to delete, truncate and drop operations. Recover BLOB data as files, and recover data from corrupted databases, detached MDFs and database backups without restoring them. Supports SQL Server 2012.ApexSQL Script 2011.04
ApexSQL Script is a SQL Server database migration tool which scripts database object and data into a single or multiple deployment SQL scripts, .NET solutions or executable installers. Supports SQL Server 2012.
item has less then 1 vote
|OS Support||Windows Install and Uninstall|
|File Size||6.67 MB ( 6,827 KB )|
|Published||Nov 18, 2009 (6 years ago)|
|Updated||Jan 10, 2014 (2 years ago)|
Create advanced database web sites fast. Powerful code generator with events.
Manage, protect and share your files in an all-new modern interface with the world?s...
ECMerge diffs/merges local/FTP/SCC files/folders 3-way with syntax colouring