免费的sql工具_免费SQL工具

免费的sql工具

Adminer
ApexSQL CI/CD toolkit
ApexSQL Compare
ApexSQL Complete
ApexSQL Decrypt
ApexSQL Plan
ApexSQL Propagate
ApexSQL Refactor
ApexSQL Search
Azure Data Studio (Formerly SQL Operations Studio)
BI Developer Extensions
ClearTrace
Comparator
Database Experimentation Assistant
Database Health Monitor
Database Modeling Excel
Database Performance Analyzer
Data Migration Assistant
DBAchecks
DBAtools
DBComparer
DBeaver
dbDiffo
dbForge Event Profiler
dbForge Monitor
dbForge Search
dbForge SQL Decryptor
DbViewSharp
DLM Dashboard
DTSQL
ERDesigner NG
ExpressProfiler
Flyway
HammerDB
HeidiSQL
Is It SQL
MSKerberos Configuration Manager
LIQUIBASE
Manduka
Partition Management
Plan Explorer
Powershell Scripts
PSDatabaseClone
Pssdiag&Sqldiag Manager
Rapid Database Extractor
RML Utilities
SchemaCrawler
Simple Dynamic Scheduler
sp_Blitz®
sp_whoisactive
SQuirreL SQL Client
SQL Admin Studio
SQL Backup Status Reporter
SQL BI Check
SQLC
SQL Check
SQL Cop
SQL Column Search
SQL Converter
SQL Data Profiler
SqlDiffFramework
SQLDBSearch
SQLDBSize
SQLines Data
SQLite & SQL Server Compact Toolbox
SqlDbAid
SQL Dynamite
sqlectron
SQL ExecStats
SQL-FineBuild
SQL Fragmentation Analyzer
SQL Health Monitor
SQL Heat Map
SQL Hekaton Memory Check
SQL Hunting Dog
SQL Instance Check
SQL Instegrity Check
SQL Job Manager
SQL Migrator
SQL Nexus
SQL Page Viewer
SQL Permissions Extractor
SQLPRep
SQL Query Store Optimizer
SQL Search
SQL Server Migration Assistant for DB2
SQL Server Migration Assistant for MySQL
SQL Server Migration Assistant for Oracle
SQL Server Migration Assistant for SAP ASE
SQL Server Migration Assistant for Access
SQL Server 2005 Best Practices Analyzer
SQL Server 2008 Best Practices Analyzer
SQL Server 2012 Best Practices Analyzer
SQL Scripts Manager
SQL Server Backup
SQL Server Data Tools
SQL Server Integrity Check
SQL Server Index and Statistics Maintenance
SQL Server Management Studio (SSMS)
SQL Server Monitoring
SQL Server Storage manager
SQL Statistics Aggregator
SQL Update Statistics
SQL XEvent Profiler
SysKit Pulse
TSQLT
WhatsUp SQL Server Monitor
xSQL Database Searcher
YourSqlDba

管理员
ApexSQL CI / CD工具包
ApexSQL比较
ApexSQL完成
ApexSQL解密
ApexSQL计划
ApexSQL传播
ApexSQL重构
ApexSQL搜索
Azure数据工作室(以前为SQL Operations Studio)
BI开发人员扩展
ClearTrace
比较器
数据库实验助手
数据库运行状况监控器
数据库建模Excel
数据库性能分析器
数据迁移助手
DBA检查
DBA工具
数据库比较器
DBeaver的
dbDiffo
dbForge事件探查器
dbForge监视器
dbForge搜索
dbForge SQL解密器
DbViewSharp
DLM仪表板
DTSQL
ERDesigner NG
ExpressProfiler
飞路
锤数据库
海蒂SQL
是SQL吗
MSKerberos配置管理器
液基
曼杜卡
分区管理
计划浏览器
Powershell脚本
PSDatabaseClone
Pssdiag&Sqldiag管理器
快速数据库提取器
RML实用程序
模式爬虫
简单动态调度程序
sp_Blitz®
sp_whoisactive
SQuirreL SQL客户端
SQL Admin Studio
SQL备份状态报告程序
SQL BI检查
SQLC
SQL检查
SQL警察
SQL列搜索
SQL转换器
SQL数据探查器
SqlDiffFramework
SQLDB搜索
SQLDB大小
SQLines数据
SQLite和SQL Server Compact工具箱
SqlDbAid
SQL炸药
电子琴
SQL ExecStats
SQL优化构建
SQL碎片分析器
SQL运行状况监视器
SQL热图
SQL Hekaton内存检查
SQL猎狗
SQL实例检查
SQL完整性检查
SQL作业管理器
SQL迁移器
SQL连结
SQL页面查看器
SQL权限提取器
SQLPRep
SQL查询存储优化器
SQL搜索
用于DB2SQL Server迁移助手
适用于MySQLSQL Server迁移助手
适用于OracleSQL Server迁移助手
适用于SAP ASESQL Server迁移助手
SQL Server Access迁移助手
SQL Server 2005最佳实践分析器
SQL Server 2008最佳实践分析器
SQL Server 2012最佳实践分析器
SQL脚本管理器
SQL Server备份
SQL Server数据工具
SQL Server完整性检查
SQL Server索引和统计信息维护
SQL Server管理Studio(SSMS)
SQL Server监控
SQL Server存储管理器
SQL统计汇总器
SQL更新统计
SQL XEvent事件探查器
SysKit Pulse
TSQLT
WhatsUp SQL Server监控器
xSQL数据库搜索器
YourSqlDba

管理员 (Adminer)

Product page: 产品页面Adminer Adminer Latest release: 14-Apr-2017 最新版本 :2017年4月14日 Supported versions: Unknown 支持的版本 :未知 Author: Jakub Vrana 作者 :Jakub Vrana Description: Adminer is a database management tool that allows you to manage databases, tables, columns, relations, indexes, users, permissions, and more from a web-based user interface. Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB. 描述 :Adminer是一种数据库管理工具,使您可以从中管理数据库,表,列,关系,索引,用户,权限以及更多内容基于Web的用户界面。 Adminer(以前称为phpMinAdmin)是用PHP编写的功能齐全的数据库管理工具。 管理员可用于MySQL,PostgreSQL,SQLite,MS SQL,Oracle,Firebird,SimpleDB,Elasticsearch和MongoDB。

ApexSQL CI / CD工具包 (ApexSQL CI/CD toolkit)

Product page: 产品页面ApexSQL CI/CD toolkit ApexSQL CI / CD工具包 Latest release: 20-Dec-2017 最新版本 :2017年12月20日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: ApexSQL 作者 :ApexSQL Description: ApexSQL CI/CD toolkit is a set of open source PowerShell cmdlets for automating work flow pipelines to integrate database changes, test and deliver to production. It supports integration with Bamboo, Jenkins, TeamCity, AppVeyor, GoCD, CruiseControl, Hudson, Visual Studio Team Services, Team Foundation Server, and other CI/CD servers. It contains predefined Continuous Integration (CI) and Continuous Delivery (CD) PowerShell script templates for standalone use where all pipeline steps can be customized, reordered, added and removed. 说明 :ApexSQL CI / CD工具包是一组开源PowerShell cmdlet,用于自动化工作流管道以集成数据库更改,测试并交付生产。 它支持与Bamboo,Jenkins,TeamCity,AppVeyor,GoCD,CruiseControl,Hudson,Visual Studio Team Services,Team Foundation Server和其他CI / CD服务器集成。 它包含预定义的持续集成(CI)和持续交付(CD)PowerShell脚本模板,供独立使用,在其中可以自定义,重新排序,添加和删除所有管道步骤。

ApexSQL比较 (ApexSQL Compare)

Product page: 产品页面ApexSQL Compare ApexSQL Compare Latest release: 26-Jan-2018 最新版本 :2018年1月26日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: ApexSQL 作者 :ApexSQL Description: ApexSQL Compare is a tool that can compare files, SQL Server objects, and folders. It can also be integrated as an add-in into SQL Server Management Studio and Visual Studio or it can be used directly from command line interface. It can perform two-way script comparison and create a merged file. Three comparison modes include Character, Line and Block comparison modes, along with the appropriate syntax highlighting. 说明 :ApexSQL Compare是一个可以比较文件,SQL Server对象和文件夹的工具。 它也可以作为外接程序集成到SQL Server Management Studio和Visual Studio中,或者可以直接从命令行界面使用。 它可以执行双向脚本比较并创建合并文件。 三种比较模式包括字符,行和块比较模式,以及适当的语法突出显示。

ApexSQL完成 (ApexSQL Complete)

Product page: 产品页面ApexSQL Complete ApexSQL Complete Latest release: 25-Jan-2018 最新版本 :2018年1月25日 Supported versions: 2005 – 2017 支持版本 :2005 – 2017 Author: ApexSQL 作者 :ApexSQL Description: ApexSQL Complete is a SQL Server Management Studio and Visual Studio add-in, that speeds up coding by automatically completing SQL code statements, filling in SQL code fragments and more. 说明 :ApexSQL Complete是一个SQL Server Management Studio和Visual Studio加载项,可通过自动完成SQL代码语句来加快编码速度,填写SQL代码片段等。

ApexSQL解密 (ApexSQL Decrypt)

Product page: 产品页面ApexSQL Decrypt ApexSQL Decrypt Latest release: 13-Dec-2017 最新版本 :2017年12月13日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: ApexSQL 作者 :ApexSQL Description: ApexSQL Decrypt is a SQL Server development tool that can decrypt SQL objects from multiple SQL databases, located on different SQL Servers. Before decryption, the original DDL script can be previewed in the Query window as the CREATE or ALTER script type. Decryption can be done directly on a database, or by creating one SQL script for all objects or one SQL script per object. 说明 :ApexSQL Decrypt是一种SQL Server开发工具,可以解密位于不同SQL Server上的多个SQL数据库中SQL对象。 解密之前,可以在“查询”窗口中将原始DDL脚本预览为CREATE或ALTER脚本类型。 解密可以直接在数据库上完成,也可以通过为所有对象创建一个SQL脚本或为每个对象创建一个SQL脚本来完成。

