Sales Tel: +63 945 7983492  |  Email Us    
SMDC Residences

Air Residences

Features and Amenities

Reflective Pool
Function Terrace
Seating Alcoves

Air Residences

Green 2 Residences

Features and Amenities:

Wifi ready study area
Swimming Pool
Gym and Function Room

Green 2 Residences

Bloom Residences

Features and Amenities:

Recreational Area
2 Lap Pools
Ground Floor Commercial Areas

Bloom Residences

Leaf Residences

Features and Amenities:

3 Swimming Pools
Gym and Fitness Center
Outdoor Basketball Court

Leaf Residences

Contact Us

Contact us today for a no obligation quotation:


+63 945 7983492
+63 908 8820391

Copyright © 2018 SMDC :: SM Residences, All Rights Reserved.


































































70-461 dumps with Real exam Questions and Practice Test - smresidences.com.ph

Great Place to download 100% free 70-461 braindumps, real exam questions and practice test with VCE exam simulator to ensure your 100% success in the 70-461 - smresidences.com.ph

Pass4sure 70-461 dumps | Killexams.com 70-461 real questions | http://smresidences.com.ph/

70-461 Querying Microsoft SQL Server 2012/2014

Study Guide Prepared by Killexams.com Microsoft Dumps Experts

Exam Questions Updated On :


Killexams.com 70-461 Dumps and Real Questions

100% Real Questions - Exam Pass Guarantee with High Marks - Just Memorize the Answers



70-461 exam Dumps Source : Querying Microsoft SQL Server 2012/2014

Test Code : 70-461
Test Name : Querying Microsoft SQL Server 2012/2014
Vendor Name : Microsoft
: 297 Real Questions

definitely examine these current dumps and success is yours.
this is top notch, I handed my 70-461 exam final week, and one exam earlier this month! As many humans factor out here, these brain dumps are a exquisite way to study, either for the exam, or just for your expertise! On my checks, I had masses of questions, good element I knew all of the solutions!!


I want actual test questions latest 70-461 examination.
The killexams.com is the awesome web page where my goals come real. With the aid of manner of the usage of the material for the practise certainly introduced the real spark to the studies and severely ended up by way of the usage of acquiring the qualitymarks within the 70-461 exam. Its miles pretty easy to stand any exam with the assist of your have a study material. Thank youplenty for all. Keep up the top class art work guys.


determined an correct supply for real 70-461 real test questions.
Great!, I proud to be trained with your 70-461 QA and software. Your software helped me a lot in preparing my Microsoft exams.


Do you need Latest dumps of 70-461 exam to pass the exam?
Due to consecutive failures in my 70-461 exam, I was all devastated and thought of changing my field as I felt that this is not my cup of tea. But then someone told me to give one last try of the 70-461 exam with killexams.com and that I wont be disappointed for sure. I thought about it and gave one last try. The last try with killexams.com for the 70-461 exam went successful as this site didnt put all the efforts to make things work for me. It didnt let me change my field as I cleared the paper.


can you believe, all 70-461 questions I organized were asked.
I would take a privilege to say Many Many Thanks to all team members of killexams.com for providing such a wonderful platform made available to us. With the help of the online questions and caselets, I have successfully cleared my 70-461 certification with 81% marks. It was really helpful to understand the type and patterns of questions and explanations provided for answers made my concepts crystal clear. Thanks for all the support and keep doing it. All the best killexams.


obtain those 70-461 questions.
I recognize the struggles made in developing the exam simulator. Its far remarkable. I passed my 70-461 exam particularly with questions and answers provided with the aid of killexams.com team


Awesome Source! I got Actual test questions of 70-461 exam.
This exam coaching package deal protected the questions I became asked on the exam - something I didnt consider will be viable. So the stuff they provide is certainly valid. It seems to be frequently up to date to hold up with the official updates made to 70-461 exam. Very top quality, the trying out engine runs easily and could be very person pleasant. there is not anything I dont like about it.


70-461 exam is not any extra hard to pass with these .
killexams.com became a blessing for 70-461 exam, since the system has plenty of tiny details and configuration tricks, which can be challenging in case you dont have much of 70-461 revel in. killexams.com 70-461 questions and solutions are sufficient to take a seat and pass the 70-461 check.


do not forget to observe these real test questions for 70-461 exam.
The 70-461 exam is supposed to be a completely diffcult exam to clear But I cleared it remaining week in my first attempt. The killexams.com s guided me well and I was rightly prepared. Advice to other students - dont take this exam lightly and test very well.


Is there a shortcut to fast put together and pass 70-461 examination?
I changed into so much lazy and didnt need to work hard and usually searched quick cuts and handy strategies. While i used to be doing an IT route 70-461 and it became very difficult for me and didnt able to discover any manual line then i heard about the website online which had been very famous in the marketplace. I were given it and my problems removed in few days when i started it. The sample and exercise questions helped me loads in my prep of 70-461 exams and i efficaciously secured right marks as nicely. That became just because of the killexams.


Microsoft Querying Microsoft SQL Server

Microsoft updates its database story with SQL Server 2019 and new cloud database features | killexams.com Real Questions and Pass4sure dumps

(photograph courtesy Wikimedia Commons user Moumou82 / cc3.0)

one of the crucial simple features of computing infrastructure will play a key function in Microsoft’s Ignite 2018 pitch to developers and consumers, with a few new database points competing for area alongside dozens of other new services for Azure.

The enterprise plans to introduce SQL Server 2019 this week in Orlando, and it'll also lengthen a key means of its newest cloud database — Cosmos DB — to all Azure valued clientele. it will additionally make it easier for users of its Azure SQL cloud database to instantly scale their needs as their functions develop or trade.

Given how valuable the database is to the total business computing utility stack, here is an enormous enviornment of competition between cloud vendors and traditional database suppliers alike. Amazon net features presents six sorts of managed databases and supports a number of others that consumers could wish to control themselves, together with SQL Server and Oracle.

SQL Server has been round because 1989, and the most up-to-date version is designed for consumers who're managing their own servers and need to contain one of the most leading massive-statistics purposes into their mix. Microsoft plans to announce that a preview version of the database that has constructed-in aid for Hadoop and Spark, and may additionally allow clients of different databases to query statistics stored in Oracle, Teradata, or MongoDB appropriate from SQL Server.

Azure Cosmos DB, probably the most biggest cloud items Microsoft launched closing year, is capable for the familiar public to take capabilities of its multimaster capabilities after a preview length. Multimaster elements unveiled prior this yr at Microsoft construct will allow purchasers to write facts to assorted cloud computing regions at the equal time, improving the efficiency and reliability of their apps.


Adaptive question Processing in SQL Server | killexams.com Real Questions and Pass4sure dumps

Introduction

Adaptive query processing is the newest, greater query processing function added in the SQL Server database engine. This formula is obtainable in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. 

question efficiency is all the time a area of research and innovation. once in a while, Microsoft includes new function and functionality in SQL Server to increase query performance to assist their clients. In SQL Server 2016, Microsoft delivered query keep. question keep monitors question efficiency and provides the best way to choose more suitable question plans for execution. query save is a characteristic to persist question execution plans and analyze the history of query plans to identify the queries that may cause efficiency bottlenecks. Any element in time these plans can also be reviewed, and the consumer can use plan forcing to enforce the query processor to opt for and use a specific query plan for execution. you could examine more about question save in video display question performance using question keep in SQL Server.

In SQL Server 2017, Microsoft went one step extra and labored on improving the question plan first-class. This enhanced question plan exceptional is Adaptive question Processing. 

query Execution Plan

just before SQL Server 2017, question processing was a uniform technique with a certain set of steps. The SQL Server query optimizer first generates a group of possible question plans for a question or batch of T-SQL code submitted via the database engine to query optimizer. in accordance with the can charge of the question plan, optimizer selects the bottom-cost query plan.

as soon as the query execution plan is competent and accessible to execute, SQL Server storage engines get the query plan and execute it in response to the genuine question plan and return the data set.

This end to conclusion procedure (question plan technology, and submitting the plan for processing) as soon as started, has to run to completion. Please see figuring out a SQL Server question Execution Plan for more guidance.

in this method, question performance is dependent upon the normal great of the query plan, be a part of order, operation order and preference of actual algorithm like nested loop join or hash be a part of, and so on. also, cardinality estimates play a vital role to decide the quality of the question plan. Cardinality represents the estimated variety of rows back on execution of a question.

The accuracy of cardinality drives a stronger pleasant of query execution plan and more correct allocation of reminiscence, CPU to the question. This development leads to an improved and superior execution of question, referred to as adaptive query processing. they will focus on exactly how SQL Server achieves this in rest of the section,.

Adaptive question Processing

ahead of SQL Server 2017, the behavior of question Optimizer changed into not most useful; it sure to opt for the bottom charge query plan for execution, despite negative initial assumptions in estimating inaccurate cardinality, which ended in dangerous query performance.

In Adaptive question Processing, SQL Server optimized the query optimizer to generate more correct and first-class question plans with greater accurate cardinality. Adapting query Processing gets a higher-suggested question plan. There are three new techniques for adapting to software workload qualities.

