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»:
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 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 Search ApexSQL Search analyzes SQL Server database object's dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. Search for SQL objects directly
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 Log API ApexSQL Log API programmatically reads SQL Server Transaction Log. View transaction log data and audit changes programmatically. Find out exactly when and how an accident occurred as well as details on who was involved. Add schema and data auditing capabil
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 Comply ApexSQL Comply is a powerful SQL Server auditing tool with a wide range of possibilities for auditing access, changes, and security on SQL Server instances, databases, and objects. It audits queries, execute and security (authentication changes, permission
Apex SQL Diff API ApexSQL Diff API is a powerful engine. Compare and synchronize SQL database schemas and data programmatically. Integrate your application with version control, deploying a specific database version or label directly to or from source control. Compare live
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
ApexSQL Monitor ApexSQL Monitor tracks SQL Server performance and System performance on multiple local and remote machines and SQL Server instances. It monitors the most important SQL Server statistics, memory, buffer, and page metrics - batch requests per second, user co
XBAImport Basic With XBAImport Basic, it is possible to extract transaction data from Ebay. It is also possible to create reports and download them from Amazon Seller Central and Amazon Market Place. You can save the data using the MS SQL Server or as flatfiles/xls.Requir
Fleet Maintenance Pro Shop Edition Fleet Maintenance Pro Shop makes it easy to track and organize preventive and repair maintenance information on your fleet of vehicles and equipment. In addition to helping you organize your equipment information, Fleet Maintenance Pro will also automatica
RosettaNet 2.0 Doc Refresh - English RosettaNet 2.0 Doc Refresh English contains updated RosettaNet.chm, Install_Guide.htm, and Readme.htm files. This version is the first release on CNET Download.com.What is new in this release:This version is the first release on CNET Download.com.Requireme
Oracle Change Case To Proper, Upper, Lower & Sentence Software This software offers a solution to users who want to change letter case in Oracle data. The user simply provides the user login information for the database and tests the connection before choosing to change text in entire fields (columns) to upper, lower,
VeryPDF Flipbook Maker VeryPDF Flipbook Maker allows you to add any local image as the flipbook background and changed the default buttons to another set stored on your local disk. It enables you to view the created flipbooks on your iPad, iPhone, Mac, and any mobile devices. IE
EMS DB Extract for MySQL EMS DB Extract for MySQL is an impressive and easy-to-use tool for creating MySQL database backups in a form of SQL scripts. This database script utility allows you to save metadata of all MySQL database objects as well as MySQL table data as database snap
Sync2DB Sync2DB is a Windows .Net application and developer tools that safely connect, links and synchronize all or selected Microsoft Outlook data with your corporate or web site database or any other SQL Database. Each connection to database and data feed settin
Paradox Editor Software This software offers a solution to users who want to edit data in a Paradox table. Simply select the table to be processed and click on Next to go to the editing screen to choose specific fields and begin editing.Limitations:Limited features
MySQL Backup To Another MySQL Database Software This software offers a solution to users who want to backup data from one MySQL database to another. Simply open both databases using the user friendly interface and click to copy tables from one to the other. This software will save you time by quickly an
HXTT Data Export 2006 - Oracle2Paradox HXTT Data Export 2006 - Oracle2Paradox is a program to convert Oracle(8, 8i, 9, 9i, 10g) database into Corel Paradox(3.0, 3.5, 4.x, 5.x, 7.x, 8.x, 9.x, 10,x, 11.x). The software are completely written in Java and can be deployed on any platform with Java V
Supported Operating Systems:
Windows 7 |
Windows 8 |
Windows Server 2008 |
Windows Vista |
Comments on ApexSQL Refactor:
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