ApexSQL计划 (ApexSQL Plan)

Product page: 产品页面ApexSQL Plan ApexSQL Plan Latest release: 29-Jan-2018 最新版本 :2018年1月29日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: ApexSQL 作者 :ApexSQL Description: ApexSQL Plan is a SQL query analysis and optimization tool. It identifies performance issues and deadlocks, analyzes stored procedures, SQL Server query issues and query execution plans, and helps you understand query performance characteristics. 描述 :ApexSQL Plan是一个SQL查询分析和优化工具。 它识别性能问题和死锁,分析存储过程,SQL Server查询问题和查询执行计划,并帮助您了解查询性能特征。

ApexSQL传播 (ApexSQL Propagate)

Product page: 产品页面ApexSQL Propagate ApexSQL Propagate Latest release: 25-Sep-2017 最新版本 :2017年9月25日 Supported versions: 2005 – 2017 支持版本 :2005 – 2017 Author: ApexSQL 作者 :ApexSQL Description: ApexSQL Propagate is a SQL Server development tool that can execute multiple SQL scripts on multiple SQL databases, located on any SQL Servers, with one-click. Before execution, it can parse SQL scripts to check if their execution will pass or fail. Execution results can be exported into Text or CSV files. 说明 :ApexSQL Propagate是一种SQL Server开发工具,可以在位于任何SQL Server上的多个SQL数据库上执行多个SQL脚本,一键点击。 在执行之前,它可以解析SQL脚本以检查其执行是否成功。 执行结果可以导出到Text或CSV文件中。

ApexSQL重构 (ApexSQL Refactor)

Product page: 产品页面ApexSQL Refactor ApexSQL Refactor Latest release: 22-Jan-2018 最新版本 :2018年1月22日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: ApexSQL 作者 :ApexSQL Description: ApexSQL Refactor is a SQL Server Management Studio and Visual Studio formatting and refactoring add-in for SQL Server with nearly 200 formatting options and 6 refactors such as table partitioning, safe rename, wildcard expansion and more. 说明 :ApexSQL Refactor是SQL Server Management Studio和Visual Studio的格式设置和重构插件,具有将近200种格式设置和表重构,安全重命名,通配符扩展等6种重构。

ApexSQL搜索 (ApexSQL Search)

Product page: 产品页面ApexSQL Search ApexSQL Search Latest release: 11-Dec-2017 最新版本 :2017年12月11日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: ApexSQL 作者 :ApexSQL Description: ApexSQL Search is a SQL Server Management Studio and Visual Studio add-in for SQL object and data text search, extended property management, safe object rename and object dependency visualization. 说明 :ApexSQL Search是SQL Server Management Studio和Visual Studio加载项,用于SQL对象和数据文本搜索,扩展属性管理,安全的对象重命名和对象依赖关系可视化。

Azure数据工作室(以前为SQL Operations Studio) (Azure Data Studio (Formerly SQL Operations Studio))

Product page: 产品页面Azure Data Studio (Formerly SQL Operations Studio) Azure数据工作室(以前为SQL Operations Studio) Latest release: 17-Jan-2018 最新版本 :2018年1月17日 Supported versions: 2008 – 2017 支持的版本 :2008 – 2017 Author: Microsoft 作者 :微软 Description: Azure Data Studio (Formerly SQL Operations Studio) is a free tool that runs on Windows, macOS, and Linux, for managing SQL Server, Azure SQL Database, and Azure SQL Data Warehouse, wherever they’re running. 描述 :Azure数据工作室(以前为SQL Operations Studio)是在Windows,macOS上运行的免费工具和Linux,用于管理运行在任何地方SQL Server,Azure SQL数据库和Azure SQL数据仓库。

BI开发人员扩展 (BI Developer Extensions)

Product page: 产品页面BI Developer Extensions BI开发人员扩展 Latest release: 15-Dec-2017 最新版本 :2017年12月15日 Supported versions: 2015 – 2017 支持版本 :2015年至2017年 Author: Darren Gosbell 作者 :Darren Gosbell Description: A Visual Studio add-in that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDTBI). 描述 :Visual Studio外接程序,可增强Business Intelligence Development Studio(BIDS)和SQL Server数据工具中的开发功能( SSDTBI)。

ClearTrace (ClearTrace)

Product page: 产品页面ClearTrace ClearTrace Latest release: 10-Sep-2017 最新版本 :2017年9月10日 Supported versions: 2008 – 2016 支持的版本 :2008 – 2016 Author: Bill Graziano 作者 :Bill Graziano Description: Summarize SQL Server Query Performance. Enhance SQL Server Performance Tuning. Tool “normalizes” the SQL statements to eliminate transient differences in SQL statements. 描述 :总结SQL Server查询性能。 增强SQL Server性能调整。 工具可以“标准化” SQL语句,以消除SQL语句中的瞬时差异。

比较器 (Comparator)

Product page: 产品页面Comparator 比较器 Latest release: 8-Oct-2017 最新版本 :2017年10月8日 Supported versions: 2008 – 2016 支持版本 :2008 – 2016 Author: Alex Pumpet 作者 :Alex Pumpet Description: A simple program for compare table data from two sources – SQL databases, Excel, CSV or XML-files. 描述 :一个简单的程序,用于比较来自两个来源的表数据-SQL数据库,Excel,CSV或XML文件。

数据库实验助手 (Database Experimentation Assistant)

Product page: 产品页面Database Experimentation Assistant 数据库实验助手 Latest release: 3-Jan-2018 最新版本 :2018年1月3日 Supported versions: 2005 – 2017 支持版本 :2005 – 2017 Author: Microsoft 作者 :微软 Description: Database Experimentation Assistant (DEA) is a new A/B testing solution for SQL Server upgrades. It will assist in evaluating a targeted version of SQL for a given workload. Customers who are upgrading from previous SQL Server versions to any new version of the SQL Server will be able to use these analysis metrics provided, such as queries that have compatibility errors, degraded queries, query plans, and other workload comparison data, to help them build higher confidence, making it a successful upgrade experience. 描述 :数据库实验助手(DEA)是用于SQL Server升级的新A / B测试解决方案。 它将帮助评估给定工作负载的目标SQL版本。 从以前SQL Server版本升级到任何新版本SQL Server的客户将能够使用提供的这些分析指标,例如具有兼容性错误的查询,降级的查询,查询计划和其他工作负载比较数据,以帮助他们建立更高的信心,使其成为成功的升级体验。

数据库运行状况监控器 (Database Health Monitor)

Product page: 产品页面Database Health Monitor 数据库运行状况监视器 Latest release: 28-Oct-2017 最新版本 :2017年10月28日 Supported versions: 2005 – 2016 支持版本 :2005 – 2016 Author: Steve Stedman 作者 :Steve Stedman Description: 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. 说明 :数据库运行状况监视器是一个功能强大的性能监视和诊断解决方案,可向管理员警告其服务器中的服务器运行状况,性能或可用性问题SQL Server环境全部来自中央控制台。

数据库建模Excel (Database Modeling Excel)

Product page: 产品页面Database Modeling Excel 数据库建模Excel Latest release: 30-Nov-2017 最新版本 :2017年11月30日 Supported versions: Unknown 支持的版本 :未知 Author: Yang Ning (Steven) 作者 :杨宁(Steven) Description: Database Modeling Excel is an add-in that was developed to allow users to create database structures easily by using Microsoft Office Excel. 说明 :数据库建模Excel是一个外接程序,旨在让用户使用Microsoft Office轻松创建数据库结构Excel。

数据库性能分析器 (Database Performance Analyzer)

Product page: 产品页面Database Performance Analyzer 数据库性能分析器 Latest release: 15-Feb-2018 最新版本 :2018年2月15日 Supported versions: 2008 – 2017 支持版本 :2008年– 2017年 Author: SolarWinds Worldwide 作者 :SolarWinds Worldwide Description: Reveal performance bottlenecks deep inside your SQL Server, Oracle, DB2 and SAP ASE instances. 描述 :揭示SQL Server,Oracle,DB2和SAP ASE实例内部的性能瓶颈。

数据迁移助手 (Data Migration Assistant)

Product page: 产品页面Data Migration Assistant 数据迁移助手 Latest release: 3-Oct-2017 最新版本 :2017年10月3日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: Microsoft 作者 :Microsoft Description: 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. DMA replaces all previous versions of SQL Server Upgrade Advisor (SSUA). 说明 :数据迁移助手(DMA)使您能够通过检测可能影响数据库功能的兼容性问题来升级到现代数据平台。您的新版本SQL Server。 它建议针对您的目标环境提高性能和可靠性。 它不仅使您可以将架构和数据移动,还可以将不包含对象从源服务器移动到目标服务器。 DMA取代了所有以前SQL Server升级顾问(SSUA)版本。

DBA检查 (DBAchecks)

Product page: 产品页面DBAchecks DBAchecks Latest release: 22-Feb-2018 最新版本 :2018年2月22日 Supported versions: Unknown 支持的版本 :未知 Author: DBAtools 作者 :DBAtools Description: DBAchecks is a new open source module that allows the SQL Server community to crowdsource our checklists and easily test our environments. DBAchecks is a framework created by and for SQL Server pros who need to validate their environments. 说明 :DBAchecks是一个新的开源模块,允许SQL Server社区众包我们的清单并轻松测试我们的环境。 DBAchecks是由需要验证其环境SQL Server专业人员创建的框架。

DBA工具 (DBAtools)