Adapting query Processing options
  • Batch Mode reminiscence grant feedback. This approach helps in allocating the required memory to fit in all returning rows. The right allocation of reminiscence helps in, 1) reducing extreme reminiscence provides that keep away from concurrency considerations and, 2) fixing underestimated memory offers that steer clear of expensive spills to disk.

    query performance suffers when reminiscence allocation sizes don't seem to be sized accurately. In Batch Mode reminiscence supply comments, optimizer repeats the workload and recalculates the specific memory required for a question after which updates the provide value for the cached plan.  When a similar query remark is executed, the question uses the revised memory grant measurement and improves the query efficiency.

  • Batch Mode Adaptive be a part of. This technique gives the choice of algorithm option and the query plan dynamically switches to a better be a part of method all the way through plan execution.  This defers either hash be a part of or nested loop be part of choice except after first input has been scanned.

    the new operator within the family unit, Adaptive be a part of operator helps in defining a threshold. This threshold is used to examine with the row count number of the construct join enter; if the row count number of the construct join enter is below the threshold, a nested loop join would be enhanced than a hash join and query plan switches to nested loop be part of. otherwise, with none switches question plan continues with a hash be part of.

    This method above all helps the workload with popular fluctuations between small and big be part of enter scans.

  • Interleaved Execution. Interleaved execution is relevant to multi-statement table valued capabilities (MSTVFs) in SQL Server 2017 because MSTVFs have a fixed cardinality guess of “100” in SQL Server 2014 and SQL Server 2016, and an estimate of “1” for earlier types, which leads to passing through inaccurate cardinality estimates to the question plan. In Interleaved execution approach, each time SQL Server identifies MSTVFs during the optimization process, it pauses the optimization, executes the applicable subtree first, gets accurate cardinality estimates after which resumes optimization for leisure of the operations. This approach helps in getting actual row counts from MSTVFs instead of mounted cardinality estimates to make plan optimizations downstream from MSTFs references; this effects in improvement in workload efficiency. also, Interleaved execution allows for plans to adapt according to the revised cardinality estimates as MSTVFs changes the unidirectional boundary of single-question execution between the optimization and execution part.
  • further records for Adaptive question Processing innovations

    There are certain data linked to every Adaptive query Processing method while optimizer improves the query efficiency using these innovations.

    Batch Mode reminiscence supply feedback. remarks isn't persisted as soon as a plan is evicted from cache. You should not in a position to get the heritage of the query plan in query keep, as reminiscence furnish feedback will trade best the cached plan and adjustments are at present now not captured in the question store. also, in case of failover, remarks might be lost.

    Batch Mode Adaptive join. SQL Server can dynamically swap between both forms of joins and at all times make a choice from nested loop and hash be part of; merge join is not at present part of the adaptive join. additionally, adaptive joins introduce a far better reminiscence requirement than an indexed nested loop be a part of equivalent plan.

    Interleaved Execution. There are some restrictions; 1) the MSTVFs must be read-most effective, 2) the MSTVFs cannot be used interior of a move follow operation, 3) the MSTVFs don't seem to be eligible for interleaved execution if they do not use runtime constants.

    Configure Adapting question Processing

    There are dissimilar alternate options to configure Adaptive question Processing. These options are as follows:

    alternative-1: SQL Server by means of default allows for Adaptive query Processing and executes the queries beneath compatibility degree a hundred and forty.

    option-2: T-SQL is available to allow and disable all three Adaptive question Processing options:

    T-SQL to disable Adaptive question Processing innovations

  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK = ON;
  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_BATCH_MODE_ADAPTIVE_JOINS = ON;
  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_INTERLEAVED_EXECUTION_TVF = ON;
  •        T-SQL to allow Adaptive query Processing recommendations

  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK = OFF;
  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_BATCH_MODE_ADAPTIVE_JOINS = OFF;
  • ALTER DATABASE SCOPED CONFIGURATION SET DISABLE_INTERLEAVED_EXECUTION_TVF = OFF;
  • option-three:implement Adaptive query Processing approach the use of question trace. query trace takes priority over a database scoped configuration and different settings.

  • option (USE hint ('DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK'));
  • alternative (USE trace('DISABLE_BATCH_MODE_ADAPTIVE_JOINS'));
  • choice (USE trace('DISABLE_INTERLEAVED_EXECUTION_TVF'));
  • abstract

    The adaptive question processing improves the high-quality of a query plan. This helps in deciding upon the right join, appropriate order of operation and greater accurate reminiscence allocation to fit all rows. The three thoughts of adaptive question processing make SQL Server 2017 drastically quicker at processing the workload. also, adaptive question processing offers significant advancements devoid of refactoring T-SQL code.

    universal, adaptive query processing is a pretty good addition in SQL Server and permits SQL Server to generate well recommended fine query plans to control software workload processing.

    See all articles through Anoop Kumar


    Microsoft’s SQL Server receives built-in assist for Spark and Hadoop | killexams.com Real Questions and Pass4sure dumps

    It’s time for the subsequent version of SQL Server, Microsoft’s flagship database product. The company today announced the primary public preview of SQL Server 2019 and whereas yet one other replace to a proprietary database may also no longer seem all that pleasing in the beginning look, Microsoft is making an attempt to do just a few rather wonderful things with this update.

    What’s on the core of the entire most unique updates is an acknowledgement that there are very few organizations that handiest use a single database product. So what Microsoft is doing with SQL Server is including new connectors that enable enterprise to use SQL Server to query different databases, together with those of Oracle, Teradata and MongoDB. This turns SQL Server into anything of a digital integration layer — yet the data by no means needs to be replicated or moved to SQL Server.

    but there's more! SQL Server 2019 will include built-in guide for Spark and the Hadoop File device. That’s an acknowledgement of the popularity of these open-supply tools, as well as the value of massive information workloads that SQL Server, if it needs to say vital, must be in a position to guide, too, and it has to achieve this in a way that many organizations are already regular with.

    There’s yet another open source point here, too: SQL Server will help these large data clusters with the aid of the Google-incubated Kubernetes container orchestration equipment. every cluster will include SQL Server, the Hadoop file system and Spark.

    As for the identify, it’s price noting that many pundits anticipated a “SQL Server 2018,” but Microsoft opted to skip a year after SQL Server 2016 and 2017. So SQL Server 2019 it is.

    more Microsoft Ignite 2018 coverage


    Unquestionably it is hard assignment to pick dependable certification questions/answers assets regarding review, reputation and validity since individuals get sham because of picking incorrectly benefit. Killexams.com ensure to serve its customers best to its assets concerning exam dumps update and validity. The vast majority of other's sham report dissension customers come to us for the brain dumps and pass their exams joyfully and effortlessly. They never trade off on their review, reputation and quality on the grounds that killexams review, killexams reputation and killexams customer certainty is imperative to us. Uniquely they deal with killexams.com review, killexams.com reputation, killexams.com sham report objection, killexams.com trust, killexams.com validity, killexams.com report and killexams.com scam. On the off chance that you see any false report posted by their rivals with the name killexams sham report grievance web, killexams.com sham report, killexams.com scam, killexams.com protest or something like this, simply remember there are constantly awful individuals harming reputation of good administrations because of their advantages. There are a huge number of fulfilled clients that pass their exams utilizing killexams.com brain dumps, killexams PDF questions, killexams hone questions, killexams exam simulator. Visit Killexams.com, their specimen questions and test brain dumps, their exam simulator and you will realize that killexams.com is the best brain dumps site.

    Back to Braindumps Menu


    1Y0-327 exam prep | 9L0-314 practice test | 000-X01 real questions | HP2-E51 test questions | 000-280 cram | 70-354 practice test | 1Z0-542 braindumps | CQE study guide | 2M00001A dump | 000-N11 brain dumps | HP0-171 study guide | P2090-046 test prep | HP0-S13 practice exam | 71-571 sample test | HP0-J19 study guide | 132-S-800-1 exam prep | 000-035 braindumps | JN0-522 free pdf | 000-550 mock exam | 000-649 bootcamp |


    Dont Miss these Microsoft 70-461 Dumps
    If are you burdened how to pass your Microsoft 70-461 Exam? With the help of the confirmed killexams.com Microsoft 70-461 Testing Engine you will learn how to boom your abilties. The majority of the scholars start identifying when they discover that they have to seem in IT certification. Their brain dumps are complete and to the point. The Microsoft 70-461 PDF documents make your imaginative and prescient large and assist you lots in instruction of the certification exam.

    killexams.com will be a reliable and trustworthy platform provides 70-461 exam questions with 100 percent success guarantee. you wish to practice questions for one day minimum to attain well in the test. Your real journey to success in 70-461 exam, really starts with killexams.com test practice questions that's the wonderful and verified supply of your targeted position. killexams.com Discount Coupons and Promo Codes are as under; WC2017 : 60% Discount Coupon for all exams on website PROF17 : 10% Discount Coupon for Orders larger than $69 DEAL17 : 15% Discount Coupon for Orders larger than $99 SEPSPECIAL : 10% Special Discount Coupon for All Orders At killexams.com, they have an approach to provide fully tested Microsoft 70-461 actual Questions and Answers which you will need to Pass 70-461 exam. they have an approach to truly guide people to remember the and Guarantee to pass. It is a good call to hurry up your position as a professional and boost yourself at the speed of technology. Click http://killexams.com/pass4sure/exam-detail/70-461

    In case you're looking out Pass4sure 70-461 Practice Test containing Real Test Questions, you are at right region. They have incorporated database of inquiries from Actual Exams so as that will enable you to assemble and pass your exam on the primary endeavor. All tutoring materials at the site are Up To Date and demonstrated with the guide of their masters.

    We offer ultra-present day and a la mode Pass4sure Practice Test with Actual Exam Questions and Answers for fresh out of the box new syllabus of Microsoft 70-461 Exam. Practice their Real Questions and Answers to Improve your mastery and pass your exam with High Marks. They ensure your finish inside the Test Center, securing the greater part of the subjects of exam and build your Knowledge of the 70-461 exam. Pass four beyond any doubt with their precise inquiries.

    killexams.com 70-461 Exam PDF incorporates Complete Pool of Questions and Answers and Dumps verified and certified comprehensive of references and Ass (where significant). Their objective to gather the Questions and Answers isn't in every case best to pass the exam toward the begin endeavor however Really Improve Your Knowledge about the 70-461 exam themes.

    70-461 exam Questions and Answers are Printable in High Quality Study Guide that you may down load in your Computer or another gadget and begin setting up your 70-461 exam. Print Complete 70-461 Study Guide, convey with you while you are at Vacations or Traveling and Enjoy your Exam Prep. You can get right of passage to exceptional 70-461 Exam out of your on line account whenever.

    killexams.com Huge Discount Coupons and Promo Codes are as under;
    WC2017: 60% Discount Coupon for all exams on website
    PROF17: 10% Discount Coupon for Orders greater than $69
    DEAL17: 15% Discount Coupon for Orders greater than $99
    DECSPECIAL: 10% Special Discount Coupon for All Orders


    Download your Querying Microsoft SQL Server 2012/2014 Study Guide immediately after looking for and Start Preparing Your Exam Prep Right Now!

    70-461 | 70-461 | 70-461 | 70-461 | 70-461 | 70-461


    Killexams LX0-103 test prep | Killexams 190-957 braindumps | Killexams OA0-002 questions and answers | Killexams 050-SEPROSIEM-01 study guide | Killexams C9020-562 practice test | Killexams ASF bootcamp | Killexams 000-963 VCE | Killexams CCBA braindumps | Killexams CMS7 real questions | Killexams 000-038 dump | Killexams 156-915-65 cram | Killexams 000-894 pdf download | Killexams HP0-096 dumps questions | Killexams 000-094 study guide | Killexams LOT-408 brain dumps | Killexams 000-R18 real questions | Killexams HP0-M26 braindumps | Killexams CVA cheat sheets | Killexams 6006-1 real questions | Killexams ICDL-Powerpoint practice questions |


    killexams.com huge List of Exam Braindumps

    View Complete list of Killexams.com Brain dumps


    Killexams 70-545-CSharp test prep | Killexams MA0-103 real questions | Killexams LOT-849 study guide | Killexams 000-598 Practice Test | Killexams HP0-M55 exam prep | Killexams 000-J02 dumps questions | Killexams A2040-409 mock exam | Killexams JN0-692 examcollection | Killexams ITILSC-OSA brain dumps | Killexams A2090-422 dumps | Killexams P8060-002 free pdf | Killexams 156-910-70 braindumps | Killexams C4040-124 practice questions | Killexams E20-895 practice test | Killexams C2180-273 practice test | Killexams 300-460 free pdf download | Killexams PC0-006 study guide | Killexams 156-730 exam questions | Killexams CBAP braindumps | Killexams 644-334 test prep |


    Querying Microsoft SQL Server 2012/2014

    Pass 4 sure 70-461 dumps | Killexams.com 70-461 real questions | http://smresidences.com.ph/

    Microsoft SQL Server Utilities and Tools | killexams.com real questions and Pass4sure dumps

    Useful free and paid Microsoft SQL Server utilities and tools – a complete list of 275 SQL Server Utilities updated on Jan 24, 2019.

    Utility types (main purpose), in braces {} current counts:

  • : Backup solutions {6}
  • [BI]: Business Intelligence Solutions {4}
  • [D]: Documentation solutions {7}
  • [DA]: Database Architecture {13}
  • [DC]: Data compare {12}
  • [ETL]: Extract Download Load (ETL) Tools {1}
  • : Internal SQL Server utilities (for example, bcp) {14}
  • [IDX]: Index manager {2}
  • [G]: Data generation {4}
  • [J]: Job managers {3}
  • [M]: Monitoring and alerting Tools {16}
  • [MG]: Migration tool {26}
  • [MS]: Management Studio (alternative for SSMS) {26}
  • [REC]: Recovery tools {7}
  • : Search tools {3}
  • [SC]: Structure compare {18}
  • [T]: Testing tools {5}
  • [ST]: Statistics utilities {3}
  • [?]: Not yet classified {114}
  • Name/Description Cross Database Platform Type Official/Download page Release Author License Free version Price SSMS No No [MS] SSMS 2018-11-21 Microsoft Yes No bcp Utility No No bcp Utility 2012-02-11 Microsoft Yes No sqlcmd Utility No No sqlcmd Utility 2016-08-23 Microsoft Yes No mssql-cli No Linux,Mac [?] mssql-cli 2018-07-06 Microsoft BSD-3 Open Source No Azure Data Studio No Linux,Mac [MS] Azure Data Studio 2018-12-19 Microsoft Yes No RML Utilities for SQL Server No No [T] RML Utilities for SQL Server 2014-12-12 Microsoft Yes No GraphView No No [?] GraphView 2016-02-23 Microsoft Yes No Baseline Security Analyze No No [?] Baseline Security Analyze 2015-01-09 Microsoft Yes No tablediff Utility No No tablediff Utility – Microsoft Yes No Microsoft Log Parser No No [?] Microsoft Log Parser – Microsoft Yes No Log Parser Lizard GUI Oracle,MySQL,PostgreSQL,Other No [MS] Log Parser Lizard GUI 2017-06-01 Lizard Labs Yes $59 Diskspd No No [T] Diskspd 2015-12-14 Microsoft Yes No HammerDB No No [T] HammerDB 2015-05-04 Open Source Yes No Exchange Server Error Code Look-up No No [?] Exchange Server Error Code Look-up 2004-05-10 Microsoft Yes No LINQPad No No [?] LINQPad 2016-01-02 Joseph Albahari Non-commercial $45 SqlDynamite No No SqlDynamite 2016-04-06 Anatoly Sova Yes No SQL Server Data Tools No No [MS] SQL Server Data Tools 2018-04-10 Microsoft Yes No Database Health Monitor No No [M] Database Health Monitor 2016-03-20 Steve Stedman Yes No SchemaDrift No No [SC] SchemaDrift 2016-02-28 Steve Stedman Yes No Dbeaver Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] Dbeaver 2018-09-24 Open Source Yes No HeidiSQL Oracle,MySQL,PostgreSQL,Other No [MS] HeidiSQL 2017-12-19 Open Source Yes No SQLExecStats No No [ST] SQLExecStats 2016-02-08 Joe Chang Yes No ExpressProfiler No No [?] ExpressProfiler 2016-02-15 Chris Moore Yes No Data Migration Assistant No No [MG] Data Migration Assistant 2017-03-15 Microsoft Yes No SQL Server Migration Assistant for Sybase No No [MG] Migration Assistant for Sybase 2017-02-17 Microsoft Yes No dta Utility No No dta Utility – Microsoft Yes No osql Utility No No osql Utility – Microsoft Yes No sqldiag Utility No No sqldiag Utility – Microsoft Yes No sqldumper Utility No No sqldumper Utility – Microsoft Yes No SqlLocalDB Utility No No SqlLocalDB Utility – Microsoft Yes No sqllogship Utility No No sqllogship Utility – Microsoft Yes No sqlservr Application No No sqlservr Application – Microsoft Yes No sqlps Utility No No sqlps Utility – Microsoft Yes No sqlmaint Utility No No sqlmaint Utility – Microsoft Yes No Ssms Utility No No Ssms Utility – Microsoft Yes No dtexec Utility No No dtexec Utility – Microsoft Yes No SQL Server 2016 Report Builder No No [?] SQL Server 2016 Report Builder 2016-09-16 Microsoft Yes No SQL Server 2005 Best Practices Analyzer No No [?] BPA 2005 2008-08-13 Microsoft Yes No SQL Server 2000 Best Practices Analyzer No No [?] BPA 2000 2010-04-26 Microsoft Yes No SQL Server 2008 R2 Best Practices Analyzer No No [?] BPA 2008 2010-06-18 Microsoft Yes No SQL Server 2012 Best Practices Analyzer No No [?] BPA 2012 2012-06-04 Microsoft Yes No DLM Dashboard No No [M] DLM Dashboard 2016-04-27 Red Gate Yes No Red Gate SQL Compare No No [DC] Red Gate SQL Compare 2016-10-31 Red Gate No $495 Red Gate SQL Data Compare No No [SC] Red Gate SQL Data Compare 2016-05-09 Red Gate No $495 Red Gate SQL Prompt No No [MS] Red Gate SQL Prompt 2016-04-28 Red Gate No $369 Red Gate SQL Monitor No No [M] Red Gate SQL Monitor 2015-10-15 Red Gate No $1495 Red Gate SQL Backup Pro No No Red Gate SQL Backup Pro 2014-07-08 Red Gate No $995 Red Gate SQL Doc No No [D] Red Gate SQL Doc 2016-04-26 Red Gate No $369 Red Gate SQL Data Generator No No [G] Red Gate SQL Data Generator 2016-04-26 Red Gate No $369 Red Gate SQL Dependency Tracker No No [?] Red Gate SQL Dependency Tracker 2016-04-26 Red Gate No $369 Red Gate SQL Multi Script No No [?] Red Gate SQL Multi Script 2016-04-15 Red Gate No $245 Red Gate SQL Index Manager No No [IDX] Red Gate SQL Index Manager ? Red Gate No $149 Red Gate SQL Comparison SDK No No [DC],[SC] Red Gate SQL Comparison SDK 2016-02-22 Red Gate No $895 Red Gate SQL Clone No No [?] Red Gate SQL Clone 2017-02-27 Red Gate No $6955 Red Gate SQL Provision No No [?] Red Gate SQL Provision 2018-02-26 Red Gate No $2955 Red Gate Data Masker Oracle No [?] Red Gate SQL Data Masker 2018-02-26 Red Gate No $2395 DLM Automation No No [?] DLM Automation ? Red Gate No ? ReadyRoll No No [?] ReadyRoll 2016-01-03 Red Gate No $345 Rapid Database Extractor Oracle No [?] Rapid Database Extractor 2016-11-03 Idera Yes No SQL XEvent Profiler No No [?] SQL XEvent Profiler 2014-03-14 Idera Yes No SQL Check No No [?] SQL Check 2015-09-24 Idera Yes No SQL Fragmentation Analyzer No No [?] SQL Fragmentation Analyzer 2012-11-16 Idera Yes No SQL Heat Map No No [?] SQL Heat Map 2016-01-27 Idera Yes No SQL Hekaton Memory Check No No [?] SQL Hekaton Memory Check 2015-06-10 Idera Yes No SQL Page Viewer No No [?] SQL Page Viewer 2014-08-25 Idera Yes No SQL Update Statistics No No [ST] SQL Update Statistics 2015-12-14 Idera Yes No SQL Statistics Aggregator No No [ST] SQL Statistics Aggregator 2015-05-18 Idera Yes No SQL Backup Status Reporter No No SQL Backup Status Reporter 2015-08-07 Idera Yes No SQL Integrity Check No No [?] SQL Integrity Check 2013-08-26 Idera Yes No SQL Job Manager No No [J] SQL Job Manager 2012-03-19 Idera Yes No Azure SQL Database Backup No No Azure SQL Database Backup 2012-10-02 Idera Yes No SQL Column Search No No SQL Column Search 2015-11-17 Idera Yes No SQL Permissions Extractor No No [?] SQL Permissions Extractor 2015-08-07 Idera Yes No SQL BI Check No No [BI] SQL BI Check 2016-04-13 Idera Yes No SQL Inventory Check No No [?] SQL Inventory Check 2016-03-24 Idera Yes No SQL Diagnostic Manager No No [?] SQL Diagnostic Manager ? Idera No $1747 SQL Safe Backup No No SQL Safe Backup 2016-09-08 Idera No $907 SQL Compliance Manager No No [?] SQL Compliance Manager 2015-09-08 Idera No $2657 SQL Inventory Manager No No [?] SQL Inventory Manager 2016-04-22 Idera No $3195 SQL Virtual Database No No [?] SQL Virtual Database 2016-03-24 Idera No $625 SQL Secure No No [?] SQL Secure 2016-04-19 Idera No $907 SQL Doctor No No [?] SQL Doctor 2015-12-17 Idera No $625 SQL Admin Toolset No No [?] SQL Admin Toolset 2016-01-13 Idera No $395 SQL Defrag Manager No No [?] SQL Defrag Manager 2016-03-10 Idera No $1495 DBArtisan No No [?] DBArtisan ? Idera No $3122 SQL BI Manager No No [BI] SQL BI Manager 2015-09-08 Idera No $697 SQL Enterprise Job Manager No No [J] SQL Enterprise Job Manager 2015-09-08 Idera No $697 DB Optimizer No No [?] DB Optimizer ? Idera No $1420 SQL Query Store Optimizer No No [?] SQL Query Store Optimizer 2016-07-01 Idera Yes No Rapid SQL Oracle,MySQL,PostgreSQL,Other No [MS] Rapid SQL ? Idera No $710 SQL Comparison Toolset No No [DC],[SC] SQL Comparison Toolset ? Idera No $745 ER/Studio Data Architect Oracle,MySQL,PostgreSQL,Other No [DA] ER/Studio Data Architect Idera No $1287 DB Change Manager Oracle,MySQL,PostgreSQL,Other No [SC] DB Change Manager ? Idera No $1420 Uptime Infrastructure Monitor No Linux [?] Uptime Infrastructure Monitor ? Idera No ? dbForge Schema Compare No No [SC] dbForge Schema Compare 2016-09-16 Devart Shareware No $150 dbForge Data Compare No No [DC] dbForge Data Compare 2016-09-28 Devart Shareware No $150 dbForge Data Generator No No [G] dbForge Data Generator 2016-09-16 Devart Shareware No $250 dbForge Query Builder No No [?] dbForge Query Builder 2016-08-17 Devart Shareware No $100 dbForge Event Profiler No No [?] dbForge Event Profiler 2016-09-16 Devart Freeware Yes No dbForge SQL Decryptor No No [?] dbForge SQL Decryptor 2017-04-20 Devart Freeware Yes No dbForge Studio No No [MS] dbForge Studio 2017-03-12 Devart Shareware Yes $250 dbForge Fusion No No [?] dbForge Fusion 2016-12-27 Devart Shareware No $150 dbForge Documenter No No [D] dbForge Documenter 2016-09-16 Devart Shareware No $150 Devart Excel Add-in for SQL Server No No [?] Devart Excel Add-in for SQL Server 2017-09-13 Devart Shareware No $100 dbMonitor Oracle,MySQL,PostgreSQL,Other No [M] dbMonitor 2012-11-01 Devart Freeware Yes No Minion Enterprise No No [?] Minion Enterprise ? MinionWare No $1500 SQL Server Compression Estimator No No [?] SQL Server Compression Estimator 2011-06-02 Bob Tavlor Yes No ClearTrace No No [?] ClearTrace 2016-07-07 Bill Graziano Yes No Dell Security Explorer No No [?] Dell Security Explorer 2015-06-25 Dell No $850 Dell LiteSpeed for SQL Server No No [?] Dell LiteSpeed for SQL Server 2015-07-31 Dell No ? Dell Toad for SQL Server No No [MS] Dell Toad for SQL Server 2015-05-12 Dell No ? Dell Spotlight on SQL Server Enterprise No No [?] Dell Spotlight 2016-03-10 Dell No $2561 Dell Foglight No No [?] Dell Foglight 2015-09-22 Dell No ? Dell Discovery Wizard No No [?] Dell Discovery Wizard 2011-09-22 Dell Yes No Dell Enterprise Reporter No No [?] Dell Enterprise Reporter ? Dell No $511 SQL Scripter No No [?] SQL Scripter 2013-02-24 Thomas Hinsenkamp No €99 Simple Dynamic Scheduler No No [?] Simple Dynamic Scheduler 2016-05-02 Miljan Radovic Yes No ApexSQL Audit No No [?] ApexSQL Audit 2017-07-11 ApexSQL No $1699 ApexSQL Backup No No ApexSQL Backup 2017-10-12 ApexSQL No $499 ApexSQL Defrag No No [IDX] ApexSQL Defrag 2017-06-29 ApexSQL No $499 ApexSQL Log No No [?] ApexSQL Log 2017-05-24 ApexSQL No $1999 ApexSQL Monitor No No [M] ApexSQL Monitor 2017-10-05 ApexSQL No $499 ApexSQL Plan No No [?] ApexSQL Plan 2018-04-05 ApexSQL Yes No ApexSQL Propagate No No [?] ApexSQL Propagate 2017-09-25 ApexSQL Yes No ApexSQL Recover No No [REC] ApexSQL Recover 2017-10-26 ApexSQL No $1999 ApexSQL Build No No [?] ApexSQL Build 2017-05-15 ApexSQL No $399 ApexSQL Clean No No [?] ApexSQL Clean 2017-09-28 ApexSQL No $399 ApexSQL Data Diff No No [DC] ApexSQL Data Diff 2017-10-26 ApexSQL No $399 ApexSQL Decrypt No No [?] ApexSQL Decrypt 2017-08-16 ApexSQL Yes No ApexSQL Diff No No [SC] ApexSQL Diff 2017-10-26 ApexSQL No $399 ApexSQL Doc No No [D] ApexSQL Doc 2017-09-06 ApexSQL No $299 ApexSQL Generate No No [G] ApexSQL Generate 2017-07-13 ApexSQL No $499 ApexSQL Script No No [?] ApexSQL Script 2016-05-10 ApexSQL No $249 ApexSQL Trigger No No [?] ApexSQL Trigger 2017-06-01 ApexSQL No $1999 ApexSQL Trigger Veiwer No No [?] ApexSQL Trigger Viewer 2017-06-01 ApexSQL Yes No ApexSQL Snapshot Utility No No [?] ApexSQL Snapshot Utility 2016-01-12 ApexSQL Yes No ApexSQL Model No No [DA] ApexSQL Model 2018-09-10 ApexSQL No $399 ApexSQL Analyze No No [?] ApexSQL Analyze 2017-12-13 ApexSQL No $299 ApexSQL BI Monitor No No [BI],[M] ApexSQL BI Monitor 2018-05-18 ApexSQL No $499 ApexSQL VM Monitor No No [M] ApexSQL VM Monitor 2018-05-09 ApexSQL No $999 ApexSQL Job No No [J] ApexSQL Job 2018-03-29 ApexSQL No $499 ApexSQL Enforce No No [?] ApexSQL Enforce 2018-07-19 ApexSQL No $299 DBBest T-SQL Analyzer No No [?] DBBest T-SQL Analyzer 2015-03-13 DBBest No $89 DBBest Database Compare Suite No No [SC],[DC] DBBest Database Compare Suite 2015-09-04 DBBest No $349 Advanced Query Tool No No [?] Advanced Query Tool 2015-03-18 Cardett Associates No $180 SqlDiffFramework No No [SC] SqlDiffFramework 2012-04-17 Michael Sorens Yes No DataGrip Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] DataGrip 2017-02-21 Jet Brains No $89 Pssdiag and Sqldiag Manager No No [?] Pssdiag and Sqldiag Manager 2017-01-06 Jack Li Yes No SQL Nexus Tool No No [?] SQL Nexus Tool 2016-11-20 Jack Li Yes No DBSophic Qure Profiler No No [?] DBSophic Qure Profiler ? DBSophic No $300 DBSophic Qure Optimizer No No [?] DBSophic Qure Optimizer ? DBSophic No ? RestoreChecker No No [?] RestoreChecker 2015-01-15 SQLServerUtilities No $99 SQLScripter No No [?] SQLScripter 2009-08-24 SQLServerUtilities No $99 SQLC No No [DC],[SC] SQLC 2017-11-19 David Ingleton Yes No Database Performance Analyzer Oracle, MySQL, Other Linux [M] Database Performance Analyzer ? SolarWinds No $1995 Database Performance Analyzer for MSSQL No No [M] Database Performance Analyzer for MSSQL ? SolarWinds No $1995 SQL Enlight No No [MS] SQL Enlight 2016-04-25 UbitSoft No $295 Aireforge Studio No No [MG],[SC] Aireforge Studio 2017-06-21 AireForge Yes $299 HexaTier No No [?] HexaTier ? HexaTier No ? SoftTree SQL Assistant Oracle,MySQL,PostgreSQL,Other No [MS] SoftTree SQL Assistant 2017-12-17 SoftTree No $215 DB Audit and Security 360 Oracle,MySQL,Other No [?] DB Audit and Security 360 2015-02-07 SoftTree No $499 EMS SQL Management Studio No No [MS] EMS SQL Management Studio 2016-05-26 EMS No $257 EMS SQL Backup No No EMS SQL Backup 2016-04-13 EMS Yes $82 EMS SQL Administrator No No [?] EMS SQL Administrator 2015-04-14 EMS Yes $135 EMS SQL Manager No No [?] EMS SQL Manager 2016-05-26 EMS Yes $135 EMS Data Export No No [?] EMS Data Export 2016-04-29 EMS No $47 EMS Data Import No No [?] EMS Data Import 2016-04-14 EMS No $47 EMS Data Pump No No [?] EMS Data Pump 2016-11-03 EMS No $47 EMS Data Generator No No [G] EMS Data Generator 2010-07-10 EMS No $47 EMS DB Comparer No No [SC] EMS DB Comparer 2015-07-24 EMS No $47 EMS DB Extract No No [?] EMS DB Extract 2008-10-16 EMS No $47 EMS SQL Query No No [?] EMS SQL Query 2012-03-29 EMS No $47 EMS Data Comparer No No [DC] EMS Data Comparer 2012-11-16 EMS No $47 NitroAccelerator No No [?] NitroAccelerator 2016-07-10 Nitrosphere No $1265 ERwin Data Modeler Oracle,MySQL,PostgreSQL,Other No [DA] ERwin Data Modeler 2016-06-03 ERwin No $810 Toad Data Modeler Oracle,MySQL,PostgreSQL,Other No [DA] Toad Data Modeler 2016-06-16 Dell No $562 SQL Power Architect Oracle,MySQL,PostgreSQL,Other Linux,Mac [DA] SQL Power Architect 2016-02-11 SQLPower Yes $995 DbWrench Oracle,MySQL,PostgreSQL,Other Linux,Mac [DA] DbWrench 2016-07-06 Nizana Systems No $99 Navicat Data Modeler Oracle,MySQL,PostgreSQL,Other Linux,Mac [DA] Navicat Data Modeler 2016-08-01 PremiumSoft No $199 DeZign for Databases Oracle,MySQL,PostgreSQL,Other No [DA] DeZign for Databases 2016-04-25 Datanamic No $259 ERDesigner NG Oracle,MySQL,PostgreSQL,Other Linux,Mac [DA] ERDesigner NG 2013-04-10 Mirko Sertic Open Source No Vertabelo Oracle,MySQL,PostgreSQL,Other Online [DA] Vertabelo ? Vertabelo No $948 dbDiffo Oracle,MySQL,PostgreSQL,Other Online [DA] dbDiffo ? Contenet Ltd Yes No SQL DXP Oracle,MySQL No [DC],[SC] SQL DXP 2016-06-20 SQL Delta No $530 Aqua Data Studio Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] Aqua Data Studio 2016-07-06 AquaFold No $499 RazorSQL Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] RazorSQL 2016-09-29 Richardson Software No $100 SQL Pretty Printer No No [?] SQL Pretty Printer 2016-02-19 Gudu Software No $50 Database .NET Oracle,MySQL,PostgreSQL,Other No [MS],[SC] Database .NET 2018-08-20 fish's dotNET Non-commercial $69 dbMigration .NET Oracle,MySQL,PostgreSQL,Other No [DC],[SC] dbMigration .NET 2018-08-20 fish's dotNET Non-commercial $49 Is It SQL No No [M] Is It SQL 2017-04-06 Bill Graziano Non-commercial No Database Experimentation Assistant Technical Preview 2 No No [T] Database Experimentation Assistant 2017-03-24 Microsoft Yes No Data Platform Studio No No [MG] Data Platform Studio ? Red Gate Software Yes ? Flyway Oracle,MySQL,PostgreSQL,Other No [MG] Flyway 2018-01-30 boxfuse Apache Open Source $950 Liquibase Oracle,MySQL,PostgreSQL,Other No [MG] Liquibase 2018-04-11 Liquibase Apache Open Source No My Batis Oracle,MySQL,PostgreSQL,Other Linux,Mac [MG] My Batis 2018-03-20 My Batis Apache Open Source No SentryOne Plan Explorer No No [?] SentryOne Plan Explorer 2017-05-25 SentryOne Yes No SQL Sentry No No [M] SQL Sentry 2016-12-07 SentryOne No ? DBmaestro TeamWork Oracle No [?] DBmaestro TeamWork ? DBmaestro No ? xSQL Schema Compare No No [SC] xSQL Schema Compare 2017-03-01 xSQL Software Shareware Yes $399 xSQL Data Compare No No [DK] xSQL Data Compare 2017-06-26 xSQL Software Shareware Yes $399 xSQL Script Executor MySQL,DB2,SQL Server CE No [?] xSQL Script Executor 2015-02-25 xSQL Software Freeware Yes $249 xSQL Builder No No [?] xSQL Builder 2017-03-15 xSQL Software Shareware No $799 xSQL Documenter Oracle,MySQL,SQLite,Other No [D] xSQL Documenter 2017-01-04 xSQL Software Shareware No $199 xSQL Profiler No No [?] xSQL Profiler 2017-06-28 xSQL Software Shareware Yes $999 xSQL Schema Compare SDK No No [SC] xSQL Schema Compare SDK 2017-10-25 xSQL Software Shareware No $1499 xSQL RSS Reporter No No [D] xSQL RSS Reporter 2014-11-25 xSQL Software Shareware No $169 xSQL Database Searcher No No xSQL Database Searcher 2017-05-09 xSQL Software Freeware Yes No Cloud-based DB Monitoring Platform No Mobile [M] Cloud-based DB Monitoring Platform ? SQLTreeo No €180 SchemaCrawler Oracle,MySQL,PostgreSQL,Other Yes [D],[SC] SchemaCrawler 2017-02-27 Sualeh Fatehi Open Source No SA MaaS Microsoft SQL Server No No [M] SA MaaS Microsoft SQL Server ? SENTINELAGENT No ? CatCompare v2 No No [?] CatCompare v2 2017-01-07 Andy Leonard No $295 SSIS Catalog Compare v2.0 Bundle No No [?] SSIS Catalog Compare v2.0 Bundle 2017-01-06 Andy Leonard No $495 MS Kerberos Configuration Manager No No [?] MS Kerberos Configuration Manager 2017-01-31 Microsoft Yes No Spotlight No No [M] Spotlight ? Quest Software Yes ? DBConvert Studio Oracle,MySQL,PostgreSQL,Other No [MG] DBConvert Studio 2017-03-01 DMSoft Technologies No $499 DbDefence No No [?] DbDefence 2017-03-01 ActiveCrypt Software Yes $698 SQL Server Migration Assistant for MySQL MySQL No [MG] SQL Server Migration Assistant for MySQL 2017-02-17 Microsoft Yes No sqlcmd for Mac and Linux No Linux,Mac [?] sqlcmd for Mac and Linux 2017-01-26 Soheil Rashidi Open Source No SQL Migrator No No [MG] SQL Migrator ? Datamate Technology ? ? MS FoxPro to MS SQL Migration and Sync No No [MG] MS FoxPro to MS SQL Migration and Sync 2013-10-08 DMSoft Technologies No $149 MySQL to MS SQL Migration and Sync No No [MG] MySQL to MS SQL Migration and Sync 2013-10-08 DMSoft Technologies No $149 Oracle to MS SQL Migration and Sync No No [MG] Oracle to MS SQL Migration and Sync 2013-10-09 DMSoft Technologies No $149 PostgreSQL to MS SQL Migration and Sync No No [MG] PostgreSQL to MS SQL Migration and Sync 2013-10-08 DMSoft Technologies No $149 MS Excel to MS SQL Migration No No [MG] MS Excel to MS SQL Migration 2013-09-23 DMSoft Technologies No $149 SQLite to MS SQL Migration and Sync No No [MG] SQLite to MS SQL Migration and Sync 2014-05-08 DMSoft Technologies No $149 IBM DB2 to MS SQL Migration and Sync No No [MG] IBM DB2 to MS SQL Migration and Sync 2013-09-09 DMSoft Technologies No $149 MS Access to MS SQL Migration and Sync No No [MG] MS Access to MS SQL Migration and Sync 2013-10-08 DMSoft Technologies No $149 Firebird to MS SQL Migration and Sync No No [MG] Firebird to MS SQL Migration and Sync 2013-09-11 DMSoft Technologies No $149 SQLines SQL Converter No No [MG] SQLines SQL Converter ? Dmtolpeko Open Source No SQLite & SQL Server Compact Toolbox No No [?] SQLite & SQL Server Compact Toolbox ? ErikEJ Open Source No SqlPad Postgres,MySQL,Crate,Vertica No [MS] SqlPad ? Rickbergfalk Open Source No Html-query-plan No No [?] Html-query-plan ? JustinPealing Open Source No SqlQueryStress No No [?] SqlQueryStress ? Adam Machanic Open Source No SQL Server Migration Assistant for DB2 DB2 No [MG] SQL Server Migration Assistant for DB2 2017-02-17 Microsoft Yes No SQL Server Migration Assistant for Oracle Oracle No [MG] SQL Server Migration Assistant for Oracle 2017-02-17 Microsoft Yes No SQL Server Migration Assistant for Access Access No [MG] SQL Server Migration Assistant for Access 2017-02-17 Microsoft Yes No mssql for Visual Studio Code No Linux,Mac [MS] mssql for Visual Studio Code 2017-05-02 Microsoft Open Source No Microsoft Assessment and Planning No No [?] Microsoft Assessment and Planning 2017-02-10 Microsoft Yes No mssql-scripter No Linux,Mac [?] mssql-scripter ? Microsoft Open Source No DBFS No Linux [M] DBFS ? Microsoft Open Source No comparator Oracle,MySQL,PostgreSQL,Other No [DC] comparator 2017-06-06 Pumpet LGPL-3.0 Open Source No Navicat for SQL Server No Mac [MS] Navicat for SQL Server 2017-06-14 PremiumSoft No $699 Navicat Premium Oracle,MySQL,PostgreSQL,Other Mac [MS] Navicat Premium 2017-06-14 PremiumSoft No $1299 DbVisualizer Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS],[DA] DbVisualizer 2017-08-22 DbVis Software AB. Yes $197 DbSchema Oracle,MySQL,PostgreSQL,Other Linux,Mac [DA] DbSchema 2017-06-19 Wise Coders Solutions Yes $127 DBGhost No No [?] DBGhost 2017-01-31 Innovartis Ltd No £430 SQLAutomate Oracle,MySQL,Other No [?] SQLAutomate 2017-06-19 OnLine ToolWorks     No $99 BimlExpress No No [?] BimlExpress ? Varigence   No No BIDS Helper No No [?] BIDS Helper 2015-03-17 Microsoft   Open Source No Azure Data Warehouse Migration Utility No No [MG] Azure Data Warehouse Migration Utility ? Microsoft ? ? Dell Benchmark Factory Oracle,MySQL,Other No [T] Dell Benchmark Factory ? Quest Software No $4413 manduka Oracle Linux,Mac [?] manduka 2017-03-08 Virtusa Corporation Yes No PowerBI Desktop Oracle,MySQL,PostgreSQL,Other No [BI] PowerBI Desktop 2017-07-11 Microsoft Yes ? Stellar Phoenix SQL Database Repair No No [REC] Stellar Phoenix SQL Database Repair 2017-07-05 Stellar Technology No $349 DataNumen SQL Recovery No No [REC] DataNumen SQL Recovery 2017-03-20 DataNumen No $500 Recovery Toolbox for SQL Server No No [REC] Recovery Toolbox for SQL Server ? Recovery Toolbox Shareware No $99 SQL MDF Viewer No No [?] SQL MDF Viewer ? SysTools Shareware No $129 SQL MDF Recovery Tool No No [REC] SQL MDF Recovery Tool ? SysTools Shareware No $129 SQL Passord Recovery No No [REC] SQL Passord Recovery ? SysTools Shareware No $69 SQL Decryptor No No [?] SQL Decryptor ? SysTools Shareware No $69 SQL Backup Database Recovery No No [REC] SQL Backup Database Recovery ? SysTools Shareware No $149 SQL Log File Viewer No No [?] SQL Log File Viewer ? SysTools Shareware No $999 DAX Studio No No [?] DAX Studio ? Sqlbi Freeware Yes No SQL Cop No No [?] SQL Cop ? LessThanDot Freeware Yes No Dataedo Oracle,MySQL No [D] Dataedo 2017-09-15 Logic Systems Shareware Yes $239 Azure Database Migration Service Oracle,MySQL, Other Online [MG] Azure Database Migration Service 2017-12-01 Microsoft Yes No FlowHeater Oracle,MySQL,PostgreSQL,Other No [ETL] FlowHeater 2017-10-02 FlowHeater GmbH Shareware No $79 EDIS No No [ETL] EDIS ? SQL ETL Shareware Yes $599 SchemaSpy Oracle,MySQL,PostgreSQL,Other Linux,Mac [D] SchemaSpy 2018-08-05 Rafal Kasa MIT Open Source No Adminer Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] Adminer 2018-02-20 Jakub Vrána Apache Open Source No Full Convert Oracle,MySQL,PostgreSQL,Other No [MG] Full Convert 2018-08-20 Spectral Core Shareware Yes $699 Replicator Oracle,MySQL,PostgreSQL,Other No [DC] Replicator 2018-08-20 Spectral Core Shareware Yes $699 JackDB Oracle,MySQL,PostgreSQL,Other Online [MS] JackDB ? JackDB No $48 SQL Workbench Oracle,MySQL,PostgreSQL,Other Linux,Mac [MS] SQL Workbench 2018-08-20 Thomas Kellerer Yes No Valentina Studio MySQL,PostgreSQL,Other Linux,Mac [MS] Valentina Studio 2018-09-24 Paradigma Software Yes $200 SSMS

    Download page: SSMSRelease date: 2018-11-21Support Version: 2005-2017/AzureAuthor: MicrosoftFree version: YesPrice: No

    SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server. This release features improved compatibility with previous versions of SQL Server, a stand-alone web installer, and toast notifications within SSMS when new releases become available.

    bcp Utility

    Download page: bcp UtilityRelease date: 2012-02-11Support Version: 2008/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The bcp utility bulk copies data between an instance of MicrosoftSQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. Except when used with the queryout option, the utility requires no knowledge of Transact-SQL. To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are valid for its columns.

    sqlcmd Utility

    Download page: sqlcmd UtilityRelease date: 2016-08-23Support Version: 2008-2017/AzureAuthor: MicrosoftFree version: YesPrice: No

    The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.

    mssql-cli

    Download page: mssql-cliRelease date: 2018-07-06Support Version: 2008-2017/AzureAuthor: MicrosoftFree version: Open SourcePrice: No

    Interactive command line query tool for SQL Server.

  • Auto-completion
  • Syntax highlighting
  • Query history
  • Configuration file support
  • Multi-line queries
  • Azure Data Studio

    Download page: Azure Data StudioRelease date: 2018-12-19Support Version: 2008-2017/AzureAuthor: MicrosoftFree version: YesPrice: No

    Azure Data Studio (previously SQL Operations Studio) is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.

    Azure Data Studio List of Extensions

  • Cross-Platform DB management for Windows, macOS and Linux with simple XCopy deployment
  • SQL Server Connection Management with Connection Dialog, Server Groups, and Registered Servers
  • Object Explorer supporting schema browsing and contextual command execution
  • T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition
  • Query Results Viewer with advanced data grid supporting large result sets, export to JSON\CSV\Excel, query plan and charting
  • Management Dashboard supporting customizable widgets with drill-through actionable insights
  • Visual Data Editor that enables direct row insertion, update and deletion into tables
  • Backup and Restore dialogs that enables advanced customization and remote filesystem browsing, configured tasks can be executed or scripted
  • Task History window to view current task execution status, completion results with error messages and task T-SQL scripting
  • Scripting support to generate CREATE, SELECT and DROP statements for database objects
  • Workspaces with full Git integration and Find In Files support to managing T-SQL script libraries
  • Modern light-weight shell with theming, user settings, full screen support, integrated terminal and numerous other features
  • RML Utilities for SQL Server

    Download page: RML Utilities for SQL ServerRelease date: 2014-12-12Support Version: 2008/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see:

  • Which application, database or login is using the most resources, and which queries are responsible for that
  • Whether there were any plan changes for a batch during the time when the trace was captured and how each of those plans performed
  • What queries are running slower in todays data compared to a previous set of data
  • GraphView

    Download page: GraphViewRelease date: 2016-02-23Support Version: –Author: MicrosoftFree version: YesPrice: No

    GraphView is a DLL library that enables users to use SQL Server or Azure SQL Database to manage graphs. It connects to a SQL database locally or in the cloud, stores graph data in tables and queries graphs through a SQL-extended language.

    Microsoft Baseline Security Analyze

    Download page: Baseline Security AnalyzeRelease date: 2015-01-09Support Version: –Author: MicrosoftFree version: YesPrice: NoInstruction: http://www.sqlshack.com/how-to-install-and-use-microsoft-baseline-security-analyzer-mbsa/

    The Microsoft Baseline Security Analyzer provides a streamlined method to identify missing security updates and common security misconfigurations. MBSA 2.3 release adds support for Windows 8.1, Windows 8, Windows Server 2012 R2, and Windows Server 2012. Windows 2000 will no longer be supported with this release.

    tablediff Utility

    Download page: tablediff UtilityRelease date: –Support Version: 2005-2016Author: MicrosoftFree version: YesPrice: NoInstruction: SQL Server tablediff utility by Robert Sheldon

    The tablediff utility is used to compare the data in two tables for non-convergence, and is particularly useful for troubleshooting non-convergence in a replication topology. This utility can be used from the command prompt or in a batch file to perform the following tasks:

  • A row by row comparison between a source table in an instance of SQL Server acting as a replication Publisher and the destination table at one or more instances
  • Perform a fast comparison by only comparing row counts and schema.
  • Perform column-level comparisons.
  • Generate a Transact-SQL script to fix discrepancies at the destination server to bring the source and destination tables into convergence.
  • Log results to an output file or into a table in the destination database.
  • Microsoft Log Parser

    Download page: Microsoft Log ParserRelease date: –Support Version: –Author: MicrosoftFree version: YesPrice: NoInstruction: Microsoft Log Parser Utility: Swell ETL by Robert Sheldon

    Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files,XML files and CSV files, as well as key data sources on the Windows operating system such as the Event Log, the Registry, the file system, and Active Directory.

    Log Parser Lizard GUI

    Download page: Log Parser Lizard GUIRelease date: 2017-06-01Support Version: 2008-2017Author: Lizard LabsFree version: YesPrice: $59

    Log Parser Lizard is a GUI for Microsoft Logparser, definitely the best one available on the market today. Log Parser is a very powerful and versatile query software tool that provides universal query access (using SQL) to text-based data, such as log files, XML files, and TSV/CSV text files, as well as key data sources on the Microsoft Windows operating system, such as the Windows Event Log, IIS log, the registry, the File System, the Active Directory services and much more.

    Diskspd

    Download page: DiskspdRelease date: 2015-12-14Support Version: –Author: MicrosoftFree version: Yes

    DISKSPD is a storage load generator / performance test tool from the Windows/Windows Server and Cloud Server Infrastructure Engineering teams. Compilation is supported with Visual Studio and Visual Studio Express. Use the Visual Studio solution file inside the diskspd_vs2013 directory.

    HammerDB

    Download page: HammerDBRelease date: 2015-05-04Support Version: –Author: Open SourceFree version: YesPrice: No

    HammerDB is an open source database load testing and benchmarking tool for Oracle, SQL Server, DB2, TimesTen, PostgreSQL, Greenplum, Postgres Plus Advanced Server, MySQL, Redis and Trafodion SQL on Hadoop.

    Microsoft Exchange Server Error Code Look-up

    Download page: Exchange Server Error Code Look-upRelease date: 2004-05-10Support Version: –Author: MicrosoftFree version: YesUseful link: http://www.sqlshack.com/how-to-install-and-use-microsoft-baseline-security-analyzer-mbsa/

    Determine error values from decimal and hexadecimal error codes in Microsoft Windows operating systems.

    LINQPad

    Download page: LINQPadRelease date: 2016-02-01Support Version: 2008/2012/2014/2016Author: Joseph AlbahariFree version: YesPrice: $45

    Instantly test any C#/F#/VB snippet or program, Query databases in LINQ (or SQL) — SQL/CE/Azure, Oracle, SQLite & MySQL. Standard edition free, with no expiry. Enjoy rich output formatting, optional autocompletion and integrated debugging, Script and automate in your favorite .NET language, Super lightweight — single 15MB executable! SQL Server query execution plan visualizer for LINQPad http://bit.ly/QueryPlanVisualizer

    SqlDynamite

    Download page: SqlDynamiteRelease date: 2016-04-06Support Version: 2008/2012/2014/2016Author: Anatoly SovaFree version: YesPrice: No

    Easy text search in stored procedures, functions, tables, views and triggers. Supports MSSQL, Oracle, SAP, Firebird, Mysql, PostgreSQL, DB2, Informix, SQLite, Ingres, SQL Azure, Interbase.

    SQL Server Data Tools

    Download page: SQL Server Data ToolsRelease date: 2018-04-10Support Version: 2008-2017/AzureAuthor: MicrosoftFree version: YesPrice: No

    SQL Server Data Tools (SSDT) is a modern development tool that you can download for free to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

    Database Health Monitor

    Download page: Database Health MonitorRelease date: 2016-03-20Support Version: 2008/2012/2014/2016Author: Steve StedmanFree version: YesPrice: No

    Database Health Monitor is a powerful performance monitoring and diagnostics solution that alerts administrators to server health, performance or availability problems within their SQL Server environment, all from a central console.

    SchemaDrift

    Download page: SchemaDriftRelease date: 2016-02-28Support Version: 2008/2012/2014Author: Steve StedmanFree version: YesPrice: No

    SchemaDrift is a SQL Server database comparison tool that allows you to compare the schema, the tables, indexes, stored procedures, functions, and much more between SQL Server databases

    DBeaver

    Download page: DBeaverRelease date: 2018-09-24Support Version: 2005-2017Author: Open SourceFree version: YesPrice: No

    Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MongoDB, Cassandra, etc

    HeidiSQL

    Download page: HeidiSQLRelease date: 2017-12-19Support Version: 2005-2017Author: Open SourceFree version: YesPrice: No

    HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data either to SQL file, clipboard or to other servers.

    SQLExecStats

    Download page: SQLExecStatsRelease date: 2016-02-08Support Version: 2008/2008R2/2012/2014Author: Joe ChangFree version: YesPrice: No

  • Automate collection of key DMVs for query tuning.
  • Collates query exec stats with execution plan details.
  • Cross reference index usage by execution plan, what plans reference infrequently used indexes.
  • Saves XML plan for top queries.
  • Save information directly to Microsoft Excel 2003 file format and in binary.
  • ExpressProfiler

    Download page: ExpressProfilerRelease date: 2016-02-15Support Version: 2008/2008R2/2012/2014Author: Chris MooreFree version: YesPrice: No

    ExpressProfiler (aka SqlExpress Profiler) is a simple and fast replacement for SQL Server Profiler with basic GUI and integration with Red Gate Ecosystem project.

    Data Migration Assistant

    Download page: Data Migration AssistantRelease date: 2017-03-15Support Version: 2005/2008/2008R2/2012/2014/2016/AzureAuthor: MicrosoftFree version: YesPrice: No

    Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It allows you to not only move your schema and data, but also uncontained objects from your source server to your target server.

    SQL Server Migration Assistant for Sybase

    Download page: Migration Assistant for SybaseRelease date: 2017-02-17Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    Microsoft SQL Server Migration Assistant (SSMA) for Sybase is a tool to automate migration from MySQL database(s) to SQL Server and Azure SQL DB.

    dta Utility

    Download page: dta UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    Capture performance and usage data about your Microsoft SQL Server 2005+ databases to inform insights and improve troubleshooting. Key real-time metrics provide an overview of your databases and detailed measurements about memory usage, connections, network I/O, and file I/O.

    osql Utility

    Download page: osql UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The osql utility allows you to enter Transact-SQL statements, system procedures, and script files.This utility uses ODBC to communicate with the server.

    sqldiag Utility

    Download page: sqldiag UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The SQLdiag utility is a general purpose diagnostics collection utility that can be run as a console application or as a service.You can use SQLdiag to collect logs and data files from SQL Server and other types of servers, and use it to monitor your servers over timeor troubleshoot specific problems with your servers.SQLdiag is intended to expedite and simplify diagnostic information gathering for Microsoft Customer Support Services.

    sqldumper Utility

    Download page: sqldumper UtilityRelease date: –Support Version: 2005/2008/2008R2/2012Author: MicrosoftFree version: YesPrice: No

    You can use the Sqldumper.exe utility to generate a dump file on demand for any Microsoft Windows application.For example, you can generate a dump file for debugging an application problem when a computer that is running SQL Server 2005,Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2012 is not responding to user requests.A dump file can be a mini-dump file, a full dump file, or a filtered dump file.

    SqlLocalDB Utility

    Download page: SqlLocalDB UtilityRelease date: –Support Version: 2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    SqlLocalDB lets you create, delete, start, stop, and perform a number of other related tasks on an instance of SQL Server 2012 Express LocalDB,an execution mode of SQL Server Express that’s targeted at developers. A LocalDB instance uses a minimal set of files to start the database engine.

    sqllogship Utility

    Download page: sqllogship UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The sqllogship application performs a backup, copy, or restore operation and associated clean-up tasks for a log shipping configuration.The operation is performed on a specific instance of Microsoft SQL Server for a specific database.

    sqlservr Application

    Download page: sqlservr ApplicationRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The sqlservr application starts, stops, pauses, and continues an instance of Microsoft SQL Server from a command prompt.

    sqlps Utility

    Download page: sqlps UtilityRelease date: –Support Version: 2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The sqlps utility starts a Windows PowerShell 2.0 session with the SQL Server PowerShell provider and cmdlets loaded and registered. You can enter PowerShell commands or scripts that use the SQL Server PowerShell components to work with instances of SQL Server and their objects. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use the sqlps PowerShell module instead.

    sqlmaint Utility

    Download page: sqlmaint UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The sqlmaint utility performs a specified set of maintenance operations on one or more databases. Use sqlmaint to run DBCC checks, back up a database and its transaction log, update statistics, and rebuild indexes. All database maintenance activities generate a report that can be sent to a designated text file, HTML file, or e-mail account. sqlmaint executes database maintenance plans created with previous versions of SQL Server. To run SQL Server maintenance plans from the command prompt, use the dtexec Utility. This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use SQL Server maintenance plan feature instead.

    Ssms Utility

    Download page: Ssms UtilityRelease date: –Support Version: 2005/2008/2008R2/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The Ssms utility opens SQL Server Management Studio. If specified, Ssms also establishes a connection to a server, and opens queries, scripts, files, projects, and solutions. You can specify files that contain queries, projects, or solutions. Files that contain queries are automatically connected to a server if connection information is provided and the file type is associated with that type of server. For instance, .sql files will open a SQL Query Editor window in SQL Server Management Studio, and .mdx files will open an MDX Query Editor window in SQL Server Management Studio. SQL Server Solutions and Projects will open in SQL Server Management Studio.

    dtexec Utility

    Download page: dtexec UtilityRelease date: –Support Version: 2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    The dtexec command prompt utility is used to configure and execute SQL Server Integration Services packages. The dtexec utility provides access to all the package configuration and execution features, such as parameters, connections, properties, variables, logging, and progress indicators. The dtexec utility lets you load packages from these sources: the Integration Services server, an .ispac project file, a Microsoft SQL Server database, the SSIS Package Store, and the file system.

    SQL Server 2016 Report Builder

    Download page: SQL Server 2016 Report BuilderRelease date: 2016-09-16Support Version: 2016Author: MicrosoftFree version: YesPrice: No

    Report Builder provides a productive report-authoring environment for IT professionals and power users. The download provides a stand-alone installer for Report Builder.

    Report Builder provides data visualizations that include charts, maps, sparklines, and data bars that can help produce new insights well beyond what can be achieved with standard tables and charts. Use Report Builder to create reports and shared datasets. Publish report parts, and then browse the Report Part Gallery to reuse existing report parts as building blocks for creating new reports quickly with a “grab and go” experience.

    SQL Server 2005 Best Practices Analyzer

    Download page: BPA 2005Release date: 2008-08-13Support Version: 2005Author: MicrosoftFree version: YesPrice: No

    The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices to determine if there are potential issues in the database environment.

    SQL Server 2000 Best Practices Analyzer

    Download page: BPA 2000Release date: 2010-04-26Support Version: 2000Author: MicrosoftFree version: YesPrice: No

    SQL Server 2000 Best Practices Analyzer is a database management tool that lets you verify the implementation of common Best Practices on your servers.

    SQL Server 2008 R2 Best Practices Analyzer

    Download page: BPA 2008Release date: 2010-06-18Support Version: 2008/2008R2Author: MicrosoftFree version: YesPrice: No

    The Microsoft SQL Server 2008 R2 BPA is a diagnostic tool that performs the following functions:

  • Gathers information about a Server and a Microsoft SQL Server 2008 or 2008 R2 instance installed on that Server
  • Determines if the configurations are set according to the recommended best practices
  • Reports on all configurations, indicating settings that differ from recommendations
  • Indicates potential problems in the installed instance of SQL Server
  • Recommends solutions to potential problems
  • SQL Server 2012 Best Practices Analyzer

    Download page: BPA 2012Release date: 2012-04-06Support Version: 2012Author: MicrosoftFree version: YesPrice: No

    The Microsoft SQL Server 2012 BPA is a diagnostic tool that performs the following functions:

  • Gathers information about a Server and a Microsoft SQL Server 2012 instance installed on that Server
  • Determines if the configurations are set according to the recommended best practices
  • Reports on all configurations, indicating settings that differ from recommendations
  • Indicates potential problems in the installed instance of SQL Server
  • Recommends solutions to potential problems
  • DLM Dashboard

    Download page: DLM DashboardRelease date: 2016-04-27Support Version: 2005/2008/2012/2014Author: Red GateFree version: YesPrice: No

    DLM Dashboard tracks your database schemas and alerts you when they change. DLM Dashboard monitors up to 50 of your databases, and sends you an email alert as soon as your databases start to drift, or change from their expected state. On the web dashboard, you can see exactly what changed, who made the changes, and when.

    Red Gate SQL Compare

    Download page: Red Gate SQL CompareRelease date: 2016-10-31Support Version: 2005/2008/2012/2014/2016Author: Red GateFree version: NoPrice: $495

    Compares and synchronizes SQL Server database schemas

    Red Gate SQL Data Compare

    Download page: Red Gate SQL Data CompareRelease date: 2016-05-09Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $495

    SQL Data Compare is the industry-standard tool for comparing and deploying SQL Server database contents

    Red Gate SQL Prompt

    Download page: Red Gate SQL PromptRelease date: 2016-04-28Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $369

    Write, format and refactor SQL effortlessly

    Red Gate SQL Monitor

    Download page: Red Gate SQL MonitorRelease date: 2015-10-15Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $1495

    Real-time SQL Server performance monitoring, with alerts and diagnostics

    Red Gate SQL Backup Pro

    Download page: Red Gate SQL Backup ProRelease date: 2014-07-08Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $995

    Compress, verify, and encrypt SQL Server backups

    Red Gate SQL Doc

    Download page: Red Gate SQL DocRelease date: 2016-04-26Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $369

    Document your databases automatically, create documents as HTML, PDF, Microsoft Word or Compiled HTML Help files

    Red Gate SQL Data Generator

    Download page: Red Gate SQL Data GeneratorRelease date: 2016-04-26Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $369

    Generate realistic test data fast

    Red Gate SQL Dependency Tracker

    Download page: Red Gate SQL Dependency TrackerRelease date: 2016-04-26Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $369

    Visualize complex databases simply

    Red Gate SQL Multi Script

    Download page: Red Gate SQL Dependency TrackerRelease date: 2016-04-15Support Version: 2005/2008/2012/2014Author: Red GateFree version: NoPrice: $245

    Deploy multiple scripts to multiple servers with just one click

    Red Gate SQL Index Manager

    Download page: Red Gate SQL Index ManagerRelease date: ?Support Version: 2008/2012/2014Author: Red GateFree version: NoPrice: $149

    Analyze, manage, and fix database index fragmentation

    Red Gate SQL Comparison SDK

    Download page: Red Gate SQL Comparison SDKRelease date: 2016-02-22Support Version: 2008/2012/2014Author: Red GateFree version: NoPrice: $895

    Compare and synchronize automatically database schemas and data

    Red Gate SQL Clone

    Download page: Red Gate SQL CloneRelease date: 2017-02-27Support Version: 2008-2017Author: Red GateFree version: NoPrice: $6955

  • SQL Clone is a database provisioning tool that lets you create full copies of SQL Server databases and backups in seconds, using around 40MB of disk space per clone.
  • Instead of spending hours provisioning copies of your database for development, testing, or diagnostics, SQL Clone creates one data image of a SQL Server database or backup, which you use as the source for clones.
  • Clones work just like normal databases. You can connect to them and edit them using any program. SQL Clone's web app provides an easy central place to create and manage clones.
  • With SQL Clone, your team can work locally on up-to-date, isolated copies of the database to speed up development, accurately test code, and fix issues faster.
  • Red Gate SQL Provision

    Download page: Red Gate SQL ProvisionRelease date: 2018-02-26Support Version: 2008-2017Author: Red GateFree version: NoPrice: $2955

    Create, protect, and manage SQL Server database copies for compliant DevOps

    Red Gate SQL Data Masker

    Download page: Red Gate SQL Data MaskerRelease date: 2018-02-26Support Version: 2008-2017Author: Red GateFree version: NoPrice: $2355

    Replace sensitive data with realistic, anonymized, test data

  • Multiple methods to sanitize sensitive information
  • Use templates to remain consistent with existing data formats
  • Replacement data sets included, such as Names, Zip Codes, Emails
  • Populate test data as well as sanitize existing information
  • Simple, repeatable, fast, and easy to use
  • Supports SQL Server and Oracle databases
  • DLM Automation

    Download page: DLM AutomationRelease date: ?Support Version: 2008/2012/2014Author: Red GateFree version: NoPrice: ?

    Automate your database changes with continuous integration and automated deployment

    ReadyRoll

    Download page: ReadyRollRelease date: 2016-03-01Support Version: 2012/2014Author: Red GateFree version: NoPrice: $345

    It generates numerically ordered SQL migration scripts that sit inside your project and take your schema from one version to the next. You can add them to version control, use them to build and release, and automate database and application deployments, all in one process.

    Rapid Database Extractor

    Download page: Rapid Database ExtractorRelease date: 2016-11-03Support Version: 2008/2012/2014/2016/AzureAuthor: IderaFree version: YesPrice: No

  • Manage SQL Server and Oracle data sources
  • Manipulate database objects
  • Interactively edit SQL code
  • Selectively execute SQL queries to retrieve data
  • Export data to common file formats
  • Connect to cloud and run in cloud (provisional)
  • SQL XEvent Profiler

    Download page: SQL XEvent ProfilerRelease date: 2014-03-14Support Version: 2012/2014Author: IderaFree version: YesPrice: No

    Idera’s SQL XEvent Profiler emulates the functionality and simplicity of SQL Server Profiler, letting you quickly view data from SQL eventsand see whats happening on the server. Plus, it leverages SQL Extended Events (XEvents) as the backing technology — making it more efficient than SQL Trace.

    SQL Check

    Download page: SQL CheckRelease date: 2015-09-24Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Check out what happens in batches, compilations, recompilations, and transactions throughout the SQL Server environment
  • Monitor some of the most important metrics in SQL Server including wait stats, reads, writes, session details, and cache hits
  • See SQL operations as they occur for the latest information; consider it a heart rate monitor for your SQL Server environment
  • Install easily without agents
  • SQL Fragmentation Analyzer

    Download page: SQL Fragmentation AnalyzerRelease date: 2012-11-16Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Analyze fragmentation by one table or an entire database
  • Identify databases in need of defragmentation
  • Set fragmentation thresholds: normal, warning, critical
  • SQL Heat Map

    Download page: SQL Heat MapRelease date: 2016-01-27Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Get one visual view of storage in all tables of a database
  • See storage allocation, utilization, and type of data
  • Quickly locate tables and indexes that need more allocated storage
  • SQL Hekaton Memory Check

    Download page: SQL Hekaton Memory CheckRelease date: 2015-06-10Support Version: 2014Author: IderaFree version: YesPrice: No

  • Monitor the impact of memory optimized tables on server memory
  • Identify high memory utilizing tables
  • Assess server memory capacity
  • Simulate moving to In-Memory OLTP
  • SQL Page Viewer

    Download page: SQL Page ViewerRelease date: 2014-08-25Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Displays page level data summary and detail information
  • Has elegant GUI design for fast access in 1 click
  • Can select any SQL server and database table
  • Can navigate to any page data quickly in a tree view
  • Can launch directly within SSMS for optimal usability
  • SQL Update Statistics

    Download page: SQL Update StatisticsRelease date: 2015-12-14Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Launch directly within SSMS for optimal usability
  • Identify out-of-date SQL Server table and index statistics
  • View and change database statistics options
  • Create graphical histograms for each column’s statistics
  • SQL Statistics Aggregator

    Download page: SQL Statistics AggregatorRelease date: 2015-05-18Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Aggregate IO statistics to identify problem tables
  • Correlate disk activity with query plan nodes
  • Compare runs of a query over time
  • Export and import results for easy collaboration
  • SQL Backup Status Reporter

    Download page: SQL Backup Status ReporterRelease date: 2015-08-07Support Version: 2005/2008/2008R2/2012Author: IderaFree version: YesPrice: No

  • Quickly identify databases which have not had backups
  • View backup history including the backup date and type
  • Have simplified grid view for easy sorting and navigation
  • Identify full and differential backups for many databases
  • SQL Integrity Check

    Download page: SQL Integrity CheckRelease date: 2013-08-26Support Version: 2005/2008/2008R2/2012Author: IderaFree version: YesPrice: No

  • Easily run a CHECKDB for any database on-demand
  • View integrity check results to identify corruption
  • Routinely verifies when last check was performed
  • Receive alerts when databases are due for checks
  • Do not need to write and maintain scripts
  • SQL Job Manager

    Download page: SQL Job ManagerRelease date: 2012-03-19Support Version: ?Author: IderaFree version: YesPrice: No

  • Have management console to easily view past and current jobs
  • Can identify and correct job contention
  • Can drag and drop jobs across servers to level workloads
  • Can "at a glance" view to see failed or runaway jobs
  • Have customizable calendar view
  • Azure SQL Database Backup

    Download page: Azure SQL Database BackupRelease date: 2012-10-02Support Version: ?Author: IderaFree version: YesPrice: No

  • Save time and storage space with up to 95% compression
  • Backup on-premise or to Azure BLOB storage
  • Central data storage to prevent data loss
  • View historical backup and restore operations
  • Restore with transaction consistency to and from the cloud
  • SQL Column Search

    Download page: SQL Column SearchRelease date: 2015-11-17Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: YesPrice: No

  • Find potentially sensitive data
  • Search an entire instance or a specific table
  • Export results to CSV format for easy analysis and reporting
  • SQL Permissions Extractor

    Download page: SQL Permissions ExtractorRelease date: 2015-08-07Support Version: 2005/2008/2008R2/2012Author: IderaFree version: YesPrice: No

  • Generate T-SQL scripts for copying of user permissions
  • Edit, save, and execute permissions scripts
  • Include object level permissions for selected databases
  • Copy, extract, modify and apply changes in four steps
  • SQL BI Check

    Download page: SQL BI CheckRelease date: 2016-04-13Support Version: 2005/2008/2008R2/2012Author: IderaFree version: YesPrice: No

  • Real-time performance monitoring for SQL Server Analysis Services (SSAS)
  • See physical server metrics for CPU, disk, and storage
  • View analysis metrics for SSAS processing, memory, and cache
  • Get up and running in minutes, no agents required
  • SQL Inventory Check

    Download page: SQL Inventory CheckRelease date: 2016-03-24Support Version: 2005/2008/2008R2/2012Author: IderaFree version: YesPrice: No

  • Discover unknown and forgotten instances posing security and performance risks
  • Track SQL Servers to manage license and support costs
  • Stay on top of important SQL Server updates and patches
  • SQL Diagnostic Manager

    Download page: SQL Diagnostic ManagerRelease date: ?Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $1747

  • Performance monitoring for physical and virtual environments
  • Query plan monitoring to see the causes of blocks and deadlocks
  • Integrated SQL Doctor expert recommendations
  • Easy integration with Microsoft SCOM
  • Predictive alerting with settings to avoid false alerts
  • Web-based dashboard with at-a-glance views of top issues and alert
  • SQL Safe Backup

    Download page: SQL Safe BackupRelease date: 2016-03-24Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $907

  • Backup faster than native SQL and save space with dynamic compression
  • Reduce failures due to network problems
  • Automate full, differential, and transaction log backups
  • Integrated cloud backup support for Amazon S3
  • Instant Restore provides immediate access to backup data
  • Web-based dashboard provides at-a-glance views of top issues and alerts
  • SQL Compliance Manager

    Download page: SQL Compliance ManagerRelease date: 2015-09-08Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $2657

  • Audit Sensitive Data – see who did what, when, where, and how
  • Track and Detect – monitor and alert on suspicious activity
  • Satisfy Audits – for PCI, HIPAA, FERPA and SOX requirements
  • Generate Reports – 25 built-in reports to validate SQL Server audit trails
  • Minimize Overhead – light data collection agent minimizes server imp
  • SQL Inventory Manager

    Download page: SQL Inventory ManagerRelease date: 2016-04-22Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $3195

  • View your SQL Server inventory – know what you have where & who owns it
  • Auto-discover any new servers installed, to better manage server sprawl
  • Get alerts when a server goes down, or space is running low
  • Set tags to better organize servers and databases across the enterprise
  • Quickly deploy and access from anywhere via web-based and agentless UI
  • SQL Virtual Database

    Download page: SQL Virtual DatabaseRelease date: 2016-03-24Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $625

  • Immediate access – get data from backup files instantly
  • Acts like a real database – Use 3rd party and native tools
  • OLR replacement – better solution to object level recovery
  • Multiple Uses – reporting, data extraction, analysis, etc.
  • Read/Write support – inserts, updates, DBCC commands
  • SQL Secure

    Download page: SQL SecureRelease date: 2016-04-19Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $907

  • Identify existing vulnerabilities in your SQL Servers
  • Harden security policies across SQL Servers
  • Rank security levels with the security report card
  • Analyze and report user permissions across SQL Servers
  • Customizable templates for PCI, HIPAA and more
  • SQL Doctor

    Download page: SQL DoctorRelease date: 2015-12-17Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $625

  • New and enhanced Expert Recommendations to help improve performance
  • Dashboard exposes performance metrics in real-time
  • "Quick Findings" instantly locates SQL performance issues
  • Executable scripts are generated to optimize performance
  • Stored history of analysis recommendations for trending
  • SQL Admin Toolset

    Download page: SQL Admin ToolsetRelease date: 2016-01-13Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $325

  • 24 essential desktop tools for your everyday SQL Server needs
  • Run every day diagnostics across multiple SQL servers
  • Complete administrative tasks in minutes, not hours
  • Perform analysis on your SQL data
  • SQL Defrag Manager

    Download page: SQL Defrag ManagerRelease date: 2016-03-10Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $1495

  • Automate identification of index fragmentation "hot spots"
  • Schedule index defragmentation jobs
  • Avoid database contention with system resource pre-checks
  • Reduce page splits with index fill factor settings control
  • Centrally manage, report and notify instantly
  • DBArtisan

    Download page: DBArtisanRelease date: ?Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $3122

  • Manage multiple platforms (Oracle, SQL Server, DB2, Sybase) from one UI
  • Proactively manage space, data and performance with built-in analytics
  • Easily find and fix performance issues using intelligent diagnostics
  • Move schema and table data across different platforms with ease
  • Protect data security with view, grant and revoke of permissions
  • SQL BI Manager

    Download page: SQL BI ManagerRelease date: 2015-09-08Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $697

  • Monitor SSAS, SSRS, & SSIS health with agentless monitoring
  • View active sessions, workload, and report generation performance
  • Identify issues with access to data including cube size and resource utilization
  • Set up alerts with configurable thresholds
  • Log in from anywhere for at-a-glance views of top issues and alerts
  • SQL Enterprise Job Manager

    Download page: SQL Enterprise Job ManagerRelease date: 2015-09-08Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $697

  • Monitor SQL Server agent jobs across the enterprise
  • Easily view job status and details with familiar calendar layout
  • Chain jobs together and build automated workflows
  • Configure and manage jobs that run over multiple instances
  • Set alerts to be notified of potential issues
  • Web-based architecture simplifies deployment
  • DB Optimizer

    Download page: DB OptimizerRelease date: ?Support Version: 2005/2008/2008R2/2012Author: IderaFree version: NoPrice: $1420

  • Streamline tuning of SQL code on major DBMSs from one interface
  • Tune SQL like a pro with automated performance optimization suggestions
  • Tackle complex SQL queries with visual SQL tuning diagrams
  • Pinpoint problem SQL with database profiling of wait-time analysis
  • Load test alternative SQL queries in simulated production environment
  • SQL Query Store Optimizer

    Download page: SQL Query Store OptimizerRelease date: 2016-07-01Support Version: 2016Author: IderaFree version: YesPrice: No

  • Improve SQL Server 2016 Query Store performance
  • See all Query Store properties in single summary table
  • Execute predefined actions that modify Query Store properties and contents
  • Edit all modifiable Query Store properties in single overview panel
  • Get up and running in minutes with no agents
  • Rapid SQL

    Download page: Rapid SQLRelease date: ?Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: NoPrice: $710

  • Create high-performing SQL code on major DBMSs from one interface
  • Easily build complex SQL statements with visual query builder
  • Quickly construct, analyze and execute SQL code with code analyst
  • Simplify debugging SQL code, functions, and stored procedures
  • Collaborate effectively across development teams with version control
  • SQL Comparison Toolset

    Download page: SQL Comparison ToolsetRelease date: ?Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: NoPrice: $745

  • Compare and synchronize SQL Server data and schema objects
  • Easy navigation of user interface improves efficiency
  • Automate comparison and synchronization operations
  • Customize schema compare and synchronization sessions
  • Generate ready-to-use database synchronization scripts
  • ER/Studio Data Architect

    Download page: ER/Studio Data ArchitectRelease date: ?Support Version: 2005/2008/2008R2/2012/2014Author: IderaFree version: NoPrice: $1287

  • Create effective models to build a business-driven data architecture
  • Document and enhance existing databases to reduce redundancy
  • Implement naming standards to improve data consistency and quality
  • Effectively share and communicate models across the enterprise
  • Map data sources and trace origins to enhance data lineage
  • DB Change Manager

    Download page: DB Change ManagerRelease date: ?Support Version: 2005/2008/2008R2/2012/2014/2016Author: IderaFree version: NoPrice: $1420

  • Quickly roll out and reconcile database changes
  • Reveal, track, and report on database changes
  • Comply with database audit and reporting requirements
  • Protect data privacy within the database environment
  • Track changes from multiple major database platforms
  • Uptime Infrastructure Monitor

    Download page: Uptime Infrastructure MonitorRelease date: ?Support Version: ?Author: IderaFree version: NoPrice: ?

  • Monitor servers, VMs, network devices, and applications from a unified dashboard
  • Use historic data to plan for future server capacity needs
  • Track service-level performance trends for SLA compliance and reporting
  • Monitor virtually anything via a multitude of pre-built plug-ins or custom scripts
  • Streamline incident management with native ServiceNow integration
  • dbForge Schema Compare

    Download page: dbForge Schema CompareRelease date: 2017-09-15Support Version: SQL Azure/2000/2005/2008/2008R2/2012/2014/2016/2017Author: DevartFree version: NoPrice: $150

    dbForge Schema Compare for SQL Server is a reliable tool that will save you time and effort when you need to compare databases on SQL Server. The relentlessly tested compare tool allows working with live SQL Server databases, database snapshots, and backups. You can compare your SQL Server databases, analyze differences and synchronize your schemas using generated SQL script in a well-designed user interface quickly and without errors.

    dbForge Data Compare

    Download page: dbForge Schema CompareRelease date: 2017-08-30Support Version: SQL Azure/2000/2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $149

    dbForge Data Compare for SQL Server is a powerful, fast and easy to use SQL comparison tool, capable of using native SQL Server backups as metadata source. With dbForge Data Compare you can tune your SQL database comparison, quickly analyze differences in a well-designed user interface and effortlessly synchronize data via a convenient wizard with additional options.

    dbForge Data Generator

    Download page: dbForge Data GeneratorRelease date: 2017-09-15Support Version: Amazon RDS/SQL Azure/2000/2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $249

    dbForge Data Generator for SQL Server is a powerful GUI tool for fast generation of meaningful test data. The tool includes 190+ predefined generators with sensible configuration options, that allow emulating column-intelligent real-world data. dbForge Data Generator for SQL Server can save your time and effort by populating SQL Server tables with millions of rows of test data that looks just like real data.

    dbForge Query Builder

    Download page: dbForge Query BuilderRelease date: 2017-08-30Support Version: Amazon RDS/SQL Azure/2000/2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $99

    dbForge Query Builder for SQL Server allows users to build complex SQL queries via an intuitive visual query building interface easily and without manual code writing. This SQL query designer will be useful to those, who often create queries to databases. Visual features to create queries, usage of graphical SQL query creator to interactively build queries, would be most appreciated by users who have no experience in writing queries manually. But even experienced users can save a lot of time on routine work.

    dbForge Event Profiler

    Download page: dbForge Event ProfilerRelease date: 2017-08-30Support Version: 2008/2012/2014/2016Author: DevartFree version: YesPrice: No

    dbForge Event Profiler for SQL Server is a FREE tool that allows you to capture and analyze SQL Server events. The events and data columns are stored in a physical trace file for later examination. You can use this information to identify and troubleshoot many SQL Server-related problems.

    dbForge SQL Decryptor

    Download page: dbForge SQL DecryptorRelease date: 2017-04-20Support Version: 2000/2005/2008/2008R2/2012/2014/2016Author: DevartFree version: YesPrice: No

    Decrypt SQL Server Procedures, Functions, Triggers, and Views

    dbForge Studio

    Download page: dbForge StudioRelease date: 2017-08-03Support Version: 2005/2008/2008R2/2012/2014/2016/2017/Amazon RDS/SQL AzureAuthor: DevartFree version: YesPrice: $249

  • Code completion — to create whole SQL statement in a few keystrokes
  • SQL formatting — to follow common coding style (standard)
  • SQL snippets — to save time storing and reusing repeated code fragments
  • Quick object information — to show hints with info on database objects
  • Code navigation — quick jump by F12 to variable declaration, object editor, etc.
  • dbForge Fusion

    Download page: dbForge FusionRelease date: 2016-12-27Support Version: Amazon RDS/SQL Azure/2000/2005/2008/2008R2/2012/2014Author: DevartFree version: NoPrice: $149

    dbForge Fusion for SQL Server is a powerful Visual Fusion plugin designed to simplify SQL database development and enhance data management capabilities. When you integrate dbForge Fusion for SQL Server into Microsoft Visual Fusion, all database development and administration tasks become available from your IDE. It provides an easier way to explore and maintain existing databases, design compound SQL statements and queries, and manipulate data in different way.

    dbForge Documenter

    Download page: dbForge DocumenterRelease date: 2017-08-30Support Version: 2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $149

    dbForge Documenter for SQL Server is a big time saver when it comes to documentation of SQL Server databases. This tool automatically generates documentation of an entire SQL Server database in a few clicks. The tool includes a wide range of options to customize the generated documentation to meet your specific requirements.

    dbForge Developer Bundle

    Download page: dbForge Developer BundleRelease date: 2017-08-30Support Version: 2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $849

    Developer Bundle for SQL Server is a tool pack that extends SSMS with many essential features aimed not only boost developers' productivity but also reduce expenses while performing routine tasks.

  • Increase productivity, when creating complex queries and code writing with SQL Complete, Search, Documenter and Query Builder.
  • Save your time while comparing and synchronizing data and schema with Source Control, Data Compare, and Schema Compare.
  • Simplify the testing process drastically and generate intensional test data with Data Generator and Unit Test.
  • Monitor SQL Server performance and troubleshoot database issues using Index Manager, Monitor, as well as Event Profiler.
  • dbForge Compare Bundle for SQL Server

    Download page: dbForge Compare Bundle for SQL ServerRelease date: 2017-08-30Support Version: 2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $299

    One solution to handle SQL data and schema diffs.

  • A variety of supported schema objects.
  • Convenient comparison wizards will help you to tune data and schema comparisons up to your needs..
  • Compare databases with different structures.
  • Manage comparison results by applying filtering, grouping, exclude or include the needed objects to continue working with them, etc.
  • Handy Synchronization wizards will help you to: create accurate synchronization scripts, migrate any schema differences, dependency check to script objects in the correct order for updates, resolve synchronization issues automatically, view warnings on controversial points prior to synchronization.
  • Command-line interface.
  • Devart Excel Add-in for SQL Server

    Download page: Devart Excel Add-in for SQL ServerRelease date: 2017-09-13Support Version: 2005/2008/2008R2/2012/2014/2016Author: DevartFree version: NoPrice: $100

    Devart Excel Add-ins allow you to work with database and cloud data in Microsoft Excel as with usual Excel spreadsheets.

    Minion Enterprise

    Download page: Minion EnterpriseRelease date: ?Support Version: 2008/2008R2/2012Author: MinionWareFree version: NoPrice: $1500

    Minion Enterprise was designed by database administrators (DBAs) specifically to address the issues that waste the most time and cause the most problems. Minion shrinks dozens of those one-at-a-time tasks down to a central process. And, it does this without the usual overhead of monitoring software. When you install Minion Enterprise, it automatically begins gathering data from instances across your enterprise. That single repository of data allows you to centrally audit, alert, report, and investigate your entire environment. Even better, it opens up a new world of central management: audit SQL and AD security, clone user permissions across servers, standardize and enforce SQL Server settings, automate error log searches, and so very much more.

    SQL Server Compression Estimator

    Download page: SQL Server Compression EstimatorRelease date: 2011-06-02Support Version: 2008/2008R2/2012Author: Bob TavlorFree version: YesPrice: No

    SQL Server Compression Estimator (SSCE) will allow you to estimate the best compression for your objects. It will estimate both ROW and PAGE compression, and will optionally report the Index Maintenance Ratio (a ratio that indicates how often an index is updated versus how often it is used to satisfy queries). You can then use that information to perhaps choose a less aggresive compression algorithm for heavily updated indexes.

    ClearTrace

    Download page: ClearTraceRelease date: 2016-07-07Support Version: 2008/2012/2014/2016Author: Bill GrazianoFree version: YesPrice: No

    ClearTrace imports SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008, SQL Server 2005, SQL Server 2000 trace and Profiler files into SQL Server and displays summary performance information.

    Dell Security Explorer

    Download page: Dell Security ExplorerRelease date: 2015-06-25Support Version: 2008/2012/2014Author: DellFree version: NoPrice: $850

    This single toolset maximizes productivity through extensive automation, intuitive workflows and built-in expertise. Plus, it complements Microsoft tools by solving key SQL Server challenges, so you can proactively manage large numbers of databases. It also makes it easy to manage change, resolve issues quickly and promote the highest levels of code quality, performance and maintainability.

    Dell LiteSpeed for SQL Server

    Download page: Dell Security ExplorerRelease date: 2015-07-31Support Version: 2008/2012/2014Author: DellFree version: NoPrice: ?

    Dramatically reduce backup and restore times and minimize storage costs while increasing the reliability of SQL Server data protection operations across the entire enterprise. Easily manage and monitor SQL Server protection while delivering a wide array of recovery capabilities. With LiteSpeed, a complete workbench of SQL Server recovery tools are at your fingertips so you can get data back online — fast.

    Dell Toad for SQL Server

    Download page: Dell Toad for SQL ServerRelease date: 2015-05-12Support Version: 2008/2008R2/2012/2014Author: DellFree version: NoPrice: ?

    Use a single console to manage access controls, permissions and security across Microsoft platforms that span multiple servers. Security Explorer provides an array of security enhancements, including the ability to identify who has rights to resources across the entire organization. You can also grant, revoke, clone, modify and overwrite permissions quickly and from a central location. Unlike native tools, Security Explorer provides the ability to back up and restore permissions only, ensuring the integrity of data. Security Explorer provides on-the-fly reports to help meet auditing requirements.

    Dell Spotlight

    Download page: Dell SpotlightRelease date: 2016-03-10Support Version: 2008/2008R2/2012/2014Author: DellFree version: NoPrice: $2561

    When you can diagnose SQL Server performance issues quickly and accurately, ensuring a healthy database infrastructure is not just possible, but easy. Spotlight on SQL Server Enterprise delivers simplicity without compromise by providing unmatched monitoring, diagnosis and optimization of your SQL Server environments, ensuring peak performance around the clock. With intuitive overviews of enterprise health and performance, automated alerts and actions, an integrated Xpert tuning module and mobile device support, Spotlight on SQL Server Enterprise makes it easier than ever to obtain the data you need to ensure the health of your SQL Server databases.

    Dell Foglight

    Download page: Dell FoglightRelease date: 2015-09-22Support Version: 2008/2008R2/2012/2014Author: DellFree version: NoPrice: ?

    Ensure optimal database performance with comprehensive database, storage and virtualization monitoring and advanced workload analytics. Foglight for Databases enables you to consolidate and standardize database performance management across your diverse multi-platform environments – even when you use native or third-party tools — to promote collaboration, improve service levels and reduce costs. Get a wealth of information at a fraction of the impact of conventional collection methods.

    Dell Discovery Wizard

    Download page: Dell FoglightRelease date: 2011-09-22Support Version: 2008/2008R2/2012/2014Author: DellFree version: YesPrice: No

  • Take inventory of your network databases, including data amounts
  • Choose the databases you want to consolidate
  • Review database history, including installation and creation dates
  • Find the SQL Server versions and service packs currently deployed
  • Identify names of servers, instances and operating systems
  • Learn the identity of your end users
  • Dell Enterprise Reporter

    Download page: Dell Enterprise ReporterRelease date: ?Support Version: 2008/2008R2/2012/2014Author: DellFree version: NoPrice: $511

    Dell Enterprise Reporter for SQL Server provides ad-hoc reporting for visibility database security configuration, including users and logins, roles and database permissions

    SQL Scripter

    Download page: SQL ScripterRelease date: 2013-02-24Support Version: ?Author: Thomas HinsenkampFree version: NoPrice: €99

    SQL Scripter is a powerful tool for Microsoft SQL Server database administrators and developers to generate data scripts in a readable and executable T-SQL format.

    Simple Dynamic Scheduler

    Download page: Simple Dynamic SchedulerRelease date: 2016-05-02Support Version: 2008/2012/2014Author: Miljan RadovicFree version: YesPrice: No

    Simple Dynamic Scheduler is alternative scheduling utility which uses SQL Server to store all configurations and logic.

  • Simple – Easy to manage (once you finish reading this page)
  • Dynamic – Not static
  • Purely T-SQL – says it all
  • Open source – Adoptable code to suit your business needs
  • Light-weight – Provides only decision machanism (Run or Hold) without actually executing anything
  • ApexSQL Audit

    Download page: ApexSQL AuditRelease date: 2017-07-11Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $1699

  • Audit all SQL database and security activities
  • Meet compliance requirements e.g. HIPAA, PCI
  • Out-of-the-box and custom Win and Web reporting
  • Securely store audit data in a tamper-evident repository
  • Fully customize all auditing, alerts, and reporting
  • Who, what, where, and when type auditing
  • Deploy on SQL Server Failover Clusters
  • Easily manage auditing on multiple servers
  • ApexSQL Backup

    Download page: ApexSQL BackupRelease date: 2017-10-12Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Manage SQL backups across multiple servers
  • Configure SQL backup plans with advanced scheduling
  • Increase productivity with backup templates
  • Automatic SQL backup naming using variables
  • Restore to a point in time directly from timeline
  • Schedule and execute index maintenance tasks
  • Log shipping to multiple destinations
  • Cleanup SQL backup and restore history
  • ApexSQL Defrag

    Download page: ApexSQL DefragRelease date: 2017-06-29Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Index fragmentation analysis
  • Index defragmentation
  • Custom policies: Use custom policies to automate database index maintenance
  • Set thresholds for reorganizing and rebuilding jobs
  • ApexSQL Log

    Download page: ApexSQL LogRelease date: 2017-05-24Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $1999

  • Audit data, schema, and permission changes
  • Gain full visibility into your transaction logs
  • Rollback or replay any database transaction
  • Forensically investigate who changed what and when
  • Implement before and after auditing
  • View a complete history of row changes
  • Reverse inadvertent or malicious database transactions
  • Avoid performance overhead and data storage
  • ApexSQL Monitor

    Download page: ApexSQL MonitorRelease date: 2017-10-05Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Monitor multiple SQL Server instances
  • View system performance metrics
  • Identify performance issues and deadlocks
  • Use comprehensive dashboard for viewing metrics
  • Analyze query waits
  • Review query execution plans
  • Calculate baselines and thresholds
  • Visualize data with logarithmic scaling
  • ApexSQL Plan

    Download page: ApexSQL PlanRelease date: 2018-04-05Support Version: 2008-2017Author: ApexSQLFree version: YesPrice: No

  • Analyze and optimize SQL query execution plans
  • Identify query performance issues and deadlocks
  • Understand query performance characteristics
  • Analyze query waits & review query execution plans
  • Customize graphical query execution plan view
  • See the actual relative cost of each plan operator
  • Analyze query live performance statistics
  • Compare estimated and actual query execution plans
  • ApexSQL Propagate

    Download page: ApexSQL PropagateRelease date: 2017-09-25Support Version: 2008-2017Author: ApexSQLFree version: YesPrice: No

  • Execute scripts on saved list of servers/databases
  • Parse SQL scripts prior to execution
  • Create SQL scripts directly in the application
  • Manage lists of SQL scripts and SQL databases
  • Set order of SQL scripts execution
  • Export execution results into TXT or CSV file
  • Preview exaction results by databases or by scripts
  • Edit SQL scripts in a built-in IDE prior to execution
  • ApexSQL Build

    Download page: ApexSQL BuildRelease date: 2017-05-15Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $399

  • Create executable installation packages
  • Deploy databases directly from SQL source control
  • Consolidate multiple SQL scripts
  • Build databases from scripts, source control, etc
  • Ensure error free deployments
  • Preview the script impact by action or SQL object
  • ApexSQL Clean

    Download page: ApexSQL CleanRelease date: 2017-09-28Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $399

  • View and analyze SQL and client code dependencies
  • Perform impact analysis on potential changes
  • Remove unwanted objects risk free
  • Map dependencies down to the column level
  • Analyze external databases for dependencies
  • View object dependencies graphically
  • Design the appearance of the dependency diagram
  • Create and export reports from object dependencies
  • ApexSQL Data Diff

    Download page: ApexSQL Data DiffRelease date: 2017-10-03Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $599

  • Compare data in live DBs, backups and SC projects
  • Perform row level recovery without restoring
  • Community, Standard, and Professional editions
  • Compare huge databases quickly and without errors
  • Automate and schedule data migrations
  • Initiate database compares directly from SSMS
  • Export results to HTML, CSV and Excel
  • Create executable installation packages
  • Integrate with all popular SC systems e.g. Git, SVN
  • Deploy data changes directly from a source control label
  • ApexSQL Decrypt

    Download page: ApexSQL DecryptRelease date: 2017-08-16Support Version: 2008-2017Author: ApexSQLFree version: YesPrice: No

  • Decrypt SQL procedures, functions, triggers and views
  • Initiate decryption directly from SSMS
  • Decrypt objects with a single click
  • Filter encrypted objects
  • View original DDL script
  • Export encrypted objects into a SQL script
  • Decrypt databases from multiple servers
  • Decrypt wizard with built-in IDE
  • ApexSQL Diff

    Download page: ApexSQL DiffRelease date: 2017-10-26Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $599

  • Compare live DBs, backups, scripts and SC projects
  • Deploy a database directly from source control
  • Integrate with all popular SC systems e.g. Git, SVN
  • Automate and schedule database synchronizations
  • Initiate database compares directly from SSMS
  • Report results to HTML, XML and Excel
  • Create executable .NET packages
  • ApexSQL Doc

    Download page: ApexSQL DocRelease date: 2017-09-06Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $699

  • Document SQL Server databases and SSIS packages
  • Generate documentation in CHM, HTML, Word and PDF
  • Automate and schedule the documenting process
  • Display graphical relationship diagrams
  • Document SSAS Multidimensional and Tabular models
  • Document SSIS Control flow and Data flow diagrams
  • Fully customize the documentation output
  • Include Data model diagrams
  • ApexSQL Generate

    Download page: ApexSQL GenerateRelease date: 2017-07-13Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Generate SQL test data for specified tables
  • Export test data to SQL, XML, CSV, JSON, Excel
  • Generate millions of rows quickly
  • Customize test data plan with detailed options
  • Support a full range of SQL data types
  • Choose from multiple generators (Random List etc)
  • Retain data consistency with foreign key support
  • Emulate real-world test data
  • ApexSQL Script

    Download page: ApexSQL ScriptRelease date: 2017-05-08Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $399

  • Script both SQL database objects and data
  • Create executable .NET packages
  • Script objects directly to Source Control
  • Automate SQL database scripting and migrations
  • Integrate with popular source control systems
  • Script an entire server down to individual columns
  • Save customized scripting profiles as projects
  • Easily decrypt some/all encrypted database objects
  • ApexSQL Trigger

    Download page: ApexSQL TriggerRelease date: 2017-06-01Support Version: 2008/2012/2014/2016Author: ApexSQLFree version: NoPrice: $1299

  • Track data / DML changes in SQL Server databases
  • Integrate royalty free auditing into your apps
  • Translate data into information with lookups
  • Create reports and exports from audited data
  • Customize trigger templates with a built-in IDE
  • Add additional data to audit trail with watches
  • Track schema / DDL changes in audited database
  • Audit who, what, and when for all changes
  • ApexSQL Trigger Viewer

    Download page: ApexSQL Trigger ViewerRelease date: 2017-06-01Support Version: 2008-2017Author: ApexSQLFree version: YesPrice: No

    Read-only auditing reports for end users

    ApexSQL Snapshot Utility

    Download page: ApexSQL Snapshot UtilityRelease date: 2016-01-12Support Version: 2008/2012/2014/2016Author: ApexSQLFree version: YesPrice: No

    Utility to create a lightweight 'snapshot' of a database schema, that can be used by ApexSQL Diff as a datasource

    ApexSQL Model

    Download page: ApexSQL ModelRelease date: 2018-10-10Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $399

    Create database model diagrams and synchronize changes with existing databases.

  • Forward and reverse engineer
  • Customize the appearance of models
  • Create new or modify existing object groups
  • Navigate through model history
  • Export database models as imagesCustomize print output
  • ApexSQL Analyze

    Download page: ApexSQL AnalyzeRelease date: 2017-12-13Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $299

    Database dependency analysis

  • View and analyze SQL dependencies
  • Customize the appearance of dependency diagrams
  • Map dependencies down to the column level
  • Visualize object dependencies graphically
  • Export diagrams as image files
  • Perform impact analysis on potential object deletions
  • ApexSQL BI Monitor

    Download page: ApexSQL BI MonitorRelease date: 2018-09-18Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Monitor SSAS, SSIS and SSRS performance
  • Add custom performance counters
  • Track system performanceUse baselines to customize alert thresholds
  • View real-time and historical data
  • Set up various alert actions for each counter
  • Generate built-in and custom reportsTrack user activity
  • ApexSQL VM Monitor

    Download page: ApexSQL VM MonitorRelease date: 2018-05-09Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $999

    Virtualization performance monitoring

  • Monitor multiple hypervisors – Hyper-V and ESXi
  • View system performance metrics of monitored hosts
  • Monitor virtual machines performance
  • Monitor performance of host devices
  • Use comprehensive dashboards for viewing metrics
  • Calculate baselines and thresholds
  • View top 5 loaded virtual machines for specific hosts
  • Create and export comprehensive performance reports
  • ApexSQL VM Job

    Download page: ApexSQL JobRelease date: 2018-03-29Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $499

  • Manage SQL Server Agent jobs across multiple servers
  • Get a detailed job history overview
  • Manage SQL Server services on managed servers
  • Export job details to PDF, HTML, XML or CSV format
  • Manage SQL Server schedulesControl the status of SQL Server Agent services
  • Define and manage SQL Server alertsMonitor SQL Server Agent logs
  • ApexSQL Enforce

    Download page: ApexSQL EnforceRelease date: 2018-07-19Support Version: 2008-2017Author: ApexSQLFree version: NoPrice: $299

  • Review databases and individual SQL scripts
  • Import and export rulesProcess unattended via the CLI
  • Seamlessly integrate into your CI/CD processLeverage a library of 100+ pre-written rules
  • Create custom rules with a built in IDE
  • Write custom rules in C# or VB.NETCreate HTML reports and XML exports
  • Integrate with SSMS and Visual Studio
  • Generate SQL to fix violations
  • DBBest T-SQL Analyzer

    Download page: DBBest T-SQL AnalyzerRelease date: 2015-03-13Support Version: 2008/2012/2014Author: DBBestFree version: NoPrice: $89

    T-SQL Analyzer is a code analyzing tool for finding problematic spots in your Transact-SQL code in SQL Server. The tool analyzes stored procedures and user-defined functions in your SQL Server database against a predefined set of best practice rules.

    DBBest Database Compare Suite

    Download page: DBBest Database Compare SuiteRelease date: 2015-09-04Support Version: 2008/2012/2014/2016Author: DBBestFree version: NoPrice: $349

    Comparing two production databases for migrating or upgrading

    Advanced Query Tool

    Download page: Advanced Query ToolRelease date: 2015-03-18Support Version: 2008/2012/2014/2016Author: DBBestFree version: NoPrice: $180

    AQT provides a simple and easy-to-use interface to your many different databases: Oracle, DB2 for LUW, DB2 for z/OS, DB2 for iSeries, Sybase ASE, SQL Server, Informix, MySQL, MS Access, SQLite, Other.

    SqlDiffFramework

    Download page: SqlDiffFrameworkRelease date: 2012-04-17Support Version: 2008/2012/2014/2016Author: Michael SorensFree version: YesPrice: No

    SqlDiffFramework compares two data sources and highlights both row and column differences for just the columns you want.

  • Compare the same data over time (either current data vs. prior data or two snapshots of prior data)
  • Compare the same data on two different servers
  • Compare data from different systems (e.g. SQL Server vs. Oracle)
  • Verify two systems have synchronized data
  • DataGrip

    Download page: DataGripRelease date: 2018-02-21Support Version: 2008-2017Author: Jet BrainsFree version: NoPrice: $89

  • Exploring your databases
  • Intelligent coding assistance
  • Executing queries
  • Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features
  • Pssdiag and Sqldiag Manager

    Download page: Pssdiag and Sqldiag ManagerRelease date: 2015-04-17Support Version: 2012/2014Author: Jack LiFree version: YesPrice: No

    PSSDIAG is a diagnostics utility used to collect profiler trace, perfmon data for SQL Server. PSSDAIG was created to troubleshoot SQL Server 7.0 and 2000 issues. It was evolved and shipped with SQL Server 2005 and beyond. But the shipped product only has a data collector engine called sqldiag.exe. Microsoft Product support continues to maintain a configuration tool that allows engineers to dynamically configure on what to collect.

    SQL Nexus Tool

    Download page: SQL Nexus ToolRelease date: 2016-11-20Support Version: 2008/2012/2014/2016Author: Jack LiFree version: YesPrice: No

    SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag and PSSDiag and Sqldiag Manager. It can dramatically reduce the amount of time you spend manually analyzing data

  • Fast, easy data loading: You can quickly and easily load SQL Trace files;
  • Visualize loaded data via reports
  • Executing queries
  • Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features
  • DBSophic Qure Profiler

    Download page: DBSophic Qure ProfilerRelease date: ?Support Version: 2008/2012Author: DBSophicFree version: NoPrice: $300

    SQL server trace analysis tool

  • View SQL activity in real-time
  • Group, sort and export batches
  • Real time index recommendations
  • Compare SQL traces
  • No limitations on the number of SQL servers, databases, processors etc.
  • DBSophic Qure Optimizer

    Download page: DBSophic Qure OptimizerRelease date: ?Support Version: 2008/2012Author: DBSophicFree version: NoPrice: ?

    The workload tuning solution that automatically optimizes millions of queries in one go

    RestoreChecker

    Download page: RestoreCheckerRelease date: 2015-01-15Support Version: ?Author: SQLServerUtilitiesFree version: NoPrice: $99

    RestoreChecker is a utility that restores SQL Server backup files in order to verify that the backup files can be successfully restored and in addition perform data integrity checks on the backups restored while offloading the intensive IO activity from your production servers.

    SQLScripter

    Download page: SQLScripterRelease date: 2009-08-24Support Version: ?Author: SQLServerUtilitiesFree version: NoPrice: $99

    SQLScripter is a powerful command line utility that scripts SQL Server objects. The utility is designed to automate the process of schema generation.

    SQLC

    Download page: SQLCRelease date: 2017-11-19Support Version: ?Author: David IngletonFree version: YesPrice: No

    SQLC is a software tool for comparing two SQL Server databases. With SQLC you can perform Object comparison (Database schema) as well as Data comparison (Table data)

    Database Performance Analyzer

    Download page: Database Performance AnalyzerRelease date: ?Support Version: 2008-2017/Azure/AmazonAuthor: SolarWindsFree version: NoPrice: $1995

    Monitor across your entire environment: physical servers, virtualized, and in the Cloud

    Database Performance Analyzer for MSSQL

    Download page: Database Performance Analyzer for MSSQLRelease date: ?Support Version: 2008-2017/Azure/AmazonAuthor: SolarWindsFree version: NoPrice: $1995

    Optimize and tune SQL Server deployed anywhere – physical, virtual, or cloud based. Includes Azure SQL database, Azure virtual machines, and Amazon RDS.

    SQL Enlight

    Download page: SQL EnlightRelease date: 2016-04-25Support Version: 2005/2008/2008R2/2012/2014Author: UbitSoftFree version: NoPrice: $295

  • Advanced static analysis
  • T-SQL code formatting
  • Statements history
  • Validate T-SQL code for syntax errors
  • Script Summary
  • Refactoring
  • Continuous integration support
  • Aireforge Studio

    Download page: Aireforge StudioRelease date: 2017-06-21Support Version: 2008/2012/2014/2016/AzureAuthor: AireForgeFree version: YesPrice: $299

    Aireforge Studio contains a growing suite of tools that help administrators to stabilize, optimize & secure multiple database instances with ease. Be it, keeping two instances in sync for recovery purposes or synchronizing the settings of over 200 replication subscribers; their tools will help.

    HexaTier

    Download page: HexaTierRelease date: ?Support Version: ?Author: HexaTierFree version: NoPrice: ?

    Providing an all-in-one solution to protect your data from internal and external attacks with four key elements, including: Database Security, Discovery of Sensitive Data. Dynamic Data Masking, and Database Activity Monitoring to comply with regulatory requirements.

    SoftTree SQL Assistant

    Download page: SoftTree SQL AssistantRelease date: 2017-12-17Support Version: 2005/2008/2008R2/2012/2014/2016/2017Author: SoftTreeFree version: NoPrice: $215

  • Triples SQL developer productivity
  • Improves code quality and accuracy
  • Provides unmatched intelligent SQL code intellisense features
  • Provides interactive SQL reference and SQL code assistance systems
  • Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation, and more…
  • Download page: DB Audit and Security 360Release date: 2015-02-07Support Version: 2005/2008/2008R2/2012/2014/2016Author: SoftTreeFree version: NoPrice: $499

    DB Audit and Security 360 is a professional all-in-one database security and auditing solution for Oracle, Sybase, DB2, MySQL and Microsoft SQL Server. DB Audit and Security 360 enables database and system administrators, security administrators, auditors and operators to track and analyze any database activity including database security, access and usage, data creation, change or deletion. What makes this solution really unique is its built-in support for multiple auditing methods giving you the flexibility to choose the best fit for your database security requirements.

    EMS SQL Management Studio

    Download page: EMS SQL Management StudioRelease date: 2016-05-26Support Version: 2000/2005/2008/2008R2/2012/2014Author: EMSFree version: NoPrice: $257

    EMS SQL Management Studio for SQL Server is a complete solution for Microsoft SQL Server database administration and development. With components that focus on all critical MS SQL Server database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering SQL Server databases, managing database schema and objects as well as for SQL Server database design, migration, extraction, SQL Server query building, data import, export and database comparison. SQL Studio unites these database tools for MSSQL Server in one powerful and easy-to-use environment that can work round the clock. Whether you are a database or application developer, DBA or business analyst, SQL Studio for SQL Server offers all essential SQL Server tools to make you more productive than ever before!

    EMS SQL Backup

    Download page: EMS SQL BackupRelease date: 2016-04-13Support Version: 2000/2005/2008/2008R2/2012/2014Author: EMSFree version: YesPrice: $82

    EMS SQL Backup for SQL Server is an effective tool for automating backup, restore and log shipping tasks on all SQL Servers in your company. In addition, SQL Backup allows you to update statistics, perform re-indexing, truncate database, check database integrity and perform many other tasks that can be united into policies and deployed to SQL Servers in a few clicks. SQL Backup monitors the maintenance task execution, quickly investigates and resolves issues.

    EMS SQL Administrator

    Download page: EMS SQL AdministratorRelease date: 2015-04-14Support Version: 2000/2005/2008/2008R2/2012/2014Author: EMSFree version: YesPrice: $135

    EMS SQL Administrator for SQL Server is a toolset for efficient SQL Server administration. It provides a complete and easy-to-use set of tools for administering SQL Server. SQL Administrator is designed specifically for database administrators and allows you to perform administrative tasks in the fastest, easiest and most efficient way.

    EMS SQL Manager

    Download page: EMS SQL ManagerRelease date: 2016-05-26Support Version: 2000/2005/2008/2008R2/2012/2014Author: EMSFree version: YesPrice: $135

    EMS SQL Manager for SQL Server is a high performance graphical tool for Microsoft SQL Server database development and administration. It makes creating and editing MS SQL Server database objects easy and fast, and allows you to run SQL scripts, manage SQL server users and their privileges, build SQL queries visually, work with metadata, export and import SQL Server database data and much more.

    EMS Data Export

    Download page: EMS Data ExportRelease date: 2016-04-29Support Version: –Author: EMSFree version: NoPrice: $47

    EMS Data Export for SQL Server is a powerful tool to export SQL Server database data quickly to any of 20 available formats, including MS Access, MS Excel, MS Word, RTF, HTML, TXT, ODF and more. Data Export for SQL Server has a friendly wizard, which allows you to set various options of SQL Server export process visually and a command-line utility to automate your SQL Server export jobs using the configuration file.

    EMS Data Import

    Download page: EMS Data ImportRelease date: 2016-04-14Support Version: –Author: EMSFree version: No Price: $47

    EMS Data Import for SQL Server is a powerful tool to import data to SQL Server tables from MS Excel 97-2007, MS Access, DBF, TXT, CSV, MS Word, RTF, ODF and HTML files. This utility allows you to quickly import data to one or several SQL Server tables or views at once, save all SQL Server import parameters set on current wizard session, use special batch insert mode to import SQL Server data at the maximum possible speed and much more.

    EMS Data Pump

    Download page: EMS Data PumpRelease date: 2016-11-03Support Version: –Author: EMSFree version: NoPrice: $47

    EMS Data Pump for SQL Server is an excellent migration tool for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MySQL or any other database with ADO support) to SQL Server databases. Database conversion and migration become as easy as possible with Data Pump for SQL Server!

    EMS Data Generator

    Download page: EMS Data GeneratorRelease date: 2010-07-10Support Version: –Author: EMSFree version: NoPrice: $47

    EMS Data Generator for SQL Server is an impressive tool for generating test data to SQL Server database tables. The utility can help you to simulate the database production environment and allows you to populate several SQL Server database tables with test data simultaneously, define tables for generating data, set value ranges, control a wide variety of generation parameters for each field type and much more. It has plenty of powerful functionalities to generate SQL Server test data in a simple and direct way.

    EMS DB Comparer

    Download page: EMS DB ComparerRelease date: 2015-07-24Support Version: –Author: EMSFree version: NoPrice: $47

    EMS DB Comparer for SQL Server is an excellent tool for comparing SQL Server database schemas and discovering differences in their structures. You can view all the differences in compared database objects and execute an automatically generated script to synchronize structure of SQL Server databases and eliminate these differences. Define comparison parameters and many other features make your work with their tool for SQL Server database synchronization easy and fast.

    EMS DB Extract

    Download page: EMS DB ExtractRelease date: 2008-10-16Support Version: –Author: EMSFree version: NoPrice: $47

    EMS DB Extract for SQL Server is an impressive and easy-to-use tool for creating SQL Server database backups in a form of SQL scripts. This database script utility allows you to save metadata of all SQL Server database objects as well as SQL Server table data as database snapshots. Flexible customization of the extract process enables you to select objects and data tables for SQL Server database dump and tune many other extract options.

    EMS SQL Query

    Download page: EMS SQL QueryRelease date: 2012-03-29Support Version: –Author: EMSFree version: NoPrice: $47

    EMS SQL Query for SQL Server is a useful tool that lets you quickly and simply build SQL queries to SQL Server databases. Visual SQL Server query building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to SQL Server databases, select tables and fields for a query to SQL Server, set the selection criteria and many more.

    EMS Data Comparer

    Download page: EMS Data ComparerRelease date: 2012-11-16Support Version: –Author: EMSFree version: NoPrice: $47

    EMS Data Comparer for SQL Server is a powerful and easy-to-use tool for SQL Server data comparison and synchronization. Using this utility you can view all the differences in compared SQL Server tables and execute an automatically generated script to eliminate these differences. Data Comparer for SQL Server provides a wide range of configuration parameters for fast and effective data comparison and synchronization of SQL Server databases.

    NitroAccelerator

    Download page: NitroAcceleratorRelease date: 2016-07-10Support Version: 2008/2012/2014/2016Author: NitrosphereFree version: NoPrice: $1265

    Accelerates and Secures SQL Server network traffic resulting in orders of magnitude performance improvement while securing the data across the network.

    ERwin Data Modeler

    Download page: ERwin Data ModelerRelease date: 2016-06-03Support Version: 2008/2012/2014/2016Author: ERwinFree version: NoPrice: $810

    ERwin Data Modeler is an industry-leading data modeling solution that provides a simple, visual interface to manage your complex data environment

    Toad Data Modeler

    Download page: Toad Data ModelerRelease date: 2016-06-16Support Version: 2008/2012/2014Author: DellFree version: NoPrice: $562

    Easily create high-quality data models. Toad Data Modeler enables you to rapidly deploy accurate changes to data structures across more than 20 different platforms. It allows you to construct logical and physical data models, compare and synchronize models, quickly generate complex SQL/DDL, create and modify scripts, as well as reverse and forward engineer both databases and data warehouse systems

    SQL Power Architect

    Download page: SQL Power ArchitectRelease date: 2016-02-11Support Version: 2008/2012/2014Author: SQLPowerFree version: YesPrice: $995

    The SQL Power Architect data modeling tool was created by data warehouse designers and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.

    DbWrench

    Download page: DbWrenchRelease date: 2016-07-06Support Version: 2008/2012/2014Author: Nizana SystemsFree version: NoPrice: $99

  • makes creating and modifying databases quicker and easier
  • streamlines many common database tasks
  • supports many operating systems and databases in a single license
  • Navicat Data Modeler

    Download page: Navicat Data ModelerRelease date: 2016-08-01Support Version: 2008/2012/2014/2016Author: PremiumSoftFree version: NoPrice: $199

    Navicat Data Modeler is a powerful and cost-effective database design tool which helps you build high-quality conceptual, logical and physical data models. It allows you to visually design database structures, perform reverse/forward engineering processes, import models from ODBC data sources, generate complex SQL/DDL, print models to files, and much more.

    DeZign for Databases

    Download page: DeZign for DatabasesRelease date: 2016-04-25Support Version: 2008/2012/2014Author: DatanamicFree version: NoPrice: $259

    DeZign for Databases is an intuitive database design and modeling tool for developers and DBA's that can help you model, create and maintain databases. The software uses entity relationship diagrams (ERDs, data models) to graphically design databases and automatically generates the most popular SQL and desktop database.

    ERDesigner NG

    Download page: ERDesigner NGRelease date: 2013-04-10Support Version: 2008/2012/2014Author: Mirko SerticFree version: Open SourcePrice: No

    The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD) such as ERWin and co. The only difference is that it is Open Source and does not cost anything. It was designed to make database modeling as easy as it can be and to support the developer in the whole development process, from database design to schema and code generation.

    Vertabelo

    Download page: VertabeloRelease date: ?Support Version: 2012Author: VertabeloFree version: NoPrice: $948

    Design your database online but very expensive

    dbDiffo

    Download page: dbDiffoRelease date: ?Support Version: ?Author: Contenet LtdFree version: YesPrice: No

    dbDiffo – The free online database schema designer

    SQL DXP

    Download page: SQL DXPRelease date: 2016-06-20Support Version: 2008/2012/2014/AzureAuthor: SQL DelteFree version: NoPrice: $530

    SQL DXP compares databases on different server platforms and can generate scripts to make the source database generally the same as the target database regardless of platform.

    Aqua Data Studio

    Download page: Aqua Data StudioRelease date: 2016-07-06Support Version: 2008/2012/2014Author: AquaFoldFree version: NoPrice: $499

    Aqua Data Studio is productivity software for Database Developers, DBAs, and Analysts. It allows you to develop, access, manage, and visually analyze data. Whether you are working with relational, nosql or cloud databases, your data is easily and quickly accessible with Aqua Data Studio. It supports all major database vendors, works on all major operating systems and is localized to 9 languages.

    RazorSQL

    Download page: RazorSQLRelease date: 2016-09-29Support Version: 2008/2012/2014/2016Author: Richardson SoftwareFree version: NoPrice: $100

    The MS SQL Server database query tool features provided by RazorSQL include a custom MS SQL Server database browser tailored to SQL Server, a Transact-SQL SQL editor with Transact SQL and SQL Server specific features and syntax highlighting, custom SQL Server visual tools, and SQL Server specific database administration tools.

    SQL Pretty Printer

    Download page: SQL Pretty PrinterRelease date: 2016-02-19Support Version: 2008/2012/2014/2016Author: Gudu SoftwareFree version: NoPrice: $50

    SQL Pretty Printer Desktop Version allows you to format your SQL wherever you are regardless of your Internet connection. It generates various output formats, including text, colorful html (Used in web, blog, wiki, forums) and RTF. Batch mode enables you to clean up SQL in multifiles under a nested directory. While sitting in the tray, you can format SQL in any editor like Microsoft Query Analyzer, UltraEditor or notepad with just one hotkey.

    Database .NET

    Download page: Database .NETRelease date: 2018-08-20Support Version: 2008-2017Author: fish's dotNETFree version: Non-commercialPrice: $69

    Database .NET is an innovative, powerful and intuitive multiple database management tool. You can browse/grant objects, design tables, edit rows, run queries, generate scripts, analyze/monitor SQL and import/export/migrate/sync data with a consistent interface.

    dbMigration .NET

    Download page: dbMigration .NETRelease date: 2018-08-20Support Version: 2008-2017Author: fish's dotNETFree version: Non-commercialPrice: $49

    dbMigration .NET is a simple, easy and intuitive multiple database migration and sync tool. With it you can easily migrate schema and data between different databases without complicated procedures.

    Is It SQL

    Download page: Is It SQLRelease date: 2017-04-06Support Version: 2005/2008/2012/2014/2016Author: Bill GrazianoFree version: Non-commercialPrice: No

  • Supports SQL Server 2005 through SQL Server 2016
  • Monitor CPU usage for SQL Server and non-SQL Server tasks
  • Capture batch requests per second
  • Monitor Disk I/onsite
  • Monitor waits
  • Show actively running queries
  • Capture basic demographic information including version, start time, database sizes, etc.
  • Can run with no installation or it can be run as a service
  • Database Experimentation Assistant Technical Preview 2

    Download page: Database Experimentation AssistantRelease date: 2017-03-24Support Version: 2005/2008/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    Database Experimentation Assistant is the new A/B testing solution for SQL Server upgrades, enables customers to gather performance insights for upgrades by conducting experiments across two SQL Server versions using production workloads enabling customers to conduct experiments on database workloads across two versions of SQL Server.

    Data Platform Studio

    Download page: Data Platform StudioRelease date: ?Support Version: SQL Server, SQL AzureAuthor: Red Gate SoftwareFree version: YesPrice: ?

    Simplify the process of migrating data from your on-premise SQL Server to Azure SQL Data Warehouse with the Data Platform Studio importer. Automatically, and in far less time than it takes to handle migrations manually, it:

  • Makes schema compatibility fixes to prepare your Azure SQL Data Warehouse for your database
  • Compresses your data so it uploads to Azure efficiently
  • Utilizes the MPP power of Azure SQL Data Warehouse to ingest the data quickly
  • Flyway

    Download page: Data Platform StudioRelease date: 2018-01-30Support Version: Oracle, SQL Server, SQL Azure, MySQL, OtherAuthor: boxfuseFree version: Open SourcePrice: $950

    Flyway is an open-source database migration tool. It strongly favors simplicity and convention over configuration. It is based around just 6 basic commands: Migrate, Clean, Info, Validate, Baseline and Repair. Migrations can be written in SQL (database-specific syntax (such as PL/SQL, T-SQL, …) is supported) or Java (for advanced data transformations or dealing with LOBs). It has a Command-line client. If you are on the JVM, they recommend using the Java API (also works on Android) for migrating the database on application startup. Alternatively, you can also use the Maven plugin, Gradle plugin, SBT plugin or the Ant tasks.

    Liquibase

    Download page: LiquibaseRelease date: 2018-04-11Support Version: Oracle, PostgreSQL, MySQL, OtherAuthor: LiquibaseFree version: Open SourcePrice: No

    Liquibase is an open source database-independent library for tracking, managing and applying database schema changes. It was started in 2006 to allow easier tracking of database changes, especially in an agile software development environment.

    All changes to the database are stored in text files (XML, YAML, JSON or SQL) and identified by a combination of an "id" and "author" tag as well as the name of the file itself. A list of all applied changes is stored in each database which is consulted on all database updates to determine what new changes need to be applied. As a result, there is no database version number but this approach allows it to work in environments with multiple developers and code branches. Liquibase automatically creates DatabaseChangeLog Table and DatabaseChangeLogLock Table when you first execute a changeLog File.

    My Batis

    Download page: My BatisRelease date: 2018-03-20Support Version: Oracle, PostgreSQL, MySQL, OtherAuthor: My BatisFree version: Open SourcePrice: No

    MyBatis Schema Migration System (or MyBatis Migrations for short) seeks to:

  • Work with any database, new or existing
  • Leverage the source control system (e.g. Subversion)
  • Enable concurrent developers or teams to work independently
  • Allow conflicts very visible and easily manageable
  • Allow for forward and backward migration (evolve, devolve respectively)
  • Make the current status of the database easily accessible and comprehensible
  • Enable migrations despite access privileges or bureaucracy
  • Work with any methodology
  • Encourages good, consistent practices
  • SentryOne Plan Explorer

    Download page: SentryOne Plan ExplorerRelease date: 2017-05-25Support Version: 2008-2017Author: SentryOneFree version: YesPrice: No

  • Index Analysis: Discover a new, easy way to gauge the impact of potential index changes.
  • Statistics Analysis with Histogram
  • Query Performance Profiling and Playback
  • Actual Plan Recosting
  • Plan Diagram
  • Management Studio Add-In
  • Tuning History and Comments
  • Multiple Documents
  • SQL Sentry

    Download page: SQL SentryRelease date: 2016-12-07Support Version: ?Author: SentryOneFree version: NoPrice: ?

    Get the most complete coverage for SQL Server and Windows. Simplify performance tuning by visualizing where problems exist for faster resolution. Streamline your defragmentation process and query tuning all in one place. They have combined all the great SQL Sentry tools into a single unified solution to help you monitor and optimize the Microsoft data platform. Everything you need for: SQL Server and Windows Performance Monitoring, Event Management, Index Defragmentation and Query Plan Analysis, with Desktop, Web, and Mobile UIs.

    dbMonitor

    Download page: dbMonitorRelease date: 2012-11-01Support Version: ?Author: DevartFree version: YesPrice: No

    To extend monitoring capabilities of their data access products there is an additional tool called dbMonitor. It is easy-to-use tool to provide visual monitoring of your database applications. dbMonitor performs per-component tracing of database events such as commit, rollback, SQL statement execute, creating and destroying components, connection pooling events etc.

    DBmaestro TeamWork

    Download page: DBmaestro TeamWorkRelease date: ?Support Version: ?Author: DBmaestroFree version: NoPrice: ?

    DBmaestro is bringing the agility of Automation and DevOps, with an innovative solution for evolutionary database development, safe build automation, and failsafe continuous delivery in any environment.

  • Database Release Automation
  • Database Merge and Build Automation
  • Database Enforced Source Control
  • Database Enhanced Security and Regulatory Compliance
  • xSQL Schema Compare

    Download page: xSQL Schema CompareRelease date: 2017-03-01Support Version: 2005/2008/2012/2014/2016, AzureAuthor: xSQL SoftwareFree version: YesPrice: $399

    Compare the schemas of two SQL Server databases, review differences, generate synchronization script and execute it.

    xSQL Data Compare

    Download page: xSQL Data CompareRelease date: 2017-06-26Support Version: 2005/2008/2012/2014/2016, AzureAuthor: xSQL SoftwareFree version: YesPrice: $399

    Data Compare for SQL Server is a tool for comparing and synchronizing the data in two SQL Server databases. You can use it for data migration, auditing, replication verification, populating development databases with production data etc.

    xSQL Script Executor

    Download page: xSQL Script ExecutorRelease date: 2015-02-25Support Version: 2000 and higherAuthor: xSQL SoftwareFree version: YesPrice: $249

    Script Executor is a professional grade database tool that allows you to deploy multiple Sql scripts on one or more target servers with a click of a button. Scripts can be deployed directly from the GUI, from the command line or they can be wrapped into an executable.

    xSQL Builder

    Download page: xSQL BuilderRelease date: 2017-03-15Support Version: 2005/2008/2012/2014/2016, AzureAuthor: xSQL SoftwareFree version: NoPrice: $799

    xSQL Builder is a SQL Server tool that allows for automating the deployment of SQL Server based solutions. It generates executable packages that contain all the information and logic required to deploy the database to the clients' environments regardless of whether it is a first time deployment or an upgrade from a previous version.

    xSQL Documenter

    Download page: xSQL DocumenterRelease date: 2017-01-04Support Version: 2000 to 2016Author: xSQL SoftwareFree version: NoPrice: $199

    Comprehensive, uniform, and easily navigable database documentation in HTML and compiled CHM format.

    xSQL Profiler

    Download page: xSQL ProfilerRelease date: 2017-06-28Support Version: 2005/2008/2012/2014/2016, AzureAuthor: xSQL SoftwareFree version: YesPrice: $999

    xSQL Profiler is a SQL tracing tool that provides for monitoring multiple SQL Servers from one central location. Traces can be customized and scheduled to run on certain servers at certain times and all trace data is automatically collected into the central repository.

    xSQL Schema Compare SDK

    Download page: xSQL Schema Compare SDKRelease date: 2017-10-25Support Version: 2000 to 2016Author: xSQL SoftwareFree version: NoPrice: $1499

    Schema Compare SDK is a set of class libraries that allows you to perform schema comparison and synchronization for SQL Server databases in your .NET or ASP.NET applications.

    xSQL RSS Reporter

    Download page: xSQL RSS ReporterRelease date: 2014-11-25Support Version: 2005/2008/2012/2014Author: xSQL SoftwareFree version: NoPrice: $169

    RSS Reporter is a tool that generates standard Atom or RSS feeds for:

  • SQL Server job execution history
  • SQL Server job definition
  • The output of any T-SQL query
  • Database size and space usage
  • xSQL Database Searcher

    Download page: xSQL Database SearcherRelease date: 2017-05-09Support Version: 2005/2008/2012/2014/2016, AzureAuthor: xSQL SoftwareFree version: YesPrice: No

    Database Searcher, previously known as "xSQL Object Search", is a free tool that allows you to search the schema of SQL Server databases.

    Cloud-based DB Monitoring Platform

    Download page: Cloud-based DB Monitoring PlatformRelease date: ?Support Version: ?Author: SQLTreeoFree version: NoPrice: €180

  • Charts-on-charts technology, 24/7/365.
  • Alerting via Windows, Android and iOS.
  • Drill down into detailed history charts.
  • Send instant messages within your secured network.
  • SchemaCrawler

    Download page: SchemaCrawlerRelease date: 2017-02-27Support Version: Oracle, PostgreSQL, MySQL, OtherAuthor: Sualeh FatehiFree version: Open SourcePrice: No

    SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format. The output serves for database documentation, and is designed to be diff-ed against other database schemas. SchemaCrawler also generates schema diagrams. You can execute scripts in any standard scripting language against your database. You can find potential schema design issues with lint. SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java SE 8, Compact Profile 2 or better.

    SA MaaS Microsoft SQL Server

    Download page: SA MaaS Microsoft SQL ServerRelease date: ?Support Version: ?Author: SENTINELAGENTFree version: NoPrice: ?

    SA MaaS Microsoft SQL Server for on-premise and virtual Microsoft SQL servers gathers, stores and analyzes raw Microsoft recommended health & performance diagnostics to help network admins and DBAs keep SQL servers running at peak performance and find the logs they need.

    CatCompare v2

    Download page: CatCompare v2Release date: 2017-01-07Support Version: ?Author: Andy LeonardFree version: NoPrice: $295

    CatCompare provides automate-able command-line management of SSIS Catalog project configuration, deployment, migration, code promotion, and comparison.

    SSIS Catalog Compare v2.0 Bundle

    Download page: SSIS Catalog Compare v2.0 BundleRelease date: 2017-01-06Support Version: ?Author: Andy LeonardFree version: NoPrice: $495

    Deploying SSIS Catalog Projects help deploying environments, references, mappings, and overrides. The SSIS Catalog Compare Version 2.0 Bundle includes SSIS Catalog Compare and CatCompare, a CLI (Command-Line Interface) utility.

    MS Kerberos Configuration Manager

    Download page: MS Kerberos Configuration ManagerRelease date: 2017-01-31Support Version: 2008/2012/2014/2016Author: MicrosoftFree version: YesPrice: No

    Microsoft Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server, SQL Server Reporting Services, and SQL Server Analysis Services.

    Spotlight

    Download page: [Spotligh]Release date: ?Support Version: 2008/2012/2014/2016Author: Quest SoftwareFree version: YesPrice: ?

    Can diagnose SQL Server performance issues quickly and accurately, ensuring a healthy database infrastructure.

    DBConvert Studio

    Download page: DBConvert StudioRelease date: 2017-03-01Support Version: ?Author: DMSoft TechnologiesFree version: YesPrice: 499

    DBConvert Studio Software combines familiar and powerful features from the mature DBConvert and DBSync product series along with a redesigned and improved UI. The following scenarios are available:

  • Simple master to slave migration
  • One-way Synchronization
  • Bidirectional synchronization
  • Data distribution (data flows from one source database to multiple destinations)
  • DbDefence

    Download page: DbDefenceRelease date: 2017-03-01Support Version: 2005/2008/2012/2014/2016Author: ActiveCrypt SoftwareFree version: YesPrice: $698

    DbDefence for Microsoft SQL Server implements server-side encryption and additional level of protection for databases. With DbDefence you can hide table structure and data from prying eyes, even from DBA. Free version for databases less than 200 MB.

    SQL Server Migration Assistant for MySQL

    Download page: SQL Server Migration Assistant for MySQLRelease date: 2017-02-17Support Version: 2005/2008/2012/2014/2016/AzureAuthor: MicrosoftFree version: YesPrice: No

    Microsoft SQL Server Migration Assistant (SSMA) for MySQL is a tool to automate migration from MySQL database(s) to SQL Server and Azure SQL DB.

    sqlcmd for Mac and Linux

    Download page: sqlcmd for Mac and LinuxRelease date: 2017-01-26Support Version: 2005/2008/2012/2014/2016/AzureAuthor: Soheil RashidiFree version: Open SourcePrice: No

    sqlcmd utility for Mac and Linux

    SQL Migrator

    Download page: SQL MigratorRelease date: ?Support Version: 2005/2008/2012/2014/2016Author: Datamate TechnologyFree version: ?Price: ?

    Automatically upgrade objects within a SQL Server Instance from lower to higher versions or just refresh Objects between the same Versions

    MS FoxPro to MS SQL Migration and Sync

    Download page: MS FoxPro to MS SQL Migration and SyncRelease date: 2013-10-08Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Our software helps to migrate and synchronize MS Visual FoxPro databases .DBC or MS Visual FoxPro free tables .DBF to MS SQL Server. It combines an easy-to-use interface with bunch of customization options, so your migration and replication of data can be fulfilled smoothly and rapidly.

    Approximately 1 Million of records from FoxPro to MSSQL Server with "Bulk" option activated can be converted in 8 minutes.

    MySQL to MS SQL Migration and Sync

    Download page: MySQL to MS SQL Migration and SyncRelease date: 2013-10-08Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Our software automates conversion and synchronization of your databases from MySQL to MS SQL Server. Transfer the entire database or select only needed dataset at customization stage in easy-to-use wizard style GUI.

    Views migration between MS SQL and MySQL in both directions is available. You don’t need to know any differences in SQL syntax. Every view will be converted from source db to target automatically.

    Integrated Data Types Mapping feature helps to find and map similar data types between MySQL and MS SQL Server to make cross database conversion more flexible.

    Oracle to MS SQL Migration and Sync

    Download page: Oracle to MS SQL Migration and SyncRelease date: 2013-10-09Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Convert and synchronize databases from Oracle to MS SQL Server efficiently and fast. Automatic views conversion from Oracle to MS SQL is easily performed with their software even with no any knowledge in differences between SQL dialects. Besides, any server access restrictions may be overcome by creating dump files instead of direct connection to a target database.

    Our tool easily handles huge databases and tables. A clear easy-to-use wizard interface helps you to move the whole database or only selected tables, indexes and foreign keys effortlessly.

    PostgreSQL to MS SQL Migration and Sync

    Download page: PostgreSQL to MS SQL Migration and SyncRelease date: 2013-10-08Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Convert and synchronize your databases from PostgreSQL to MS SQL server or to SQL Azure databases using their powerful software. Wizard style interface will guide you through several steps performing migration and replication jobs easily and effectively.

    In case you have any server restrictions, you can stuff MS SQL Dump file with all data out of the PostgreSQL database.

    Our software will save you hours of learning SQL commands as any large PostgreSQL db can be converted and synchronized approximately in 5-10 min.

    MS Excel to MS SQL Migration

    Download page: MS Excel to MS SQL MigrationRelease date: 2013-09-23Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Ability to create tables from MS Excel file with Integrated Data Selector Microsoft Excel 2000 or higher 2003/2007/2010 Views conversion from MS SQL to MySQL and Oracle and back support Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL Saving data into a MS SQL Dump for export to MS SQL database

    SQLite to MS SQL Migration and Sync

    Download page: SQLite to MS SQL Migration and SyncRelease date: 2014-05-08Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Conversion Tool for data migration and synchronization between SQLite and MS SQL databases in both directions. One of the main benefit of this converter is the range of effective features that help you to transfer all database objects together or each individually, skipping unnecessary tables, fields, indexes, foreign keys and constrains; change data types for various fields; rename each database element and many other options.

    If you have any restrictions on direct access to MS SQL server their product provides you with the opportunity to create Dump files for further data uploading to MS SQL server.

    IBM DB2 to MS SQL Migration and Sync

    Download page: IBM DB2 to MS SQL Migration and SyncRelease date: 2013-09-09Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Our robust and cost-effective solution is a key for successful conversion and synchronization from IBM DB2 to MS SQL server.Software is able to connect to source and destination databases directly without any other additional software installed. Optionally target SQL Dump file may be generated if you haven’t a direct access to the MS SQL server.

    MS Access to MS SQL Migration and Sync

    Download page: IBM DB2 to MS SQL Migration and SyncRelease date: 2013-10-08Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    Powerful cross database software that will upsize and synchronize Access data into MS SQL database.

    The program allows migrating MS Access queries to MSSQL views automatically with no need to know about the differences between SQL dialects.

    Firebird to MS SQL Migration and Sync

    Download page: Firebird to MS SQL Migration and SyncRelease date: 2013-09-11Support Version: 2005/2008/2012/AzureAuthor: DMSoft TechnologiesFree version: NoPrice: $149

    All Firebird / InterBase versions support Saving data into a Firebird Dump Views conversion from MS SQL to MySQL and Oracle and back support Bi-directional synchronization between MS SQL, MySQL, Oracle and PostgreSQL

    SQLines SQL Converter

    Download page: SQLines SQL ConverterRelease date: ?Support Version: ?Author: DmtolpekoFree version: Open SourcePrice: No

    SQLines SQL Converter is an open source tool (Apache License 2.0) that allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, packages, functions and triggers between Microsoft SQL Server, Oracle, MariaDB, MySQL, PostgreSQL, IBM DB2, Sybase, Informix, Teradata, Greenplum and Netezza.

    SQLite & SQL Server Compact Toolbox

    Download page: SQLite & SQL Server Compact ToolboxRelease date: ?Support Version: ?Author: ErikEJFree version: Open SourcePrice: No

    Visual Studio & SSMS 2016 extension, standalone app and command line tools, for managing all aspects of your SQL Server Compact/SQLite database files' data and schema, including generation of code, database diagrams and database documentation.

    SqlPad

    Download page: SqlPadRelease date: ?Support Version: ?Author: RickbergfalkFree version: Open SourcePrice: No

    A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, Crate, Vertica, and Presto. Written in Node.js.

    Html-query-plan

    Download page: Html-query-planRelease date: ?Support Version: ?Author: JustinPealingFree version: Open SourcePrice: No

    Html-query-plan is a JavaScript library for showing Microsoft SQL Server execution plans in HTML.

    SqlQueryStress

    Download page: SqlQueryStressRelease date: ?Support Version: ?Author: Adam MachanicFree version: Open SourcePrice: No

    SQL query stress simulator created by Adam Machanic http://sqlblog.com/blogs/adam_machanic/archive/2016/01/04/sqlquerystress-the-source-code.aspx

    SQL Server Migration Assistant for DB2

    Download page: SQL Server Migration Assistant for DB2Release date: 2017-02-17Support Version: 2005/2008/2012/2014/2016/AzureAuthor: MicrosoftFree version: YesPrice: No

    Microsoft SQL Server Migration Assistant (SSMA) for DB2 is a tool to automate migration from DB2 database(s) to SQL Server and Azure SQL DB.

    SQL Server Migration Assistant for Oracle

    Download page: SQL Server Migration Assistant for OracleRelease date: 2017-02-17Support Version: 2005/2008/2012/2014/2016/AzureAuthor: MicrosoftFree version: YesPrice: No

    Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a tool to automate migration from Oracle database(s) to SQL Server and Azure SQL DB.

    SQL Server Migration Assistant for Access

    Download page: SQL Server Migration Assistant for AccessRelease date: 2017-02-17Support Version: 2005/2008/2012/2014/2016/AzureAuthor: MicrosoftFree version: YesPrice: No

    Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Access database(s) to SQL Server and Azure SQL DB.

    mssql for Visual Studio Code

    Download page: mssql for Visual Studio CodeRelease date: 2017-02-02Support Version: ?Author: MicrosoftFree version: Open SourcePrice: No

    mssql for Visual Studio Code an extension for developing Microsoft SQL Server, Azure SQL Database and SQL Data Warehouse everywhere with a rich set of functionalities, including:

  • Connect to Microsoft SQL Server, Azure SQL Database and SQL Data Warehouses
  • Create and manage connection profiles and most recently used connections
  • Write T-SQL script with IntelliSense, Go to Definition, T-SQL snippets, syntax colorizations, T-SQL error validations and GO batch separator
  • Execute your scripts and view results in a simple to use grid
  • Save the result to json or csv file format and view in the editor
  • Customizable extension options including command shortcuts and more
  • Microsoft Assessment and Planning

    Download page: Microsoft Assessment and PlanningRelease date: 2017-02-10Support Version: 2008/2008R2/2012Author: MicrosoftFree version: YesPrice: No

    The Microsoft Assessment and Planning Toolkit makes it easy to assess your current IT infrastructure for a variety of technology migration projects. This Solution Accelerator provides a powerful inventory, assessment, and reporting tool to simplify the migration planning process.

    mssql-scripter

    Download page: mssql-scripterRelease date: ?Support Version: ?Author: MicrosoftFree version: Open SourcePrice: No

    mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard experience in SSMS. You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse.

    DBFS

    Download page: DBFSRelease date: ?Support Version: ?Author: MicrosoftFree version: Open SourcePrice: No

    DBFS uses FUSE to mount MS SQL Server DMVs as a virtual file system. This gives you the ability to explore information about your database (Dynamic Management Views) using native bash commands.

    Comparator

    Download page: ComparatorRelease date: 2017-06-06Support Version: 2008-2017Author: PumpetFree version: Open SourcePrice: No

    Simple application for compare data

    Navicat for SQL Server

    Download page: Navicat for SQL ServerRelease date: 2017-06-14Support Version: 2008-2017/Azure/AmazonRDSAuthor: PremiumSoftFree version: NoPrice: $699

    Navicat for SQL Server gives you a fully graphical approach to database management and development. Quickly and easily create, edit, and delete all database objects, or execute SQL queries and scripts. Connect to any local/remote SQL Server, and compatible with cloud databases like Amazon RDS and SQL Azure.

    Navicat Premium

    Download page: Navicat PremiumRelease date: 2017-06-14Support Version: 2008-2017/Azure/AmazonRDSAuthor: PremiumSoftFree version: NoPrice: $1299

    Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud and Google Cloud. You can quickly and easily build, manage and maintain your databases.

    DbVisualizer

    Download page: DbVisualizerRelease date: 2017-08-22Support Version: 2008-2017Author: DbVis Software AB.Free version: YesPrice: $197

    DbVisualizer is the universal database tool for developers, DBAs and analysts. It is the perfect solution since the same tool can be used on all major operating systems accessing a wide range of databases.

    DbSchema

    Download page: DbSchemaRelease date: 2017-06-19Support Version: 2008-2017/Azure/AmazonAuthor: Wise Coders SolutionsFree version: NoPrice: $127

  • DbSchema is a diagram-oriented database designer with integrated data and query tools
  • DbSchema is build for large diagrams and schemes. No database experience required – the tool is visual.
  • For deployment of the schema on multiple databases, management of multiple versions of the schema and migration scripts, work in a team on the design project. This are possible as DbSchema is using its own image of the schema and saves it to XML file.
  • DBGhost

    Download page: DBGhostRelease date: 2017-01-31Support Version: 2008/2012/2014/2016Author: Innovartis LtdFree version: NoPrice: £430

    The Change Manager gives you all the tools to implement the full DB Ghost Process enabling you to script out your databases into individual DROP/CREATE scripts, place those scripts under source control, modify them there and then build and deploy from those scripts.

    SQLAutomate

    Download page: SQLAutomateRelease date: 2017-06-19Support Version: 2008/2012/2014/2016Author: OnLine ToolWorksFree version: NoPrice: $99

    SQLAutomate is an advanced database automation solution for SQL Server, Oracle, MySQL, DB2 or other advanced database management system. It provides the ability to manage the necessary repetitive DBMS maintenance to help keep your databases efficient over time. SQLAutomate makes it easy to manage a single database server instance, hundreds or even thousands of instances.

    BimlExpress

    Download page: BimlExpressRelease date: ?Support Version: ?Author: VarigenceFree version: NoPrice: No

    BimlExpress Visual Studio Add-in built specifically to work with SQL Server 2016.

  • Generate packages within Visual Studio and avoid slow, repetitive, "drag 'n drop" workflow.
  • Write Biml code with syntax highlighting, making it easier to read and write Biml.
  • Updates are released more rapidly to work with the most current versions of SQL Server.
  • BIDS Helper

    Download page: BIDS HelperRelease date: 2015-03-17Support Version: ?Author: MicrosoftFree version: Open SourcePrice: No

    A Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI).

    Azure Data Warehouse Migration Utility

    Download page: Azure Data Warehouse Migration UtilityRelease date: ?Support Version: ?Author: MicrosoftFree version: ?Price: ?

    The Data Warehouse Migration Utility is a tool designed to migrate schema and data from SQL Server and Azure SQL Database to Azure SQL Data Warehouse. During schema migration, the tool automatically maps the corresponding schema from source to destination. After the schema has been migrated, the tools provides the option to move data with automatically generated scripts.

    Dell Benchmark Factory

    Download page: Dell Benchmark FactoryRelease date: ?Support Version: 2008/2012/2014/2016/AzureAuthor: Quest SoftwareFree version: NoPrice: $4413

  • database workload generation
  • database code scalability testing
  • industry-standard benchmark testing
  • virtual user and transaction load simulation
  • manduka

    Download page: mandukaRelease date: 2017-03-08Support Version: ?Author: Virtusa CorporationFree version: YesPrice: No

    The Free Static code analyzer

  • PL-SQL & T-SQL
  • Support for more than 50 violation rules
  • Light weight & fast
  • Easy to install & use
  • XML reports
  • PowerBI

    Download page: PowerBI DesktopRelease date: 2017-07-11Support Version: 2008-2017Author: MicrosoftFree version: YesPrice: ?

    Power BI is a suite of business analytics tools to analyze data and share insights. Monitor your business and get answers quickly with rich dashboards available on every device.

    Stellar Phoenix SQL Database Repair

    Download page: Stellar Phoenix SQL Database RepairRelease date: 2017-07-05Support Version: 2008/2012/2014/2016Author: Stellar Information TechnologyFree version: NoPrice: $349

  • Repairs corrupt MDF and NDF file of SQL Server database
  • Recovers tables, triggers, indexes, keys, rules and defaults
  • Perform deleted records recovery from MS SQL Server database
  • Saves Scan result of SQL Server database file automatically
  • Allows to search and recover specific database objects
  • Allows saving the repaired file in MS SQL, HTML, XLS & CSV formats
  • Supports MS SQL Server 2016, 2014, 2012, 2008 and all lower versions
  • DataNumen SQL Recovery

    Download page: DataNumen SQL RecoveryRelease date: 2017-03-20Support Version: 2008/2012/2014/2016Author: DataNumenFree version: NoPrice: $500

    Recovery rate is the most important criterion of a SQL recovery product. Based on their comprehensive tests, DataNumen SQL Recovery has the best recovery rate, much more better than any other competitors in the market!

    Recovery Toolbox for SQL Server

    Download page: Recovery Toolbox for SQL ServerRelease date: ?Support Version: 7/2000/2005/2008/2008 R2/2012/2014Author: Recovery ToolboxFree version: NoPrice: $99

    Recovery Toolbox for SQL Server is a comprehensive recovery solution for damaged MS SQL Server database files.

    SQL MDF Viewer

    Download page: SQL MDF ViewerRelease date: ?Support Version: 2000-2016Author: SysToolsFree version: NoPrice: $129

    Read and open MDF database file along with its related elements

  • Preview all tables, indexes, triggers of the MDF file
  • Auto detects the SQL Server version
  • Save scanned MDF file data in .str file format
  • SQL MDF Recovery Tool

    Download page: SQL MDF Recovery ToolRelease date: ?Support Version: 2014 and all lower versionsAuthor: SysToolsFree version: NoPrice: $129

    Repair corrupt MDF file data with ease and accuracy

  • Recover tables, function, stored procedure, triggers, etc
  • Performs Quick and Advance Scan to repair MDF & NDF file
  • Export selective file with Schema or Schema and Data
  • SQL Passord Recovery

    Download page: SQL Passord RecoveryRelease date: ?Support Version: 2008 & all below versionsAuthor: SysToolsFree version: NoPrice: $69

    Tool to Reset SQL Server Database Password

  • Recover passwords of multiple SQL Server databases
  • Reset both unknown and empty SQL DB passwords
  • Remove and reset passwords of all SQL Server users
  • SQL Decryptor

    Download page: SQL DecryptorRelease date: ?Support Version: 2014 & all below versionsAuthor: SysToolsFree version: NoPrice: $69

    User Friendly Solution to Remove Encryption From SQL Database

  • Remove encryption from batch SQL objects
  • Display complete preview of MS SQL database
  • Export data to SQL Server and compatible script
  • SQL Backup Database Recovery

    Download page: SQL Backup Database RecoveryRelease date: ?Support Version: ?Author: SysToolsFree version: NoPrice: $149

    Recover Corrupt SQL Backup File with .bak Repair Tool

  • Repair corrupt SQL Server backup file with confidence
  • Fix all SQL backup error messages quickly
  • Advanced and affordable solution to recover SQL BAK file
  • Simple and nifty graphical user interface
  • SQL Log File Viewer

    Download page: SQL Log File ViewerRelease date: ?Support Version: 2016/2014/2012/2008 and all below versionsAuthor: SysToolsFree version: NoPrice: $999

    Read SQL Server database transaction log file with SQL log analysis tool

  • Analyze and view SQL Server LDF file transactions
  • View all the transactions, i.e. insert, update, delete etc.
  • Export log file into SQL Server, SQL script or as CSV file
  • DAX Studio

    Download page: DAX StudioRelease date: ?Support Version: ?Author: SqlbiFree version: YesPrice: No

    DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular.

    SQL Cop

    Download page: SQL CopRelease date: ?Support Version: ?Author: LessThanDotFree version: YesPrice: No

    SQL Cop is a static code analysis tool to automatically detect issues with your database.

    Dataedo

    Download page: DataedoRelease date: 2017-09-15Support Version: 2008-2017Author: SqlbiFree version: YesPrice: $239

    Document SQL Server, Oracle and MySQL databases

    Azure Database Migration Service

    Download page: DataedoRelease date: 2017-12-01Support Version: 2008-2017Author: MicrosoftFree version: YesPrice: No

    Reduce the complexity of your cloud migration by using a single comprehensive service instead of multiple tools. The public preview release of Azure Database Migration Service is designed as a seamless, end-to-end solution for moving on-premises SQL Server databases to the cloud.

    FlowHeater

    Download page: flowheaterRelease date: 2017-10-02Support Version: 2008-2017Author: FlowHeater GmbHFree version: NoPrice: $79

    The FlowHeater functionality closely resembles the concept of a continuous-flow water heater. A wide variety of data sources can be interconnected with FlowHeater and by making use of exchangeable adapters, there is no restriction to the data flow.

    EDIS

    Download page: EDISRelease date: ?Support Version: 2008-2017Author: SQL ETLFree version: YesPrice: $599

    EDIS is an Extract-Transform-Load (ETL) application for Microsoft SQL Server. No 3rd Party Language, No Packages, Just SQL.

    SchemaSpy

    Download page: SchemaSpyRelease date: 2018-08-05Support Version: 2008-2017Author: Rafal KasaFree version: Open SourcePrice: No

    Document your database simply and easily. SchemaSpy is a Java-based tool (requires Java 8 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints. It is free software that is distributed under the terms of the MIT License.

    Adminer

    Download page: AdminerRelease date: 2018-02-20Support Version: 2005-2017Author: AdminerFree version: Open SourcePrice: No

    Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB.

    Full Convert Enterprise

    Download page: Full ConvertRelease date: 2018-08-20Support Version: 2005-2017Author: Spectral CoreFree version: NoPrice: $699

    Full Convert allows easy copying of tables and data between 40 or so supported databases. It will create all the tables, copy all of your data, then create indexes and foreign keys. It has powerful mapping and customization features and uses optimal copying mode for each table separately to achieve the best possible throughput.

    Replicator Pro

    Download page: ReplicatorRelease date: 2018-08-20Support Version: 2005-2017Author: Spectral CoreFree version: NoPrice: $799

    Replicator allows table data comparison and sync – even with heterogeneous databases. It is unique in the fact it can replicate changes only even if source is non-relational (CSV, DBF, Excel documents, Paradox…). Replicator has a built-in scheduler for easy periodic change replication.

    JackDB

    Download page: JackDBRelease date: ?Support Version: 2008-2017/AzureAuthor: JackDBFree version: NoPrice: $49

    JackDB is a modern database client. Collaborate with data securely across your entire organization.

    SQL Workbench

    Download page: SQL WorkbenchRelease date: 2018-08-20Support Version: 2008-2017Author: Thomas KellererFree version: YesPrice: No

    SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. Graphical query building or more advanced DBA tasks are not the focus and are not planned.

    Valentina Studio

    Download page: Valentina StudioRelease date: 2018-09-24Support Version: 2008-2017Author: Paradigma SoftwareFree version: YesPrice: $200

    Valentina Studio is your universal database management tool for working with MySQL, MariaDB, SQL Server, PostgreSQL, SQLite and Valentina DB databases. Valentina Studio lets you connect with all major databases, run queries and generate


    Upgrading to SQL Server 2012/2014 - How to Overcome the Top 5 ‘Gotchas’ | killexams.com real questions and Pass4sure dumps

    Jan 7, 2015

    Varun Singh

    Image courtesy of Shutterstock

    SQL Server 2012/2014 delivers compelling new capabilities that make an upgrade worthwhile. Many IT professionals agree that the AlwaysOn Availability Group (AG) feature offers the most value with its high availability (HA) capabilities to ensure continuous application availability.

    Synchronous replication technology in AlwaysOn lets applications scale out like never before, using more resources on more servers. With read-only access to secondary databases, SQL Server 2012/2014 can dramatically increase database I/O capacity on the back end. Grouping databases together into an AG also allows companies to specify that certain databases connect to particular applications, ensuring that they failover together.

    However, along the upgrade path, companies have also discovered key obstacles to achieving the new opportunities. Without awareness and understanding about these challenges – and their potential consequences – an organization’s upgrade to SQL Server 2012/2014 can be costly, inefficient, and plagued by system errors.

    Here are the top 5 SQL Server 2012/2014 ‘gotchas’ as well as tips for addressing them:
  • Backward compatibility
  • Licensing changes
  • Read/write split
  • Replication awareness
  • Automatic failover
  • 1-Maintain backward compatibility

    To avoid problems, as well as significant future rework, organizations need to address deprecated T-SQL features. For SQL Server 2012/2014, Microsoft will no longer support non-ANSI outer join syntax, requiring that all code be ANSI compliant.

    Because every new release brings deprecation of earlier compatibility levels, companies must be aware of level changes and the impact on their applications. In the case of SQL Server 2012, applications will deprecate to 2000 compatibility, while SQL Server 2014 deprecates to 2005.

    Companies also need to check with their ISVs to verify application support. Support may not be a given when compatibility levels become switched. An ISV with a contract to support an application on 2005 might not necessarily support it on 2012 running compatibility levels for 2005.

    If at all possible, companies should test their applications and scale them to the most modern standards during any upgrade. Best practices dictate that organizations switch to the highest compatibility level of the upgraded SQL Server version. Not doing this puts off the inevitable and the work associated with it, making more work for companies in the long run.

    2-Be aware of licensing changes

    With SQL Server 2012/2014, Microsoft has moved to a core-based licensing model for its Enterprise Edition. Regardless of the number of sockets or cores per-socket, organizations must now pay per core, and the licensing requires a minimum of 4 core licenses per physical processor. While minor variations exist due to individual licensing terms, moving to a 4-core enterprise license from a server license equates to a 4x cost difference on paper for most companies

    The licensing changes also affect customers installing SQL Server 2012/2014 in a virtual environment. If a company runs SQL Server on a VM guest, a minimum of 4 cores must be licensed in the Enterprise Edition. This requirement can be frustrating, as a company using a 2-core VM, for example, must still license for 4 cores even if they are only using half of them.

    It’s not all bad news. With significantly increased resource limits to the Standard Edition (up to 64 GB memory and 16 cores), companies also have a viable alternative to Enterprise Edition for the first time, as well as a solid migration path for the future. In addition, Microsoft has created the Business Intelligence Edition, delivering a Standard Edition SQL engine with the Enterprise Edition intelligence features.

    In addition to paying attention to core count and understanding the licensing pitfalls, companies should consider other ways to offset the higher licensing costs. By maximizing usage of secondary servers to process read loads, organizations can reduce the need to buy larger servers with more cores. Caching can also help reduce the number of queries to be processed, letting companies maintain the needed performance while buying fewer cores. In some instances, database query caching has been able to handle 80% of the database load, sending just 20% to the SQL Server database.

    3-Leverage read/write split – with app changes

    By allowing secondary servers to process read traffic instead of just sitting idle, AlwaysOn enables companies to serve more traffic and improve their application response times.

    However, to leverage this capability, applications must be modified to build support for read-intent strings to connect to secondaries. Furthermore, applications need to be modified to identify which queries/stored procedures to route to secondaries. This application modification takes up a lot of time and resources, often delaying companies from benefitting from SQL Server 2012/2014’s new scale out features.

    To solve this problem and avoid application modification, some companies have implemented either homegrown or third-party database traffic management software. Sitting between the application and the database, database traffic management software understands SQL syntax and can classify them as reads or writes. It can also discover the definition of a stored procedure from the database server to find out whether a particular stored procedure is a read-only or a read/write operation. With this detailed SQL state knowledge, the software can automatically load balance SQL traffic amongst primary and secondary servers, sending transactions and writes to the primary and distributing read-only traffic amongst the secondaries.

    By offloading the need to build this intelligence into the application, companies can quickly take advantage of SQL Server 2012/2014’s advanced features.

    4-Ensure replication awareness

    Because AlwaysOn is constantly replicating data from the primary server to the secondaries, the possibility emerges for replication lag. If the secondaries fall too far behind in replication, the data on secondary servers can become stale.

    While the primary server remains the authoritative source for writing to the database in SQL Server 2012/2014, the secondary server now has the same data, which allows users to read from it. However, in supporting reads from the secondary, organizations must be aware that 1) the secondary server will always be a little behind the primary server; and 2) applications need to define the threshold of tolerance for delay, i.e., to what level that data can be “behind” in timing.

    If applications are reading stale data, it can lead to inconsistent behavior. Different users might see different values for the same query, or – even worse – users might see older, incomplete data even when they have finished a transaction.

    Modifying applications to support replication awareness can be a highly complex and costly process, requiring the organization to build a replication-monitoring engine and integrate it with application code. That modified application can then check to make sure that each server to which it is sending reads is in sync with the primary server. Adding to the complexity, most applications, such as .NET or PHP, are written like an integrated script, making it even more difficult and time-consuming to achieve replication awareness.

    By integrating replication monitoring with load balancing and SQL flow control through the use of software, companies can establish a maximum replication delay threshold – without modifying any applications. Such software will not send reads to a secondary server that is more than one second behind the primary, for example. This approach keeps data access consistent even when supporting reads from secondary servers. The replication monitoring process can even alert administrators of potential networking or database issues that might have caused the replication lag or breakage in the first place.

    5-Enable automated failover

    SQL Server 2012/2014 limits automated failover to servers sitting within a single data center, despite having the ability to scale beyond a single data center. With virtual network name (VNN, also referred to as the Active Group Listener), SQL Server 2012/2014 provides a method to discover the new primary when a server fails.

    However, VNN has significant limitations since it redirects read-intent connections directly to the secondary server and does not act as an aggregation endpoint. This redirection can lead to increased downtime and application errors during failover as both the primary being failed and the secondary being promoted will drop their connections.

    One way around this limitation is to deploy software that acts as an abstraction layer between the database and the application. In this architecture, that software replaces the VNN as the destination for SQL connections. The software then routes SQL queries on behalf of the app, with detailed understanding of all queries. This architecture enables failover that is transparent to the application – with no dropping of the connections and queuing of inbound traffic so applications see few to no errors.

    Bottom Line - Focus on the Big Picture

    At the end of the day, a database upgrade is never just about the database. SQL Server 2012/2014’s new capabilities, including the AlwaysOn HA features, promise huge benefits, but they also create significant complexity.

    Companies must consider how an upgrade affects not only performance and costs but also other parts of their infrastructure. The challenges of programming applications to understand and leverage scaled out database infrastructure are many.  

    An upgrade can be a good time to consider making other architectural changes – such as creating an abstraction layer using a SQL proxy or database load balancing software.

    About the author:

    Varun Singh, Founder and CTO, ScaleArc

    As Chief Technology Officer, Varun leads ScaleArc’s product development and technology strategy. Varun also served as ScaleArc’s CEO from March 2009 to Sept 2013. Varun is a technologist with broad experience in several fields, from running Linux-based BBS systems in the pre-Internet days to writing about technology and open source software at PC Quest, CHIP, Digit, and Network Computing, to creating India’s top online technology brands such as TechTree and Tech2, to hosting technology shows on CNBC, TV18, CNN-IBN and ET Now. He led large web and application development teams as CTO at Network 18's web division and built the highly scalable technology behind large websites like IN.com, MoneyControl.com, and various other portals.


    Column Store Index in MS SQL 2012 / 2014 | killexams.com real questions and Pass4sure dumps

    Introduction

    Column store index is the unique feature of Microsoft SQL Server starting from Microsoft SQL 2012 and improving with Microsoft SQL Server 2014. Here in this article I am going to discuss about the architecture of Column store Index.

    Please note that this Column store Index architecture is suitable only for OLAP or BI environment not in OTLP environment, others the performance down.

    Architecture of Column Store Index

    Before going to the depth of the architecture of column store index in MS SQL 2012, they assume that the they all well known about the row based index and how it load in the memory to fulfill the request of a query.

    First of all they look at the figure to understand the column store index properly

    Segment Concept:

    Each column in the column store index is it own segment. A Segment contains the value from one column only. Each and every column in a table that include in the column store index forms individual segment. Which allows the column data access individually. Each segment can from by multiple pages.

    A segment has the limitation of 1 millions of rows. So for a big table it is not be possible to fit single entire columns within a single segment, so single column of a table may be fit with multiple segments.

    Data is transferred from the disk to memory by segment, not by page. A segment is a highly compressed Large Object (LOB) that can contain up to one million rows. The data within each column’s segment matches row-by-row so that the rows can always be assembled correctly.

    In their example the disk data came from three pages that is Page -1, Page-2 and Page-3. If they crate column store index in the column named “Name” then the segment is created from Page-1, Page-2 and Page-3.

    Group Concept:

    When a column is not fit in a single segment as the data of columns exceed the one million then columns takes multiple segments to store data. In such cases, multiple segments are created for each column and grouped into multiple row groups, one for each set of segments.

    When a column store index is broken into multiple row groups, each row group contains a set of complete rows.  Please look at the bellow figure to understand it properly.

    Dictionary Concept:

    Besides column segments a column store index consists of another data storage element: dictionaries. Dictionaries are widely used in columnar storage as a means to efficiently encode large data types, like strings. The values stores in the column segments will be just entry numbers in the dictionary, and the actual values are stored in the dictionary. This technique can yield very good compression for repeated values, but yields bad results if the values are all distinct (the required storage actually increases). This is what makes large columns (strings) with distinct values very poor candidates for column store indexes. Column store indexes contain separate dictionaries for each column and string columns contain two types of dictionaries.

    Primary Dictionary

    This is a global dictionary used by all segments of a column.

    Secondary Dictionary

    This is an overflow dictionary for entries that did not fit in the primary dictionaries. It can be shared by several segments of a column: the relation between dictionaries and column segments is one-to-many.

    Data Compression:

    Column store indexes are based on xVelocity (formerly known as VertiPaq), an advanced storage and compression technology that originated with Power Pivot and Analysis Services but has been adapted to SQL Server 2012 databases.

    New feature of Column Store in SQL 2014

  • We can create only one non-clustered column store index on a table although they can include all the columns of the table in the single index.
  • SQL Server 2014 enhances it to add support for creating Clustered Column store Index.
  • When they create a column store index and it makes the table read only.
  • With SQL Server 2014, they can create a column store index without having much impact on write-ability on the table. This means they can issue some INSERT, UPDATE, DELETE statements with a table with clustered column store index. No more tedious workaround is required for writing data to a table with column store index in this release like the previous release.
  • Hope you like it.



    Direct Download of over 5500 Certification Exams

    3COM [8 Certification Exam(s) ]
    AccessData [1 Certification Exam(s) ]
    ACFE [1 Certification Exam(s) ]
    ACI [3 Certification Exam(s) ]
    Acme-Packet [1 Certification Exam(s) ]
    ACSM [4 Certification Exam(s) ]
    ACT [1 Certification Exam(s) ]
    Admission-Tests [13 Certification Exam(s) ]
    ADOBE [93 Certification Exam(s) ]
    AFP [1 Certification Exam(s) ]
    AICPA [2 Certification Exam(s) ]
    AIIM [1 Certification Exam(s) ]
    Alcatel-Lucent [13 Certification Exam(s) ]
    Alfresco [1 Certification Exam(s) ]
    Altiris [3 Certification Exam(s) ]
    Amazon [2 Certification Exam(s) ]
    American-College [2 Certification Exam(s) ]
    Android [4 Certification Exam(s) ]
    APA [1 Certification Exam(s) ]
    APC [2 Certification Exam(s) ]
    APICS [2 Certification Exam(s) ]
    Apple [69 Certification Exam(s) ]
    AppSense [1 Certification Exam(s) ]
    APTUSC [1 Certification Exam(s) ]
    Arizona-Education [1 Certification Exam(s) ]
    ARM [1 Certification Exam(s) ]
    Aruba [6 Certification Exam(s) ]
    ASIS [2 Certification Exam(s) ]
    ASQ [3 Certification Exam(s) ]
    ASTQB [8 Certification Exam(s) ]
    Autodesk [2 Certification Exam(s) ]
    Avaya [101 Certification Exam(s) ]
    AXELOS [1 Certification Exam(s) ]
    Axis [1 Certification Exam(s) ]
    Banking [1 Certification Exam(s) ]
    BEA [5 Certification Exam(s) ]
    BICSI [2 Certification Exam(s) ]
    BlackBerry [17 Certification Exam(s) ]
    BlueCoat [2 Certification Exam(s) ]
    Brocade [4 Certification Exam(s) ]
    Business-Objects [11 Certification Exam(s) ]
    Business-Tests [4 Certification Exam(s) ]
    CA-Technologies [21 Certification Exam(s) ]
    Certification-Board [10 Certification Exam(s) ]
    Certiport [3 Certification Exam(s) ]
    CheckPoint [43 Certification Exam(s) ]
    CIDQ [1 Certification Exam(s) ]
    CIPS [4 Certification Exam(s) ]
    Cisco [318 Certification Exam(s) ]
    Citrix [48 Certification Exam(s) ]
    CIW [18 Certification Exam(s) ]
    Cloudera [10 Certification Exam(s) ]
    Cognos [19 Certification Exam(s) ]
    College-Board [2 Certification Exam(s) ]
    CompTIA [76 Certification Exam(s) ]
    ComputerAssociates [6 Certification Exam(s) ]
    Consultant [2 Certification Exam(s) ]
    Counselor [4 Certification Exam(s) ]
    CPP-Institue [2 Certification Exam(s) ]
    CPP-Institute [2 Certification Exam(s) ]
    CSP [1 Certification Exam(s) ]
    CWNA [1 Certification Exam(s) ]
    CWNP [13 Certification Exam(s) ]
    CyberArk [1 Certification Exam(s) ]
    Dassault [2 Certification Exam(s) ]
    DELL [11 Certification Exam(s) ]
    DMI [1 Certification Exam(s) ]
    DRI [1 Certification Exam(s) ]
    ECCouncil [21 Certification Exam(s) ]
    ECDL [1 Certification Exam(s) ]
    EMC [129 Certification Exam(s) ]
    Enterasys [13 Certification Exam(s) ]
    Ericsson [5 Certification Exam(s) ]
    ESPA [1 Certification Exam(s) ]
    Esri [2 Certification Exam(s) ]
    ExamExpress [15 Certification Exam(s) ]
    Exin [40 Certification Exam(s) ]
    ExtremeNetworks [3 Certification Exam(s) ]
    F5-Networks [20 Certification Exam(s) ]
    FCTC [2 Certification Exam(s) ]
    Filemaker [9 Certification Exam(s) ]
    Financial [36 Certification Exam(s) ]
    Food [4 Certification Exam(s) ]
    Fortinet [14 Certification Exam(s) ]
    Foundry [6 Certification Exam(s) ]
    FSMTB [1 Certification Exam(s) ]
    Fujitsu [2 Certification Exam(s) ]
    GAQM [9 Certification Exam(s) ]
    Genesys [4 Certification Exam(s) ]
    GIAC [15 Certification Exam(s) ]
    Google [4 Certification Exam(s) ]
    GuidanceSoftware [2 Certification Exam(s) ]
    H3C [1 Certification Exam(s) ]
    HDI [9 Certification Exam(s) ]
    Healthcare [3 Certification Exam(s) ]
    HIPAA [2 Certification Exam(s) ]
    Hitachi [30 Certification Exam(s) ]
    Hortonworks [4 Certification Exam(s) ]
    Hospitality [2 Certification Exam(s) ]
    HP [752 Certification Exam(s) ]
    HR [4 Certification Exam(s) ]
    HRCI [1 Certification Exam(s) ]
    Huawei [21 Certification Exam(s) ]
    Hyperion [10 Certification Exam(s) ]
    IAAP [1 Certification Exam(s) ]
    IAHCSMM [1 Certification Exam(s) ]
    IBM [1533 Certification Exam(s) ]
    IBQH [1 Certification Exam(s) ]
    ICAI [1 Certification Exam(s) ]
    ICDL [6 Certification Exam(s) ]
    IEEE [1 Certification Exam(s) ]
    IELTS [1 Certification Exam(s) ]
    IFPUG [1 Certification Exam(s) ]
    IIA [3 Certification Exam(s) ]
    IIBA [2 Certification Exam(s) ]
    IISFA [1 Certification Exam(s) ]
    Intel [2 Certification Exam(s) ]
    IQN [1 Certification Exam(s) ]
    IRS [1 Certification Exam(s) ]
    ISA [1 Certification Exam(s) ]
    ISACA [4 Certification Exam(s) ]
    ISC2 [6 Certification Exam(s) ]
    ISEB [24 Certification Exam(s) ]
    Isilon [4 Certification Exam(s) ]
    ISM [6 Certification Exam(s) ]
    iSQI [7 Certification Exam(s) ]
    ITEC [1 Certification Exam(s) ]
    Juniper [65 Certification Exam(s) ]
    LEED [1 Certification Exam(s) ]
    Legato [5 Certification Exam(s) ]
    Liferay [1 Certification Exam(s) ]
    Logical-Operations [1 Certification Exam(s) ]
    Lotus [66 Certification Exam(s) ]
    LPI [24 Certification Exam(s) ]
    LSI [3 Certification Exam(s) ]
    Magento [3 Certification Exam(s) ]
    Maintenance [2 Certification Exam(s) ]
    McAfee [8 Certification Exam(s) ]
    McData [3 Certification Exam(s) ]
    Medical [69 Certification Exam(s) ]
    Microsoft [375 Certification Exam(s) ]
    Mile2 [3 Certification Exam(s) ]
    Military [1 Certification Exam(s) ]
    Misc [1 Certification Exam(s) ]
    Motorola [7 Certification Exam(s) ]
    mySQL [4 Certification Exam(s) ]
    NBSTSA [1 Certification Exam(s) ]
    NCEES [2 Certification Exam(s) ]
    NCIDQ [1 Certification Exam(s) ]
    NCLEX [2 Certification Exam(s) ]
    Network-General [12 Certification Exam(s) ]
    NetworkAppliance [39 Certification Exam(s) ]
    NI [1 Certification Exam(s) ]
    NIELIT [1 Certification Exam(s) ]
    Nokia [6 Certification Exam(s) ]
    Nortel [130 Certification Exam(s) ]
    Novell [37 Certification Exam(s) ]
    OMG [10 Certification Exam(s) ]
    Oracle [282 Certification Exam(s) ]
    P&C [2 Certification Exam(s) ]
    Palo-Alto [4 Certification Exam(s) ]
    PARCC [1 Certification Exam(s) ]
    PayPal [1 Certification Exam(s) ]
    Pegasystems [12 Certification Exam(s) ]
    PEOPLECERT [4 Certification Exam(s) ]
    PMI [15 Certification Exam(s) ]
    Polycom [2 Certification Exam(s) ]
    PostgreSQL-CE [1 Certification Exam(s) ]
    Prince2 [6 Certification Exam(s) ]
    PRMIA [1 Certification Exam(s) ]
    PsychCorp [1 Certification Exam(s) ]
    PTCB [2 Certification Exam(s) ]
    QAI [1 Certification Exam(s) ]
    QlikView [1 Certification Exam(s) ]
    Quality-Assurance [7 Certification Exam(s) ]
    RACC [1 Certification Exam(s) ]
    Real-Estate [1 Certification Exam(s) ]
    RedHat [8 Certification Exam(s) ]
    RES [5 Certification Exam(s) ]
    Riverbed [8 Certification Exam(s) ]
    RSA [15 Certification Exam(s) ]
    Sair [8 Certification Exam(s) ]
    Salesforce [5 Certification Exam(s) ]
    SANS [1 Certification Exam(s) ]
    SAP [98 Certification Exam(s) ]
    SASInstitute [15 Certification Exam(s) ]
    SAT [1 Certification Exam(s) ]
    SCO [10 Certification Exam(s) ]
    SCP [6 Certification Exam(s) ]
    SDI [3 Certification Exam(s) ]
    See-Beyond [1 Certification Exam(s) ]
    Siemens [1 Certification Exam(s) ]
    Snia [7 Certification Exam(s) ]
    SOA [15 Certification Exam(s) ]
    Social-Work-Board [4 Certification Exam(s) ]
    SpringSource [1 Certification Exam(s) ]
    SUN [63 Certification Exam(s) ]
    SUSE [1 Certification Exam(s) ]
    Sybase [17 Certification Exam(s) ]
    Symantec [135 Certification Exam(s) ]
    Teacher-Certification [4 Certification Exam(s) ]
    The-Open-Group [8 Certification Exam(s) ]
    TIA [3 Certification Exam(s) ]
    Tibco [18 Certification Exam(s) ]
    Trainers [3 Certification Exam(s) ]
    Trend [1 Certification Exam(s) ]
    TruSecure [1 Certification Exam(s) ]
    USMLE [1 Certification Exam(s) ]
    VCE [6 Certification Exam(s) ]
    Veeam [2 Certification Exam(s) ]
    Veritas [33 Certification Exam(s) ]
    Vmware [58 Certification Exam(s) ]
    Wonderlic [2 Certification Exam(s) ]
    Worldatwork [2 Certification Exam(s) ]
    XML-Master [3 Certification Exam(s) ]
    Zend [6 Certification Exam(s) ]





    References :


    Blogspot : http://killexamz.blogspot.com/2017/05/killexamscom-70-461-braindumps-and.html
    Youtube : https://youtu.be/Bz-58D9BgHg
    weSRCH : https://www.wesrch.com/business/prpdfBU1HWO000AMUM
    Dropmark : http://killexams.dropmark.com/367904/10847575
    Issu : https://issuu.com/trutrainers/docs/70-461
    Scribd : https://www.scribd.com/document/352582795/Pass4sure-70-461-Querying-Microsoft-SQL-Server-2012-2014-exam-braindumps-with-real-questions-and-practice-software
    Wordpress : http://wp.me/p7SJ6L-1XH
    Dropmark-Text : http://killexams.dropmark.com/367904/12850953
    RSS Feed : http://feeds.feedburner.com/ExactlySame70-461QuestionsAsInRealTestWtf
    Box.net : https://app.box.com/s/8tw4b86rpizdxay5xqvnp0s4wg960bem






    Back to Main Page





    Killexams exams | Killexams certification | Pass4Sure questions and answers | Pass4sure | pass-guaratee | best test preparation | best training guides | examcollection | killexams | killexams review | killexams legit | kill example | kill example journalism | kill exams reviews | kill exam ripoff report | review | review quizlet | review login | review archives | review sheet | legitimate | legit | legitimacy | legitimation | legit check | legitimate program | legitimize | legitimate business | legitimate definition | legit site | legit online banking | legit website | legitimacy definition | pass 4 sure | pass for sure | p4s | pass4sure certification | pass4sure exam | IT certification | IT Exam | certification material provider | pass4sure login | pass4sure exams | pass4sure reviews | pass4sure aws | pass4sure security | pass4sure cisco | pass4sure coupon | pass4sure dumps | pass4sure cissp | pass4sure braindumps | pass4sure test | pass4sure torrent | pass4sure download | pass4surekey | pass4sure cap | pass4sure free | examsoft | examsoft login | exams | exams free | examsolutions | exams4pilots | examsoft download | exams questions | examslocal | exams practice |

    www.pass4surez.com | www.killcerts.com | www.search4exams.com | http://smresidences.com.ph/