ApexSQL 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 2014 support: Format and refactor your code directly in SQL Server 2014 Management Studio. Refactor SQL Server 2012 objects including FileTables .
Support for all Visual Studio versions: Format and refactor SQL code in Visual Studio 2013.
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.
MSSQL Server 2014, 2012, 2008 or 2005 with with Microsoft SQL Management Studio 2005 with SP2
Like it? Share with your friends!
Other Windows Software of Developer «ApexSQL»:
Apex SQL Clean ApexSQL Clean tool looks for and deletes unreferenced and unused Database objects like tables, views and procedures from within the database itself (cross-dependencies) and also from client applications (like a VS.NET project). References are created using
ApexSQL Script 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. It can export live databases directly to version control and can automa
Apex SQL Complete ApexSQL Complete can automatically fill in SQL keywords, statements and identifiers. It integrates seamlessly with SSMS and VS. ApexSQL Complete helps with object script and description reviews without coding interruption and also speeds up SQL coding with
Apex SQL Build ApexSQL Build creates or updates existing DB's creating deployment SQL scripts, C# packages or .NET executables. It creates deployment scripts, packages and executables from SQL scripts, script folders, snapshots or source control, consolidates multiple sc
ApexSQL Recover 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. Some features include compressed backup sup
ApexSQL Complete ApexSQL Complete can automatically fill in SQL keywords, statements and identifiers. It integrates seamlessly with SSMS and VS. ApexSQL Complete helps with object script and description reviews without coding interruption and also speeds up SQL coding with
ApexSQL Clean 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 Clean helps you remove u
Apex SQL Doc ApexSQL Doc creates database documentation in a variety of formats. Document SQL Servers, databases, objects and SSIS packages in a single document. Render even the most complicated database into user friendly documentation with inline object descriptions,
ApexSQL Restore ApexSQL Restore is a SQL Server tool that attaches both native and natively compressed SQL database backups and transaction log backups as live databases, accessible via SQL Server Management Studio, Visual Studio or any third-party tool. It allows attachi
ApexSQL Log ApexSQL Log, 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 2005 ,2008, 2012 and 2014 transaction logs. Determine who changed data and when the
DataTools DataTools is a simple yet powerful utility to manage your MySQL databases.
You can connect to any MySQL database across you local network as well as on the Internet. Execute large scripts and analyze your data.
Stellar Phoenix Access Password Recovery Stellar Phoenix Access Password Recovery 1.0 is an excellent Microsoft Access password recovery tool that recovers Access password from the Access databases. Supporting password recovery in MS Access 97, 2000, 2002, 2003, and 2007, this Access password rec
TSQL Code Repository TSQLCodeRepository is a powerful and robust tool for SQL Server database development. It includes a TSQL formatter, an sql editor and links to many types of sql utilities. You can use take the Microsoft Access database with you anywhere and add all of your
EMS Database Comparer for MySQL EMS DB Comparer for MySQL is an excellent tool for MySQL database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to synchronize structure of MySQL databas
MySQL Join Two Tables Software This software offers a solution for users who need to horizontally or vertically merge two MySQL tables into one. Simply login to both databases and choose a common column of data from two tables. The tables will not be changed: a new table is created with
SAP Crystal Server Personalized, simple, easy-to-understand business information, now more affordable with SAP Crystal Server. Thisentry-level business intelligence (BI) solution enables deeper insights to business information and positions your organization for greater com
DBConvert for Access & MS FoxPro DBConvert for MS Access & MS FoxPro is a database migration tool for data conversion from MS Access to MS FoxPro and from MS FoxPro to MS Access databases. You can convert MS Access data to MS FoxPro or MS FoxPro to MS Access databases simply by configurin
Infowise Smart ID Pro Infowise Smart ID Pro automatically generates complex item/document IDs according to patterns and conditions.it can create ID patterns using characters, field values and functions,prevent editing of the ID column and apply patterns according to conditions.
ETU SQL for MySQL ETU SQL for MySQL is an application especially created for those who need to manage the contents of a MySQL database without the need of advanced knowledge. It enables you to edit tables, import and export data, create a new database, add users and perform
Real Estate Manager Real estate agency is a program to assist the work of the Agency. By buying a license for this program you will be able to create a database of offers of apartments, Restaurants, Homes and land. Create a database of customers, add photos and assign statuse
Supported Operating Systems:
Windows 7 |
Windows 8 |
Windows Server 2008 |
Windows Vista |
Comments on :
Comments not found
Windows Software - Free Windows Downloads, Apps, Games, Freeware, Skype, Media Player, Antivirus, Gimp, Live, Starter for Windows XP, Vista, 7, 8, 10