Product page: 产品页面DBAtools DBAtools Latest release: 25-Jun-2018 最新版本 :2018年6月25日 Supported versions: 2000 – 2017 支持版本 :2000 – 2017 Author: DBAtools 作者 :DBAtools Description: DBAtools is a free PowerShell module with over 350 SQL Server best practice, administration, development and migration commands included. Currently, other components of SQL Server such as SSIS, SSRS and SSAS are not supported, but they are part of the overall goal. The high number of commands may seem overwhelming, but think of it like learning SQL Server. Start with the basics like Logins, Jobs, or Backup/Restore and later on, you can move on to Extended Events. 描述 :DBAtools是一个免费的PowerShell模块,包含350多种SQL Server最佳实践,管理,开发和迁移命令。 当前,不支持SQL Server的其他组件,例如SSIS,SSRS和SSAS,但它们是总体目标的一部分。 大量的命令似乎不堪重负,但将其视为学习SQL Server。 从诸如“登录”,“作业”或“备份/还原”之类的基础知识开始,然后再转到“扩展事件”。

数据库比较器 (DBComparer)

Product page: 产品页面DBComparer DBComparer Latest release: 6-Oct-2009 最新版本 :2009年10月6日 Supported versions: 2005 – 2008 支持的版本 :2005 – 2008 Author: DBComparer 作者 :DBComparer Description: DBComparer is a professional database comparison tool for analyzing the differences in Microsoft SQL Server 2008 (and 2005) database structures. It is an excellent tool for any project development team or DBA managing multiple copies of the same database on an SQL Server. 描述 :DBComparer是一个专业的数据库比较工具,用于分析Microsoft SQL Server 2008(和2005)数据库结构中的差异。 对于任何在SQL Server上管理同一数据库的多个副本的项目开发团队或DBA而言,它都是一个出色的工具。

DBeaver的 (DBeaver)

Product page: 产品页面DBeaver DBeaver Latest release: 21-Jan-2018 最新版本 :2018年1月21日 Supported versions: 2005 – 2016 支持的版本 :2005 – 2016 Author: Rider Soft LTD 作者 :Rider Soft LTD Description: 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. 描述 :为开发人员,SQL程序员,数据库管理员和分析人员提供的免费的多平台数据库工具。 支持所有流行的数据库:MySQL,PostgreSQL,SQLite,Oracle,DB2,SQL Server,Sybase,MongoDB,Cassandra等。

dbDiffo (dbDiffo)

Product page: 产品页面dbDiffo dbDiffo Latest release: 28-Jul-2017 最新版本 :2017年7月28日 Supported versions: Unknown 支持的版本 :未知 Author: Contenet Ltd. 作者 :Contenet Ltd. Description: The free online database schema designer. With dbDiffo you can create change scripts with a simple click. 说明 :免费的在线数据库架构设计器。 使用dbDiffo,您只需单击即可创建更改脚本。

dbForge事件探查器 (dbForge Event Profiler)

Product page: 产品页面dbForge Event Profiler dbForge Event Profiler Latest release: 30-Aug-2017 最新版本 :2017年8月30日 Supported versions: 2008 – 2017 支持的版本 :2008 – 2017 Author: Devart 作者 :Devart Description: Monitor the activity of SQL Server Database Engine, Analysis services, and Integration Services, monitor and identify performance-related problems with front-end application, queries, T-SQL, transactions, and much more, perform query analysis of execution plans, monitor and identify SQL Server errors and warnings, audit user activity, analyze, group, and aggregate trace results, and save them to a file, create own custom traces and save them for future use. 描述 :监视SQL Server数据库引擎,Analysis Services和Integration Services的活动,并监视和识别与性能相关的问题端应用程序,查询,T-SQL,事务等,执行执行计划的查询分析,监视和识别SQL Server错误和警告,审核用户活动,分析,分组和汇总跟踪结果,并将它们保存到文件,创建自己的自定义跟踪并将其保存以备将来使用。

dbForge监视器 (dbForge Monitor)

Product page: 产品页面dbForge Monitor dbForge Monitor Latest release: 30-Aug-2017 最新版本 :2017年8月30日 Supported versions: 2008 – 2016 支持的版本 :2008 – 2016 Author: Devart 作者 :Devart Description: dbForge Monitor allows you to track and analyze SQL Server performance. The tool includes a variety tools for SQL Server diagnostics, including a bunch of SQL performance metrics allowing to see the comprehensive and clear picture of all processes taking place on the server, detect most expensive queries, waiting tasks, and performance bottlenecks. 描述 :dbForge Monitor允许您跟踪和分析SQL Server性能。 该工具包括用于SQL Server诊断的各种工具,其中包括大量SQL性能指标,可用于查看服务器上发生的所有进程的全面清晰的画面,检测最昂贵的查询,等待的任务以及性能瓶颈。

dbForge搜索 (dbForge Search)

Product page: 产品页面dbForge Search dbForge Search Latest release: 06-Dec-2017 最新版本 :2017年12月6日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: Devart 作者 :Devart Description: Allows you to search SQL objects, data, and text in your databases. With dbForge Search, you no longer need to look through the entire SSMS Object Explorer to find a required column name, or text in a stored procedure. 描述 :允许您搜索数据库中SQL对象,数据和文本。 使用dbForge Search,您不再需要浏览整个SSMS Object Explorer来查找所需的列名或存储过程中的文本。

dbForge SQL解密器 (dbForge SQL Decryptor)

Product page: 产品页面dbForge SQL Decryptor dbForge SQL Decryptor Latest release: 19-Sep-2017 最新版本 :2017年9月19日 Supported versions: 2000 – 2017 支持的版本 :2000 – 2017 Author: Devart 作者 :Devart Description: Decrypts encrypted stored-procedures, views, triggers, and functions. The tool provides you with the highly responsive UI, syntax highlighting, Unicode support, batch mode, decryption caching and much more. 描述 :解密加密的存储过程,视图,触发器和函数。 该工具为您提供了高度响应的UI,语法高亮显示,Unicode支持,批处理模式,解密缓存等等。

DbViewSharp (DbViewSharp)

Product page: 产品页面DbViewSharp DbViewSharp Latest release: 8-Aug-2014 最新版本 :2014年8月8日 Supported versions: 2005 – 2014 支持的版本 :2005 – 2014 Author: David Moore 作者 :David Moore Description: DbViewSharp is a very useful application that is designed to provide you with a means of exploring and managing SQL databases. 描述 :DbViewSharp是一个非常有用的应用程序,旨在为您提供探索和管理SQL数据库的方式。

DLM仪表板 (DLM Dashboard)

Product page: 产品页面DLM Dashboard DLM Dashboard Latest release: 15-Jul-2016 最新版本 :2016年7月15日 Supported versions: 2005 – 2016 支持的版本 :2005 – 2016 Author: Redgate 作者 :Redgate Description: 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. You get a full history, with line-by-line differences, and a clear audit trail of your database moving from development to production. 描述 :DLM Dashboard监视多达50个数据库,并在数据库开始漂移时立即向您发送电子邮件警报,或者从预期状态改变。 在Web仪表板上,您可以准确看到更改的内容,更改的对象以及更改的时间。 您将获得完整的历史记录,各行之间存在差异,并且对从开发到生产的数据库进行清晰的审计跟踪。

DTSQL (DTSQL)

Product page: 产品页面DTSQL DTSQL Latest release: 18-Aug-2017 最新版本 :2017年8月18日 Supported versions: Unknown 支持的版本 :未知 Author: DigerTech Inc 作者 :Dig​​erTech Inc Description: DtSQL is a universal database tool for developers and database administrators to Query, Edit, Browse, and Manage database objects. It can access most databases and can be used on all major operating systems. DtSQL is a universal database tools which can create, alter, browse and search database objects, execute SQL scripts and edit tables. DtSQL can generate and execute the SQL to create the new schema. DtSQL has tools to edit, format and execute SQL scripts. Enable SQL variable bound prompt. 描述 :DtSQL是开发人员和数据库管理员用于查询,编辑,浏览和管理数据库对象的通用数据库工具。 它可以访问大多数数据库,并且可以在所有主要操作系统上使用。 DtSQL是一种通用数据库工具,可以创建,更改,浏览和搜索数据库对象,执行SQL脚本和编辑表。 DtSQL可以生成并执行SQL以创建新架构。 DtSQL具有编辑,格式化和执行SQL脚本的工具。 启用S​​QL变量绑定提示。

ERDesigner NG (ERDesigner NG)

Product page: 产品页面ERDesigner NG ERDesigner NG Latest release: 10-Apr-2013 最新版本 :2013年4月10日 Supported versions: Unknown 支持的版本 :未知 Author: Mirko Sertic 作者 :Mirko Sertic Description: The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD) such as ERWin and co. 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. 描述 :Mogwai ERDesigner是一个实体关系建模/设计工具(ERD),例如ERWin和co。 它旨在简化数据库建模,并在从数据库设计到架构和代码生成的整个开发过程中为开发人员提供支持。

ExpressProfiler (ExpressProfiler)

Product page: 产品页面ExpressProfiler ExpressProfiler Latest release: 15-Feb-2016 最新版本 :2016年2月15日 Supported versions: 2005 – 2014 支持版本 :2005 – 2014 Author: Oleksii Kovalov 作者 :Oleksii Kovalov Description: ExpressProfiler (aka SqlExpress Profiler) is a simple and fast replacement for SQL Server Profiler with basic GUI and integration with Red Gate Ecosystem project. Tracing of basic set of events (Batch/RPC/SP:Stmt Starting/Completed, Audit login/logout, User error messages, Blocked Process report) and columns (Event Class, Text Data,Login, CPU, Reads, Writes, Duration, SPID, Start/End time, Database/Object/Application name) – both selectable,filters on most data columns, copy all/selected event rows to clipboard in form of XML, find in “Text data” column, export data in Excel’s clipboard format. 描述 :ExpressProfiler(又名SqlExpress Profiler)是具有基本GUI并与Red Gate Ecosystem项目集成SQL Server Profiler的简单快速替代方法。 跟踪基本事件集(批处理/ RPC / SP:开始启动/完成,审核登录/注销,用户错误消息,阻止的过程报告)和列(事件类,文本数据,登录,CPU,读取,写入,持续时间, SPID,开始/结束时间,数据库/对象/应用程序名称)–都可以选择,对大多数数据列进行过滤,将所有/选定的事件行以XML的形式复制到剪贴板,在“文本数据”列中查找,在Excel剪贴板中导出数据格式。

飞路 (Flyway)

Product page: 产品页面Flyway Flyway Latest release: 30-Jan-2018 最新版本 :2018年1月30日 Supported versions: 2014 – 2017 支持的版本 :2014 – 2017 Author: Boxfuse GmbH 作者 :Boxfuse GmbH Description: Flyway is an open-source database migration tool. It strongly favors simplicity and convention over configuration. It is based around just 7 basic commands: Migrate, Clean, Info, Validate, Undo, Baseline and Repair. Migrations can be written in SQL (database-specific syntax (such as PL/SQL, T-SQL, etc.) is supported) or Java (for advanced data transformations or dealing with LOBs). 描述 :Flyway是一个开源数据库迁移工具。 与配置相比,它极力主张简单和约定。 它仅基于7个基本命令:迁移,清理,信息,验证,撤消,基准和修复。 可以使用SQL(支持特定于数据库的语法(例如PL / SQL,T-SQL等))或Java(用于高级数据转换或处理LOB)编写迁移。

锤数据库 (HammerDB)

Product page: 产品页面HammerDB HammerDB Latest release: 16-Jun-2017 最新版本 :2017年6月16日 Supported versions: Unknown 支持的版本 :未知 Author: Steve Shaw 作者 :Steve Shaw Description: HammerDB is a database load testing and benchmarking tool. You use HammerDB to create a test schema, load it with data and simulate the workload of multiple virtual users against the database for both transactional and analytic scenarios. This workload can then be used to derive meaningful information about your environment such as hardware performance comparisons and software configurations. 描述 :HammerDB是数据库负载测试和基准测试工具。 您可以使用HammerDB创建测试架构,将其加载数据并针对事务和分析方案针对数据库模拟多个虚拟用户的工作量。 然后,可以使用此工作负载来获取有关您的环境的有意义的信息,例如硬件性能比较和软件配置。

海蒂SQL (HeidiSQL)

Product page: 产品页面HeidiSQL HeidiSQL Latest release: 19-Dec-2017 最新版本 :2017年12月19日 Supported versions: 2005 – 2016 支持版本 :2005 – 2016 Author: Ansgar Becker 作者 :Ansgar Becker Description: 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. 描述 :HeidiSQL是一个有用且可靠的工具,专为使用流行MySQL服务器,Microsoft SQL数据库和PostgreSQLWeb开发人员设计。 它使您能够浏览和编辑数据,创建和编辑表,视图,过程,触发器和计划的事件。 另外,您可以将结构和数据导出到SQL文件,剪贴板或其他服务器。

是SQL吗 (Is It SQL)

Product page: 产品页面Is It SQL Is It SQL Latest release: 10-Sep-2017 最新版本 :2017年9月10日 Supported versions: 2005 – 2016 支持的版本 :2005 – 2016 Author: Bill Graziano 作者 :Bill Graziano Description: 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. 描述 :监视SQL Server和非SQL Server任务的CPU使用率,每秒捕获批处理请求,监视磁盘I /现场,监控器等待,显示正在运行的查询,捕获基本的人口统计信息(包括版本,开始时间,数据库大小等)。可以无需安装即可运行,也可以作为服务运行。

MSKerberos配置管理器 (MSKerberos Configuration Manager)

Product page: 产品页面MSKerberos Configuration Manager MSKerberos Configuration Manager Latest release: 22-Nov-2017 最新版本 :2017年11月22日 Supported versions: 2008 – 2017 支持版本 :2008 – 2017 Author: Microsoft 作者 :Microsoft Description: 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. 说明 :用于SQL Server的Microsoft Kerberos Configuration Manager是一种诊断工具,可帮助解决SQL Server与Kerberos相关的连接问题,SQL Server Reporting服务和SQL Server Analysis Services。

液基 (LIQUIBASE)

Product page: 产品页面LIQUIBASE LIQUIBASE Latest release: 24-Oct-2016 最新版本 :2016年10月24日 Supported versions: Unknown 支持的版本 :未知 Author: Datical 作者 :Datical Description: 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. 描述 :Liquibase是一个独立于开源数据库的库,用于跟踪,管理和应用数据库架构更改。 它始于2006年,以便更轻松地跟踪数据库更改,尤其是在敏捷软件开发环境中。

曼杜卡 (Manduka)

Product page: 产品页面Manduka Manduka Latest release: 8-Mar-2017 最新版本 :2017年3月8日 Supported versions: Unknown 支持的版本 :未知 Author: Virtusa Corporation 作者 :Virtusa Corporation Description: The Free Static code analyzer: PL-SQL & T-SQL, support for more than 50 violation rules, lightweight& fast, easy to install & use, xml reports. 说明 :免费的静态代码分析器:PL-SQL和T-SQL,支持50多种违反规则,轻巧,快速,易于安装和使用,xml报告。

分区管理 (Partition Management)

Product page: 产品页面Partition Management 分区管理 Latest release: 28-Nov-2012 最新版本 :2012年11月28日 Supported versions: 2005 – 2012 支持版本 :2005年– 2012年 Author: SQLCAT 作者 :SQLCAT Description: This tool uses the Sliding Window technique to remove data from one partition and place it into a staging table, and creates a staging table that’s used to load data into partitions. 描述 :该工具使用滑动窗口技术从一个分区中删除数据并将其放置到临时表中,并创建一个临时表用于将数据加载到分区中。

计划浏览器 (Plan Explorer)

Product page: 产品页面Plan Explorer Plan Explorer Latest release: 27-Oct-2017 最新版本 :2017年10月27日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: SentryOne 作者 :SentryOne Description: Plan Explorer helps you quickly get to the root of the toughest SQL Server query problems. Plan Explorer’s scoring algorithms help you determine the best index to support a given query. Easily view recommended indexes, create and modify indexes, and detect and update old statistics. 描述 :Plan Explorer帮助您快速了解最棘手SQL Server查询问题的根源。 Plan Explorer的评分算法可帮助您确定支持给定查询的最佳索引。 轻松查看推荐索引,创建和修改索引以及检测和更新旧统计信息。

Powershell脚本 (Powershell Scripts)

Product page: 产品页面Powershell Scripts Powershell脚本 Latest release: Unknown 最新版本 :未知 Supported versions: 2008 – 2017 支持的版本 :2008 – 2017 Author: Idera 作者 :Idera Description: 102 sample PowerShell scripts to manage SQL Server objects, for Database Engine, and for Analysis, Integration and Reporting Services. 描述 :102个示例PowerShell脚本,用于管理SQL Server对象,数据库引擎以及分析,集成和报告服务。

PSDatabaseClone (PSDatabaseClone)

Product page: 产品页面PSDatabaseClone PSDatabaseClone Latest release: 27-Jul-2018 最新版本 :2018年7月27日 Supported versions: Unknown 支持的版本 :未知 Author: Sander Stad 作者 :Sander Stad Description: PSDatabaseClone is a PowerShell module dedicated to the provisioning of databases using virtual disk technology. Provisioning databases from our production servers has been a pain since the dawn of the DBA. Nowadays we’re dealing with databases that are terabytes in size and some of even work with databases that stretch the imagination for the most of us. You want to have a tool that enables you to create an image of your database and clone your image to one or more servers in a matter of minutes. 描述 :PSDatabaseClone是一个PowerShell模块,专用于使用虚拟磁盘技术配置数据库。 自从DBA诞生以来,从生产服务器中配置数据库就一直很痛苦。 如今,我们正在处理大小为TB的数据库,有些甚至可以与扩展我们大多数人想象力的数据库一起使用。 您想要一个工具,使您能够在几分钟内创建数据库映像并将其克隆到一个或多个服务器。

Pssdiag&Sqldiag管理器 (Pssdiag&Sqldiag Manager)

Product page: 产品页面Pssdiag&Sqldiag Manager Pssdiag&Sqldiag Manager Latest release: 6-Jan-2017 最新版本 :2017年1月6日 Supported versions: 2008 – 2016 支持的版本 :2008 – 2016 Author: Jack Li 作者 :Jack Li Description: Pssdiag/Sqldiag Manager is a graphic interface that provides customization capabilities to collect data for SQL Server using sqldiag collector engine. The data collected can be used by SQL Nexus tool which help you troubleshoot SQL Server performance problems. 描述 :Pssdiag / Sqldiag Manager是一个图形界面,提供了自定义功能,可以使用sqldiag收集器引擎为SQL Server收集数据。 SQL Nexus工具可以使用收集的数据,该工具可以帮助您解决SQL Server性能问题。

快速数据库提取器 (Rapid Database Extractor)

Product page: 产品页面Rapid Database Extractor Rapid Database Extractor Latest release: Unknown 最新版本 :未知 Supported versions: 2008 R2 – 2017 受支持的版本 :2008 R2 – 2017 Author: Idera 作者 :Idera Description: 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 Server和Oracle数据源。 操作数据库对象。 交互式编辑SQL代​​码。 有选择地执行SQ​​L查询以检索数据。 将数据导出为通用文件格式。 连接到云并在云中运行(临时)。

RML实用程序 (RML Utilities)

Product page: 产品页面RML Utilities RML实用程序 Latest release: 12-Dec-2014 最新版本 :2014年12月12日 Supported versions: 2005 – 2014 支持的版本 :2005 – 2014 Author: Microsoft 作者 :Microsoft Description: The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. 说明 :RML实用程序允许您处理SQL Server跟踪文件并查看显示SQL Server性能的报告。

模式爬虫 (SchemaCrawler)

Product page: 产品页面SchemaCrawler SchemaCrawler Latest release: 10-Jan-2018 最新版本 :2018年1月10日 Supported versions: Unknown 支持的版本 :未知 Author: Sualeh Fatehi 作者 :Sualeh Fatehi Description: 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. 描述 :SchemaCrawler是一个免费的数据库架构发现和理解工具。 SchemaCrawler很好地结合了有用的数据治理功能。 您可以使用正则表达式搜索数据库架构对象,并以可读文本格式输出架构和数据。

简单动态调度程序 (Simple Dynamic Scheduler)

Product page: 产品页面Simple Dynamic Scheduler Simple Dynamic Sc​​heduler Latest release: 23-May-2016 最新版本 :2016年5月23日 Supported versions: 2008 – 2014 支持的版本 :2008 – 2014 Author: Miljan Radovic 作者 :Miljan Radovic Description: Simple Dynamic Scheduler is alternative scheduling utility which uses SQL Server to store all configurations and logic. Main characteristics of Simple Dynamic Scheduler are: simple, dynamic, light-weight, purely T-SQL, open source. 描述 :Simple Dynamic Sc​​heduler是替代的调度实用程序,它使用SQL Server存储所有配置和逻辑。 Simple Dynamic Sc​​heduler的主要特征是:简单,动态,轻量级,纯T-SQL,开源。

sp_Blitz® (sp_Blitz®)

Product page: 产品页面sp_Blitz® sp_Blitz® Latest release: 2-Jun-2016 最新版本 :2016年6月2日 Supported versions: 2005 – 2016 支持的版本 :2005 – 2016 Author: Brent Ozar 作者 :Brent Ozar Description: Fast, easy, free health check that flags common issues in seconds, and for each warning, gives you a link to a web page with more in-depth advice. 描述 :快速,轻松,免费的运行状况检查,可在几秒钟内标记出常见问题,并且对于每个警告,都为您提供链接到网页上有更深入的建议。

sp_whoisactive (sp_whoisactive)

Product page: 产品页面sp_whoisactive® sp_whoisactive® Latest release: 10-Dec-2017 最新版本 :2017年12月10日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: Adam Machanic 作者 :Adam Machanic Description: sp_whoisactive is a comprehensive activity monitoring stored procedure that works for all versions of SQL Server from 2005 through 2017 描述 :sp_whoisactive是一种全面的活动监视存储过程,适用于2005年至2017年的所有版本SQL Server。

SQuirreL SQL客户端 (SQuirreL SQL Client)

Product page: 产品页面SQuirreL SQL Client SQuirreL SQL Client Latest release: 29-Aug-2017 最新版本 :2017年8月29日 Supported versions: Unknown 支持的版本 :未知 Author: Colin Bell, Gerd Wagner 作者 :Colin Bell,Gerd Wagner Description: SQuirreL SQL Client is a JAVA-based database administration tool for JDBC compliant databases. It allows you to view the database structure and issue SQL commands. It provides an editor that offers code completion and syntax highlighting for standard SQL. It supports databases such as Firebird, IBM DB2, InterBase, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostreSQL, and Sybase. 描述 :SQuirreL SQL Client是用于JDBC兼容数据库的基于Java的数据库管理工具。 它允许您查看数据库结构并发出SQL命令。 它提供了一个编辑器,为标准SQL提供代码完成和语法高亮显示。 它支持Firebird,IBM DB2,InterBase,Microsoft Access,Microsoft SQL Server,MySQL,Oracle,PostreSQL和Sybase等数据库。

SQL Admin Studio (SQL Admin Studio)

Product page: 产品页面SQL Admin Studio SQL Admin Studio Latest release: Unknown 最新版本 :未知 Supported versions: 2005 – 2014 受支持的版本 :2005 – 2014 Author: Simego Ltd 作者 :Simego Ltd Description: SQL Tools is a Fast and Lightweight (FREE) SQL Manager for Microsoft SQL Server. Features: execute SQL Scripts, view and edit data, create tables and views, compare and sync data between SQL Databases, compare and Sync Schema between SQL Databases. 说明 :SQL Tools是用于Microsoft SQL Server的快速轻量级(免费)SQL Manager。 功能:执行SQL脚本,查看和编辑数据,创建表和视图,在SQL数据库之间比较和同步数据,在SQL数据库之间比较和同步架构。

SQL备份状态报告程序 (SQL Backup Status Reporter)

Product page: 产品页面SQL Backup Status Reporter SQL Backup Status Reporter Latest release: Unknown 最新版本 :未知 Supported versions: 2008 R2 – 2017 支持的版本 :2008 R2 – 2017 Author: Idera 作者 :Idera Description: 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 BI检查 (SQL BI Check)

Product page: 产品页面SQL BI Check SQL BI Check Latest release: Unknown 最新版本 :未知 Supported versions: 2005 – 2017 受支持的版本 :2005 – 2017 Author: Idera 作者 :Idera Description: 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 Server Analysis Services(SSAS)的实时性能监视,请参阅CPU,磁盘和存储的物理服务器指标,查看分析指标SSAS处理,内存和缓存,只需几分钟即可启动并运行,无需任何代理。

SQLC (SQLC)

Product page: 产品页面SQLC SQLC Latest release: Beta release 最新版本 :Beta版本 Supported versions: 2012 – 2016 支持的版本 :2012 – 2016 Author: SQLC 作者 :SQLC Description: SQLC is a software tool for comparing two SQL Server databases. With SQLC you can compare database objects (schema comparison) as well as compare the data in tables (data comparison). 说明 :SQLC是用于比较两个SQL Server数据库的软件工具。 使用SQLC,您可以比较数据库对象(模式比较)以及比较表中的数据(数据比较)。

SQL检查 (SQL Check)

Product page: 产品页面SQL Check SQL Check Latest release: Unknown 最新版本 :未知 Supported versions: 2008 R2 – 2017 受支持的版本 :2008 R2 – 2017 Author: Idera 作者 :Idera Description: Check out what happens in batches, compilations, recompilations, and transactions throughout the SQL Server environment without experiencing any surprises and know where to direct your attention to prevent potential issues. Monitor some of the most important metrics in SQL Server including wait stats, reads, writes, session details, and cache hits. Quickly and easily get up and running within minutes using the installation wizard to guide you through the install process. 描述 :在整个SQL Server环境中检查批处理,编译,重新编译和事务中发生的情况,而不会感到意外,并知道在何处进行处理以防止潜在的问题。 监视SQL Server中一些最重要的指标,包括等待状态,读取,写入,会话详细信息和缓存命中。 使用安装向导可以在几分钟之内快速轻松地启动并运行,以指导您完成安装过程。

SQL警察 (SQL Cop)

Product page: 产品页面SQL Cop SQL Cop Latest release: 23-Aug-2010 最新版本 :2010年8月23日 Supported versions: 2000 – 2008 R2 支持的版本 :2000 – 2008 R2 Author: LessThanDot LLC 作者 :LessThanDot LLC Description: The purpose of SQL Cop is to highlight potential problems in your SQL Server database. SQL Cop detects many different issues. 描述 :SQL Cop的目的是突出显示SQL Server数据库中的潜在问题。 SQL Cop检测到许多不同的问题。

SQL列搜索 (SQL Column Search)

Product page: 产品页面SQL Column Search SQL列搜索 Latest release: Unknown 最新版本 :未知 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: Idera 作者 :Idera Description: Find potentially sensitive data; search an entire instance or a specific table; export results to CSV format for easy analysis and reporting. 说明 :查找潜在的敏感数据;请参阅“安全性指南”。 搜索整个实例或特定表; 将结果导出为CSV格式,以便于分析和报告。

SQL转换器 (SQL Converter)

Product page: 产品页面SQL Converter SQL Converter Latest release: 15-Dec-2015 最新版本 :2015年12月15日 Supported versions: Unknown 支持的版本 :未知 Author: Alaa Ben Fatma 作者 :Alaa Ben Fatma Description: SQL Converter is the utility, allowing one to extract information from source servers selectively and save it to a variety of formats. 说明 :SQL Converter是一种实用程序,允许人们有选择地从源服务器中提取信息并将其保存为多种格式。

SQL数据探查器 (SQL Data Profiler)

Product page: 产品页面SQL Data Profiler SQL Data Profiler Latest release: 23-Oct-2017 最新版本 :2017年10月23日 Supported versions: 2008 – 2017 支持的版本 :2008 – 2017 Author: Idera 作者 :Idera Description: Profile data in SQL Server tables. Analyze subsets of data types at a time. Adjust profiling thresholds to customize the analysis. Display summary of data in selected table and its columns. Receive recommendations based on data per column. View summary of value distribution per column. Export results to plain text file format. 描述 :SQL Server表中的配置文件数据。 一次分析数据类型的子集。 调整分析阈值以自定义分析。 显示所选表及其列中的数据摘要。 根据每列数据接收建议。 查看每列的价值分布摘要。 将结果导出为纯文本文件格式。

SqlDiffFramework (SqlDiffFramework)

Product page: 产品页面SqlDiffFramework SqlDiffFramework Latest release: 28-May-2017 最新版本 :2017年5月28日 Supported versions: Unknown 支持版本 :未知 Author: Michael Sorens 作者 :Michael Sorens Description: Unique in database comparison, SqlDiffFramework compares live data or saved snapshots from any combination of SQL Server, Oracle, MySql, or ODBC data sources (Access, Excel, CSV files, etc.). 描述 :在数据库比较中,SqlDiffFramework具有唯一性,可以比较来自SQL Server,Oracle,MySql或ODBC数据源的任意组合的实时数据或保存的快照( Access,Excel,CSV文件等)。

SQLDB搜索 (SQLDBSearch)

Product page: 产品页面SQLDBSearch SQLDBSearch Latest release: Unknown 最新版本 :未知 Supported versions: 2000 – 2014 受支持的版本 :2000 – 2014 Author: Mohamed Bouarroudj 作者 :Mohamed Bouarroudj Description: SQLDBSearch is a free SQL Server tool that lets you easily and quickly searches for database objects or SQL statements across your databases. 描述 :SQLDBSearch是一个免费SQL Server工具,可让您轻松快速地在整个数据库中搜索数据库对象或SQL语句。

SQLDB大小 (SQLDBSize)

Product page: 产品页面SQLDBSize SQLDBSize Latest release: Unknown 最新版本 :未知 Supported versions: 2000 – 2014 支持的版本 :2000 – 2014 Author: Mohamed Bouarroudj 作者 :Mohamed Bouarroudj Description: SQLDBSize is a free SQL Server tool that allows you to display graphically the size used or reserved by tables, indexes, databases, transaction logs and physical files. 描述 :SQLDBSize是一个免费SQL Server工具,可让您以图形方式显示表,索引,数据库,事务日志和物理文件使用或保留的大小。

SQLines数据 (SQLines Data)

Product page: 产品页面SQLines Data SQLines Data Latest release: 4-Jan-2018 最新版本 :2018年1月4日 Supported versions: 2005 – 2016 支持版本 :2005 – 2016 Author: SQLines 作者 :SQLines Description: SQLines Data is an open source, scalable, parallel high performance data transfer and schema conversion tool that you can use for database migrations and ETL processes. 说明 :SQLines Data是一个开源,可扩展的并行高性能数据传输和架构转换工具,可用于数据库迁移和ETL流程。

SQLite和SQL Server Compact工具箱 (SQLite & SQL Server Compact Toolbox)

Product page: 产品页面SQLite & SQL Server Compact Toolbox SQLite和SQL Server Compact Toolbox Latest release: 11-Nov-2017 最新版本 :2017年11月11日 Supported versions: Unknown 支持的版本 :未知 Author: Erik Ejlskov Jensen 作者 :Erik Ejlskov Jensen Description: Create, manage, develop and maintain embedded database solutions. 描述 :创建,管理,开发和维护嵌入式数据库解决方案。

SqlDbAid (SqlDbAid)

Product page: 产品页面SqlDbAid SqlDbAid Latest release: 10-Feb-2018 最新版本 :2018年2月10日 Supported versions: 2005 – 2017 支持的版本 :2005 – 2017 Author: Miken 作者 :Miken Description: SqlDbAid is an intuitive standalone application that will enable you to easily script database items and data. 描述 :SqlDbAid是一个直观的独立应用程序,使您可以轻松地编写数据库项和数据的脚本。

SQL炸药 (SQL Dynamite)

Product page: 产品页面SQL Dynamite SQL Dynamite Latest release: 5-Oct-2017 最新版本 :2017年10月5日 Supported versions: 2000 – 2016 支持的版本 :2000 – 2016 Author: Anatoly Sova 作者 :Anatoly Sova Description: 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. 描述 :在存储过程,函数,表,视图和触发器中轻松进行文本搜索。 支持MSSQL,Oracle,SAP,Firebird,Mysql,PostgreSQL,DB2,Informix,SQLite,Ingres,SQL Azure,Interbase。

电子琴 (sqlectron)

Product page: 产品页面sqlectron sqlectron Latest release: 4-Jan-2018 最新版本 :2018年1月4日 Supported versions: Unknown 支持的版本 :未知 Author: Unknown 作者 :未知 Description: Manage PostgreSQL, MySQL and Microsoft SQL Server databases and write and execute queries with the help of this SQL editor that is focused on simplicity. 描述 :通过专注于简单性SQL编辑器管理PostgreSQL,MySQL和Microsoft SQL Server数据库并编写和执行查询。

SQL ExecStats (SQL ExecStats)

Product page: 产品页面SQL ExecStats SQL ExecStats Latest release: 11-Feb-2015 最新版本 :2015年2月11日 Supported versions: 2005 – 2014 支持的版本 :2005 – 2014 Author: Joe Chang 作者 :Joe Chang Description: ExecStats started out with a focus on execution plan analysis with cross-referencing index usage to the SQL. Formerly separate programs for performance monitoring and server system architecture discovery via WMI have now been integrated into ExecStats. 描述 :ExecStats最初侧重于执行计划分析,并在SQL中使用交叉引用索引。 以前通过WMI进行性能监视和服务器系统架构发现的独立程序现已集成到ExecStats中。

SQL优化构建 (SQL-FineBuild)

Product page: 产品页面SQL-FineBuild SQL-FineBuild Latest release: 28-Oct-2017 最新版本 :2017年10月28日 Supported versions: 2005 – 2017 支持版本 :2005 – 2017 Author: Edward Vassie 作者 :爱德华·瓦西(Edward Vassie) Description: SQL FineBuild provides 1-click install and best-practice configuration on Windows of SQL Server 2017 down to SQL Server 2005. 描述 :SQL FineBuild在SQL Server 2017的Windows直至SQL Server 2005上提供一键安装和最佳实践配置。

SQL碎片分析器 (SQL Fragmentation Analyzer)

Product page: 产品页面SQL Fragmentation Analyzer SQL Fragmentation Analyzer Latest release: Unknown 最新版本 :未知 Supported versions: 2008 R2 – 2017 支持的版本 :2008 R2 – 2017 Author: Idera 作者 :Idera Description: Analyze fragmentation by one table or an entire database. Identify databases in need of defragmentation. Set fragmentation thresholds: normal, warning, critical. Connect to cloud and run in cloud (provisional). 描述 :按一个表或整个数据库分析碎片。 标识需要进行碎片整理的数据库。 设置碎片阈值:正常,警告,严重。 连接到云并在云中运行(临时)。

SQL运行状况监视器 (SQL Health Monitor)

Product page: 产品页面SQL Health Monitor SQL Health Monitor Latest release: 27-Dec-2010 最新版本 :2010年12月27日 Supported versions: 2005 – 2014 支持版本 :2005 – 2014 Author: ManageEngine 作者 :ManageEngine Description: Monitor CPU, memory and disk space utilization of the SQL Servers Get complete details about SQL Server sessions, buffer, memory, locks and latches, auto discover SQL Servers in the network, view general server performance and utilization details with color coded alerts. The tool connects with MS SQL servers and generates easy to visualize desktop reports and graphs. Using the tool, Administrator can monitor up to 2 MS SQL server simultaneously. 描述 :监视SQL Server的CPU,内存和磁盘空间利用率获取有关SQL Server会话,缓冲区,内存,锁的完整详细信息和闩锁,自动发现网络中SQL Server,并使用颜色编码的警报查看服务器的常规性能和利用率详细信息。 The tool connects with MS SQL servers and generates easy to visualize desktop reports and graphs. Using the tool, Administrator can monitor up to 2 MS SQL server simultaneously.

SQL Heat Map (SQL Heat Map)

Product page: Product page : SQL Heat Map SQL Heat Map Latest release: Unknown Latest release : Unknown Supported versions: 2005 – 2017 Supported versions : 2005 – 2017 Author: Idera Author : Idera Description: The intuitive heat map design provides an easy-to-understand picture of the relative sizes of the tables across each database in your SQL Server instance, so you can rapidly identify the largest capacity consumers. See one visual view of storage utilization in all tables of a database and drill down into each table and index for details. Description : The intuitive heat map design provides an easy-to-understand picture of the relative sizes of the tables across each database in your SQL Server instance, so you can rapidly identify the largest capacity consumers. See one visual view of storage utilization in all tables of a database and drill down into each table and index for details.

SQL Hekaton Memory Check (SQL Hekaton Memory Check)

Product page: Product page : SQL Hekaton Memory Check SQL Hekaton Memory Check Latest release: Unknown Latest release : Unknown Supported versions: 2014 – 2017 Supported versions : 2014 – 2017 Author: Idera Author : Idera Description: 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. Description : 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 Hunting Dog (SQL Hunting Dog)

Product page: Product page : SQL Hunting Dog SQL Hunting Dog Latest release: 16-Aug-2015 Latest release : 16-Aug-2015 Supported versions: 2008 – 2014 Supported versions : 2008 – 2014 Author: Alex Maslyukov, Maxim Novikov Author : Alex Maslyukov, Maxim Novikov Description: SQL Hunting Dog works as an Add in and gives you quick search and smooth navigation. Main features: quickly find tables, stored procedure, functions and views, completely removes the pain of clunky Object Explorer, switch between different servers and databases, perform common operation (select data, modify table, design table, etc.) with ease. Description : SQL Hunting Dog works as an Add in and gives you quick search and smooth navigation. Main features: quickly find tables, stored procedure, functions and views, completely removes the pain of clunky Object Explorer, switch between different servers and databases, perform common operation (select data, modify table, design table, etc.) with ease.

SQL Instance Check (SQL Instance Check)

Product page: Product page : SQL Instance Check SQL Instance Check Latest release: 16-May-2016 Latest release : 16-May-2016 Supported versions: 2005 – 2016 Supported versions : 2005 – 2016 Author: Idera Author : Idera Description: Discover what versions of SQL Server you have by scanning your entire network. Several different scan methods and protocols are available to provide you a complete picture. Scan one IP at a time by IP address, IP range, local subnet, server or computer name, or a stealth probe search. The stealth probe identifies servers registered to the Network Browser Service or the Active Directory. Description : Discover what versions of SQL Server you have by scanning your entire network. Several different scan methods and protocols are available to provide you a complete picture. Scan one IP at a time by IP address, IP range, local subnet, server or computer name, or a stealth probe search. The stealth probe identifies servers registered to the Network Browser Service or the Active Directory.

SQL Integrity Check (SQL Integrity Check)

Product page: Product page : SQL Integrity Check SQL Integrity Check Latest release: Unknown Latest release : Unknown Supported versions: 2000 – 2017 Supported versions : 2000 – 2017 Author: Idera Author : Idera Description: Register databases and SQL Integrity Check will, on a regular basis, verify when the last known successful integrity check was performed. This helps identify any possible corruption early on so you can take action quickly instead of finding out a fix is needed after the corruption has grown even larger in scope. Description : Register databases and SQL Integrity Check will, on a regular basis, verify when the last known successful integrity check was performed. This helps identify any possible corruption early on so you can take action quickly instead of finding out a fix is needed after the corruption has grown even larger in scope.

SQL Job Manager (SQL Job Manager)

Product page: Product page : SQL Job Manager SQL Job Manager Latest release: 19-May-2012 Latest release : 19-May-2012 Supported versions: Unknown Supported versions : Unknown Author: Idera Author : Idera Description: Management console to easily view past and current jobs. Identify and correct job contention. Drag and drop jobs across servers to level workloads. “At a glance” view to see failed or runaway jobs. Customizable calendar view. Connect to cloud and run in cloud (provisional). Description : Management console to easily view past and current jobs. Identify and correct job contention. Drag and drop jobs across servers to level workloads. “At a glance” view to see failed or runaway jobs. Customizable calendar view. Connect to cloud and run in cloud (provisional).

SQL Migrator (SQL Migrator)

Product page: Product page : SQL Migrator SQL Migrator Latest release: 2016 Latest release : 2016 Supported versions: 2005 – 2016 Supported versions : 2005 – 2016 Author: Datamate Technology Author : Datamate Technology Description: Automatically upgrade objects within a SQL Server Instance from lower to higher versions or just refresh Objects between the same Versions. Description : Automatically upgrade objects within a SQL Server Instance from lower to higher versions or just refresh Objects between the same Versions.

SQL Nexus (SQL Nexus)

Product page: Product page : SQL Nexus SQL Nexus Latest release: 26-Jul-2017 Latest release : 26-Jul-2017 Supported versions: 2008 – 2016 Supported versions : 2008 – 2016 Author: Jack Li Author : Jack Li Description: 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. Description : 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.

SQL Page Viewer (SQL Page Viewer)

Product page: Product page : SQL Page Viewer SQL Page Viewer Latest release: Unknown Latest release : Unknown Supported versions: 2005- 2017 Supported versions : 2005- 2017 Author: Idera Author : Idera Description: Displays page level data summary and detail information. Elegant GUI design for fast access in 1 click. Select any SQL server and database table. Navigate to any page data quickly in a tree view. Launch directly within SSMS for optimal usability. Description : Displays page level data summary and detail information. Elegant GUI design for fast access in 1 click. Select any SQL server and database table. Navigate to any page data quickly in a tree view. Launch directly within SSMS for optimal usability.

SQL Permissions Extractor (SQL Permissions Extractor)

Product page: Product page : SQL Permissions Extractor SQL Permissions Extractor Latest release: Unknown Latest release : Unknown Supported versions: 2008 R2 – 2017 Supported versions : 2008 R2 – 2017 Author: Idera Author : Idera Description: Generate T-SQL scripts for copying of user permissions. Edit, save, and execute permissions scripts. Include object level permissions for selected databases. Four steps to copy, extract, modify and apply changes. Connect to cloud and run in cloud (provisional). Description : Generate T-SQL scripts for copying of user permissions. Edit, save, and execute permissions scripts. Include object level permissions for selected databases. Four steps to copy, extract, modify and apply changes. Connect to cloud and run in cloud (provisional).

SQLPRep (SQLPRep)

Product page: Product page : SQLPRep SQLPRep Latest release: 23-Oct-2016 Latest release : 23-Oct-2016 Supported versions: Unknown Supported versions : Unknown Author: Consequential Solutions Author : Consequential Solutions Description: SQLPRep 2015 aka SQL Performance Report is software product that takes any TSQL and produces a concise, readable, highlighted performance report allowing you to greatly reduce your time spent in developing, debugging, optimizing, testing and reviewing TSQL. It includes a comprehensive data results comparison feature to identify data changes between your original version and the optimized version of your TSQL. Description : SQLPRep 2015 aka SQL Performance Report is software product that takes any TSQL and produces a concise, readable, highlighted performance report allowing you to greatly reduce your time spent in developing, debugging, optimizing, testing and reviewing TSQL. It includes a comprehensive data results comparison feature to identify data changes between your original version and the optimized version of your TSQL.

SQL Query Store Optimizer (SQL Query Store Optimizer)

Product page: Product page : SQL Query Store Optimizer SQL Query Store Optimizer Latest release: 1-Jul-2016 Latest release : 1-Jul-2016 Supported versions: 2016 Supported versions : 2016 Author: Idera Author : Idera Description: 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. Description : 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.

SQL Search (SQL Search)

Product page: Product page : SQL Search SQL Search Latest release: 7-Dec-2017 Latest release : 7-Dec-2017 Supported versions: 2005 – 2017 Supported versions : 2005 – 2017 Author: Redgate Author : Redgate Description: SQL Search is a free add-in for SQL Server Management Studio (SSMS) and Visual Studio (VS) that lets you search for SQL in your databases. You can find fragments of SQL in stored procedures, views, jobs and more,quickly navigate to objects anywhere on a server,find all references to an object. Description : SQL Search is a free add-in for SQL Server Management Studio (SSMS) and Visual Studio (VS) that lets you search for SQL in your databases. You can find fragments of SQL in stored procedures, views, jobs and more,quickly navigate to objects anywhere on a server,find all references to an object.

SQL Server Migration Assistant for DB2 (SQL Server Migration Assistant for DB2)

Product page: Product page : SQL Server Migration Assistant for DB2 SQL Server Migration Assistant for DB2 Latest release: 25-Sep-2017 Latest release : 25-Sep-2017 Supported versions: 2012 – 2017 Supported versions : 2012 – 2017 Author: Microsoft Author : Microsoft Description: SQL Server Migration Assistant (SSMA) for DB2 is a tool to automate migration from IBM DB2 database(s) to SQL Server and Azure SQL DB. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion and data migration. Description : SQL Server Migration Assistant (SSMA) for DB2 is a tool to automate migration from IBM DB2 database(s) to SQL Server and Azure SQL DB. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion and data migration.

SQL Server Migration Assistant for MySQL (SQL Server Migration Assistant for MySQL)

Product page: Product page : SQL Server Migration Assistant for MySQL SQL Server Migration Assistant for MySQL Latest release: 25-Sep-2017 Latest release : 25-Sep-2017 Supported versions: 2008 – 2017 Supported versions : 2008 – 2017 Author: Microsoft Author : Microsoft Description: 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. Description : 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.

SQL Server Migration Assistant for Oracle (SQL Server Migration Assistant for Oracle)

Product page: Product page : SQL Server Migration Assistant for Oracle SQL Server Migration Assistant for Oracle Latest release: 25-Sep-2017 Latest release : 25-Sep-2017 Supported versions: 2008 – 2017 Supported versions : 2008 – 2017 Author: Microsoft Author : Microsoft Description: Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a tool to automate migration from Oracle database(s) to SQL Server, Azure SQL DB and Azure SQL Data Warehouse. Description : Microsoft SQL Server Migration Assistant (SSMA) for Oracle is a tool to automate migration from Oracle database(s) to SQL Server, Azure SQL DB and Azure SQL Data Warehouse.

SQL Server Migration Assistant for SAP ASE (SQL Server Migration Assistant for SAP ASE)

Product page: Product page : SQL Server Migration Assistant for SAP ASE SQL Server Migration Assistant for SAP ASE Latest release: 25-Sep-2017 Latest release : 25-Sep-2017 Supported versions: 2008 – 2017 Supported versions : 2008 – 2017 Author: Microsoft Author : Microsoft Description: Microsoft SQL Server Migration Assistant (SSMA) for SAP ASE is a tool to automate migration from SAP ASE database(s) to SQL Server and Azure SQL DB. Description : Microsoft SQL Server Migration Assistant (SSMA) for SAP ASE is a tool to automate migration from SAP ASE database(s) to SQL Server and Azure SQL DB.

SQL Server Migration Assistant for Access (SQL Server Migration Assistant for Access)

Product page: Product page : SQL Server Migration Assistant for Access SQL Server Migration Assistant for Access Latest release: 25-Sep-2017 Latest release : 25-Sep-2017 Supported versions: 2012 – 2017 Supported versions : 2012 – 2017 Author: Microsoft Author : Microsoft Description: Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Microsoft Access database(s) to SQL Server and Azure SQL DB. Description : Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Microsoft Access database(s) to SQL Server and Azure SQL DB.

SQL Server 2005 Best Practices Analyzer (SQL Server 2005 Best Practices Analyzer)

Product page: Product page : SQL Server 2005 Best Practices Analyzer SQL Server 2005 Best Practices Analyzer Latest release: 13-Aug-2008 Latest release : 13-Aug-2008 Supported versions: 2005 Supported versions : 2005 Author: Microsoft Author : Microsoft Description: 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. Description : 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 2008 R2 Best Practices Analyzer (SQL Server 2008 R2 Best Practices Analyzer)

Product page: Product page : SQL Server 2008 R2 Best Practices Analyzer SQL Server 2008 R2 Best Practices Analyzer Latest release: 18-Jun-2010 Latest release : 18-Jun-2010 Supported versions: 2008 – 2008 R2 Supported versions : 2008 – 2008 R2 Author: Microsoft Author : Microsoft Description: 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. Description : 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 (SQL Server 2012 Best Practices Analyzer)

Product page: Product page : SQL Server 2012 Best Practices Analyzer SQL Server 2012 Best Practices Analyzer Latest release: 6-Apr-2012 Latest release : 6-Apr-2012 Supported versions: 2012 Supported versions : 2012 Author: Microsoft Author : Microsoft Description: 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. Description : 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.

SQL Scripts Manager (SQL Scripts Manager)

Product page: Product page : SQL Scripts Manager SQL Scripts Manager Latest release: 9-Feb-2017 Latest release : 9-Feb-2017 Supported versions: 2000 – 2017 Supported versions : 2000 – 2017 Author: Redgate Author : Redgate Description: SQL Scripts Manager is a free tool that brings together must-have scripts to enable you to automate common troubleshooting, diagnostic, and maintenance tasks. SQL Scripts Manager gives you quick, easy access to SQL, IronPython, and SMO scripting. Description : SQL Scripts Manager is a free tool that brings together must-have scripts to enable you to automate common troubleshooting, diagnostic, and maintenance tasks. SQL Scripts Manager gives you quick, easy access to SQL, IronPython, and SMO scripting.

SQL Server Backup (SQL Server Backup)

Product page: Product page : SQL Server Backup SQL Server Backup Latest release: 7-Oct-2016 Latest release : 7-Oct-2016 Supported versions: 2005 – 2017 Supported versions : 2005 – 2017 Author: Ola Hallengren Author : Ola Hallengren Description: Database Backup is the SQL Server Maintenance Solution’s stored procedure for backing up databases. This script creates all the objects and jobs needed. Description : Database Backup is the SQL Server Maintenance Solution's stored procedure for backing up databases. This script creates all the objects and jobs needed.

SQL Server Data Tools (SQL Server Data Tools)

Product page: Product page : SQL Server Data Tools SQL Server Data Tools Latest release: 19-Apr-2017 Latest release : 19-Apr-2017 Supported versions: 2008 – 2017 Supported versions : 2008 – 2017 Author: Microsoft Author : Microsoft Description: SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and redactor databases. You can work with a database project, or directly with a connected database instance on or off-premise. Description : SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model that spans all the phases of database development inside Visual Studio. You can use SSDT Transact-SQL design capabilities to build, debug, maintain, and redactor databases. You can work with a database project, or directly with a connected database instance on or off-premise.

SQL Server Integrity Check (SQL Server Integrity Check)

Product page: Product page : SQL Server Integrity Check SQL Server Integrity Check Latest release: 7-Oct-2016 Latest release : 7-Oct-2016 Supported versions: 2005 – 2017 Supported versions : 2005 – 2017 Author: Ola Hallengren Author : Ola Hallengren Description: Database Integrity Check is the SQL Server Maintenance Solution’s stored procedure for checking the integrity of databases. Description : Database Integrity Check is the SQL Server Maintenance Solution's stored procedure for checking the integrity of databases.

SQL Server Index and Statistics Maintenance (SQL Server Index and Statistics Maintenance)

Product page: Product page : SQL Server Index and Statistics Maintenance SQL Server Index and Statistics Maintenance Latest release: 7-Oct-2016 Latest release : 7-Oct-2016 Supported versions: 2005 – 2017 Supported versions : 2005 – 2017 Author: Ola Hallengren Author : Ola Hallengren Description: Index Optimize is the SQL Server Maintenance Solution’s stored procedure for rebuilding and reorganizing indexes and updating statistics. Description : Index Optimize is the SQL Server Maintenance Solution's stored procedure for rebuilding and reorganizing indexes and updating statistics.

SQL Server Management Studio (SSMS) (SQL Server Management Studio (SSMS))

Product page: Product page : SQL Server Management Studio (SSMS) SQL Server Management Studio (SSMS) Latest release: 7-Dec-2017 Latest release : 7-Dec-2017 Supported versions: 2008 – 2017 Supported versions : 2008 – 2017 Author: Microsoft Author : Microsoft Description: SSMS is an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts. Use SQL Server Management Studio (SSMS) to query, design, and manage your databases and data warehouses, wherever they are – on your local computer, or in the cloud. Description : SSMS is an integrated environment for managing any SQL infrastructure, from SQL Server to SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts. Use SQL Server Management Studio (SSMS) to query, design, and manage your databases and data warehouses, wherever they are – on your local computer, or in the cloud.

SQL Server Monitoring (SQL Server Monitoring)

Product page: Product page : SQL Server Monitoring SQL Server Monitoring Latest release: 11-Feb-2016 Latest release : 11-Feb-2016 Supported versions: 2005 – 2016 Supported versions : 2005 – 2016 Author: Spiceworks Author : Spiceworks Description: With Spiceworks SQL Server Monitoring, you can monitor SQL Server size, connection, speed & more. Spiceworks automatically collects all of the information important to the health of your SQL server databases – including things like memory usage and user connections over time. Description : With Spiceworks SQL Server Monitoring, you can monitor SQL Server size, connection, speed & more. Spiceworks automatically collects all of the information important to the health of your SQL server databases – including things like memory usage and user connections over time.

SQL Server Storage manager (SQL Server Storage manager)

Product page: Product page : SQL Server Storage manager SQL Server Storage manager Latest release: 19-Jun-2012 Latest release : 19-Jun-2012 Supported versions: 2000 – 2008 R2 Supported versions : 2000 – 2008 R2 Author: Lepide Software Author : Lepide Software Description: Lepide SQL Server storage manager is a free utility to analyze performance and structure of your SQL Servers, providing complete visibility of storage space and performance. It enables IT teams to quickly identify potential issues before they occur. Effectively track, manage and plan disk space utilization across your SQL servers. Description : Lepide SQL Server storage manager is a free utility to analyze performance and structure of your SQL Servers, providing complete visibility of storage space and performance. It enables IT teams to quickly identify potential issues before they occur. Effectively track, manage and plan disk space utilization across your SQL servers.

SQL Statistics Aggregator (SQL Statistics Aggregator)

Product page: Product page : SQL Statistics Aggregator SQL Statistics Aggregator Latest release: Unknown Latest release : Unknown Supported versions: 2005- 2017 Supported versions : 2005- 2017 Author: Idera Author : Idera Description: 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. Description : 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 Update Statistics (SQL Update Statistics)

Product page: Product page : SQL Update Statistics SQL Update Statistics Latest release: Unknown Latest release : Unknown Supported versions: 2008 R2 – 2017 Supported versions : 2008 R2 – 2017 Author: Idera Author : Idera Description: 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. Description : 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 XEvent Profiler (SQL XEvent Profiler)

Product page: Product page : SQL XEvent Profiler SQL XEvent Profiler Latest release: Unknown Latest release : Unknown Supported versions: 2012 – 2017 Supported versions : 2012 – 2017 Author: Idera Author : Idera Description: View sessions running on servers and the SQL statements they are executing. Group, sort and export events to find what you need and share with others. Simple, clean design provides quick start and run in 2 clicks. Easily connect to both local and remote SQL Servers. Connect to cloud and run in cloud (provisional). Description : View sessions running on servers and the SQL statements they are executing. Group, sort and export events to find what you need and share with others. Simple, clean design provides quick start and run in 2 clicks. Easily connect to both local and remote SQL Servers. Connect to cloud and run in cloud (provisional).

SysKit Pulse (SysKit Pulse)

Product page: Product page : SysKit Pulse SysKit Pulse Latest release: 6-Sep-2017 Latest release : 6-Sep-2017 Supported versions: Unknown Supported versions : Unknown Author: SysKit Ltd. Author : SysKit Ltd. Description: Automatically discover or manually add servers and server groups to the dashboard. Get information on online/offline server status, performance warnings, and server roles. Description : Automatically discover or manually add servers and server groups to the dashboard. Get information on online/offline server status, performance warnings, and server roles.

TSQLT (TSQLT)

Product page: Product page : TSQLT TSQLT Latest release: 31-Jan-2016 Latest release : 31-Jan-2016 Supported versions: 2005 – 2016 Supported versions : 2005 – 2016 Author: sqlity.net Author : sqlity.net Description: tSQLt is a database unit testing framework for Microsoft SQL Server. tSQLt allows you to implement unit tests in T-SQL. This is important as you do not have to switch between various tools to create your code and your unit tests. Description : tSQLt is a database unit testing framework for Microsoft SQL Server. tSQLt allows you to implement unit tests in T-SQL. This is important as you do not have to switch between various tools to create your code and your unit tests.

WhatsUp SQL Server Monitor (WhatsUp SQL Server Monitor)

Product page: Product page : WhatsUp SQL Server Monitor WhatsUp SQL Server Monitor Latest release: Unknown Latest release : Unknown Supported versions: Unknown Supported versions : Unknown Author: Ipswitch Author : Ipswitch Description: The WhatsUp SQL Server Monitor is a free tool that shows off Ipswitch monitoring technology you can use to catch problems before they begin to affect users. Description : The WhatsUp SQL Server Monitor is a free tool that shows off Ipswitch monitoring technology you can use to catch problems before they begin to affect users.

xSQL Database Searcher (xSQL Database Searcher)

Product page: Product page : xSQL Database Searcher xSQL Database Searcher Latest release: 9-May-2017 Latest release : 9-May-2017 Supported versions: 2005 – 2016 Supported versions : 2005 – 2016 Author: xSQL Software Author : xSQL Software Description: Database Searcher is a free tool that allows you to search the schema of SQL Server databases. Supports simple and complex search expressions, Exports search results to xml or csv files. Description : Database Searcher is a free tool that allows you to search the schema of SQL Server databases. Supports simple and complex search expressions, Exports search results to xml or csv files.

YourSqlDba (YourSqlDba)

Product page: Product page : YourSqlDba YourSqlDba Latest release: 18-Dec-2017 Latest release : 18-Dec-2017 Supported versions: Unknown Supported versions : Unknown Author: Maurice Pelchat Author : Maurice Pelchat Description: YourSqlDb is just a very big T-SQL script that helps a lot in automating database maintenance. Description : YourSqlDb is just a very big T-SQL script that helps a lot in automating database maintenance.

Consider these free tools for SQL Server that improve database developer productivity

Consider these free tools for SQL Server that improve database developer productivity

翻译自: https://www.sqlshack.com/free-sql-tools/

免费的sql工具

  • 0
    点赞
  • 7
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值