SQL Server Tools Directory - Data Administration, Query, Migration, Business Intelligence, ORM
Commercial Microsoft SQl Server Tools
Active BI Portal is business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and intranet. Active BI Portal consists of two parts Active BI Portal Manager which works on Windows only and server part which is collection of PHP scripts and can be run on Windows, UNIX or Linux. Active BI Portal works with all major commercial and open source databases.
This software is the ultimate ASP.NET query builder, a component that will make building SQL queries easier than you could ever have imagined. Active Query Builder ASP.NET Edition provides web developers with the tool they need to build SQL queries visually, using a user-friendly interface in the style of Microsoft Access.
Active Query Builder Java Edition is a visual component for Java environment to allow your end users to build complex SQL queries visually via user-friendly graphical interface easily. Active Query Builder renders all SQL features, such as sub-queries and unions, very easy to accomplish and provides the professional user with everything he or she needs to efficiently work with queries. It is a perfect choice for both SQL beginners and experienced query writers. By embedding Active Query Builder into your Java applets and applications, you can make it easy for beginners and provide a powerful tool for professionals.
Active Table Editor helps the users edit ANY table in ANY Database. Active Table Editor allows the administrator to log in and design the look of the application for the end users. You can edit user menus, security settings, menu items and input forms. All this complexity is left behind the scene for the end users. Once logged in, the end users see and edit the data, which was defined by the administrator. There is also an opportunity to use command line and in this way bypass login screen. The product works with all major commercial and open source databases.
Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be transformed and loaded into the data warehouse or database without actually loading it. At any time, you can press the 'Preview' button and see what the results of an ETL flow would look like. Advanced ETL Processor can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into the database, run stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Advanced ETL Processor can also add new and update old records based on the key defined by user.
Advanced ETL Processor Enterprise is a Codeless Automation Tool. Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis. Advanced ETL Processor Enterprise supports complex enterprise environments including database , file, smtp, pop3 and ftp servers. Advanced ETL Processor Enterprise is designed to automate everyday routine tasks. Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data , deduplicate it and load it into the database, run stored procedure or Sql script. Once loading is completed send email to the administrator. The Enterprise version includes execution agent which can be run as a Windows service.
AnySQL Maestro is a unique tool for administering any database engine (SQL Server, Oracle, MySQL, MS Access, etc.) which is accessible via ODBC driver or OLE DB provider.
The BatchDeduplicator is a program for regular doublet searches performed in address tables on a fixed schedule, in order to ensure the long-term quality of this data. Particularly repetitive advertising in the case of direct marketing and the unnecessary repeated maintenance of client and other address data can thus be avoided. Of course, this leads to a direct savings of costs. Furthermore, a doublet search between two tables can also take a list of customers who do not wish to receive marketing transmissions into consideration, which can save a lot of trouble.
CodeNGen is an n-tier code generation tool which utilizes table structures and relationships in an SQL Server database to generate C# business entities, data access code, and stored procedures. CodeNGen drastically reduces development time of scalable data driven applications.
By using Solix Enterprise Data Archiving the performance of the application is restored up to 50% by archiving those data which has been underutilized. Normally data gets stored in Tier 1 storage system but Enterprise Data Archiving stores data in less expensive Tier 2 storage. The advantage of Data Archiving is that the organization can cut on IT costs as it no longer needs large data sets.
Data Exchange Wizard imports data from a text file, a Microsoft Excel spreadsheets, or a Microsoft Access databases into any database, including Oracle, MS SQL Server or any ODBC compliant database. Alternatively, data from Oracle, MS SQL Server or any ODBC source can be exported into flat files. The export and import operations are automatic and do not require advanced technical knowledge and skills.
Data Loader is a simple yet powerful tool to import and export Data between many common formats. Current Data Loader Ver. 3.0 supports MS-SQL Server, MySQL, Oracle, MS Access, FoxPro, DBF's, CSV & Delimited or Flat Files. You can use Data Loader to transfer data from one database format to another database format. While transferring you can filter columns and specify WHERE conditions. It supports Long , Picture Data types.
Database Workbench is a multi-database tool with specifics for each supported engine. It supports editing metadata, running queries and scripts, transferring data, importing and exporting, printing metadata and much more. Supported database systems: - MySQL - Oracle - Firebird - Microsoft SQL Server - InterBase - NexusDB
Altova DatabaseSpy 2007 is the unique multi-database data management, query, and design tool from the creators of XMLSpy. DatabaseSpy connects to all major databases, easing SQL editing and database structure design, for a fraction of the cost of single-database solutions. The Database Browser clearly presents your tables, views, and data in easily negotiable windows. The DatabaseSpy SQL Editor facilitates query writing with capabilities like code completion, syntax coloring, drag & drop construction, and more. And the powerful Database Design Editor enables graphical design and visualization of database structures or schemas.
DataQualityTools is a collection of tools to help businesses improve the quality of their databases. The central components are a series of functions which help to find duplicate records and, above all, a function for error-tolerant doublet search based on postal addresses.
DataWings addresses three functional areas within the broader area of supporting integration testing of code that accesses and modifies data stored in a relational database.
DB Data Generator is a simple, powerful data generator that allows developers to easily populate databases with thousands of rows of meaningful and syntactically correct test data for database testing purposes.
The DB Ghost tools, in conjunction with any source control system, provide a true change management solution for SQL Server code. It guarantees a full audit trail and complete database integrity by building and promoting databases directly from a source control system whilst preserving data in the target databases.
DBConvert for Oracle and MS SQL is a database migration tool which performs two-way conversion from Oracle databases to MS SQL server and from MS SQL to Oracle. The tool is also applicable for MS SQL database migration to another MS SQL database and is quite adept at copying a Oracle database to another Oracle database.
DBConvert for SQLite and MS SQL is a database migration tool which performs two-way conversion from SQLite databases to MS SQL server and from MS SQL to SQLite. The tool is also applicable for MS SQL database migration to another MS SQL database or to MS SQL server and is quite adept at copying a SQLite database to another SQLite database.
dbExpress is a database-independent layer that defines a common interface to provide fast access to SQL database servers. For each supported server, dbExpress provides a driver as an independent library that implements the common dbExpress interfaces for processing queries and stored procedures. As a thin and simple data-access layer, dbExpress provides high performance database connectivity and is easy to deploy.
Data Compare is a fast, easy-to-use tool to compare and synchronize data of Microsoft SQL Server databases. You can quickly analyze data differences in a well-designed user interface and synchronize comparison results in a convenient wizard with additional options.
dbForge Schema Compare for SQL Server is a reliable, easy-to-use tool to compare and synchronize structures of Microsoft SQL Server databases. This product is specially designed to help you quickly analyze database structure differences at a glance and propagate the changes to a required SQL Server escaping tedious manual work.
DBSync for Oracle and MS SQL is a database synchronization tool which performs two-way conversion and synchronization from Oracle databases to MS SQL server and from MS SQL to Oracle. The tool is also applicable for MS SQL database replication to another MS SQL database and is quite adept at copying a Oracle database to another Oracle database.
DBSync for SQLite and MSSQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from SQLite to MS SQL or from MS SQL to SQLite with the ability to copy the whole database as well as to convert particular tables, fields, indexes and foreign keys by simple configuring of several options through a Wizard interface or in command line mode.
Stored procedure compatible with Microsoft SQL Server 2000 and 2005 that automatically deletes unnecessarily users from your database.
This ActiveX helps you to load and export data from/into various datasources such as delimited and fixed width files or ODBC data source into/from Oracle, MS SQL Server or any ODBC compliant database Uses naitive API, Capable of performing calculation during import, may also execute SQL statements before and after Import or Export . Integrated expression builder, comprehensive error log, rejected records file.
DIVA - Database Immersive Visual Analysis: a viewer for databases physical structure that can show you any section of DB in different ways (2D, 2.5D, 3D). Using DIVA users can easily understand connections between tables. It's compatible with: Oracle, MsSQL and MySQL. It can be used with other software for queries creation or with CASE systems. DIVA helps in: query building, DB structure analysis, DB showcase.
dotConnect for SQL Server is an enhanced database connectivity solution built over ADO.NET architecture. It offers complete solution for developing database-related applications and web sites. It interoperates with all essential development tools and technologies, including Visual Studio, SQL Server Business Intelligence Solutions, ASP.NET Provider Model, and Enterprise Library Data Access Application Block.
Entity Developer is a powerful LINQ to SQL modeling and code generation tool. You can design LINQ to SQL entity model from scratch or reverse-engineer an existing database, in which case you will have the classes and the relations with just several clicks. Entity Developer for SQL Server uses standard SqlClient and Microsoft LINQ to SQL built in .NET Framework 3.5.
Extract and export data from databases in a variety of formats automatically. FlySpeed Data Export provides direct access data export from numerous databases such as Oracle, MySQL, MS SQL Server, and supports PostgreSQL, Firebird, DB2, Sybase, Informix, dBASE and many other databases via ODBC or OLE DB.
Build SQL queries easier with a visual query builder. FlySpeed SQL Query allows new and professional database developers to build complex SQL queries in a simple graphical manner. Compatible with multiple types of databases, FlySpeed SQL Query can perform queries on different database servers and various platforms without requiring knowledge of SQL. Viewing and analyzing the results is also easy thanks to the ability to print the results and export data.
forSQL Data Generator is an automatic data generator for large scale database testing and Quality Assurance. It lets database developers and testers automatically generate test data to fill a database with logically correct and realistic test data. This saves countless hours and even days that would otherwise be wasted on entering and configuring the data manually.
Habanero is an object-relational mapping (ORM) architecture for .Net that maps object-oriented code to relational databases. It persists data to and from the database and generates user interfaces to edit the object's properties. Habanero can read class design from the database and generate code for the business objects to be mapped.
i-net MERLIA is a J2EE 1.3 certified type 4 JDBC driver for MS SQL Database Server. It implements the latest JDBC API level 3.0 / 4.0. i-net MERLIA is the only JDBC 3.0 / 4.0 driver supporting SSL security (protected by U.S. Patent)!
MS SQL Maestro is a powerful solution for the Microsoft SQL Server administration and development. Key features include: * support for Microsoft SQL Server 7.0 / 2000 / 2005 / 2008 versions; * easy database object management; * comfortable access to the server's security features; * database designer; * complete data management tools with viewing, editing, grouping, sorting and filtering abilities and BLOB viewer/editor; * handy SQL editor with code folding, syntax highlighting, SQL formatter and multi-threading; * visual query builder;
MS SQL PHP Generator is a freeware but powerful SQL Server GUI frontend that allows you to generate high-quality PHP scripts for the selected SQL Server tables, views and queries for the further working with these objects through the web.
Nevron Chart for SQL Server Reporting Services (SSRS) is an advanced report item, which delivers a complete set of 2D and 3D charting types, highly customizable axes, tight data integration and unmatched visual effects to your reports. It also instantly improves your report authoring experience, with its polished visual editors, exhaustive and refined settings and well-organized structure.
Nevron Gauge for SSRS is an advanced report item, which delivers a complete set of gauges, customizable axes, data integration and visual effects to your reports. It will also improve your report authoring experience, with its polished visual editors, refined settings and well-organized structure. Nevron Gauge for SSRS is a must-have tool for any advanced Business Intelligence, Scorecard, Presentation, Scientific or general purpose report.
ODS is an automatic database and DAL source code generation tool aimed at .NET Framework 2.0+ software developers who want a custom database and DAL to use with their application. Rather than using an existing database, ODS allows you to design the objects that you want to store. ODS then automatically designs both a database to store them in and generates a corresponding DAL.
Omega MSSQL allows you to connect to your SQL Server databases just by using a Web browser. It lets you explore your database objects, search for these objects (column names and procedure contents), document your database, create reports in multiple formats about your database, and execute SQL queries against your database just by using a browser based interface. Omega MSSQL supports SQL Server versions 2008, 2005, and 2000.
Telerik OpenAccess is an Enterprise-grade .Net ORM that does the data access plumbing in desktop and web applications. Supporting forward (model-first) and reverse (schema-first) mapping, the tool offers transparent persistence for your DAL and business objects. OpenAccess ORM provides tight Visual Studio integration and allows you to seamlessly create database independent code. Take full control of the mapping process and generated model with the powerful Visual Designer for OpenAccess ORM and the advanced features for code optimization and caching.
Qtest is an enterprise-class automated load testing and monitoring solution. It offers a high capacity for load simulation, extensive monitoring capability and is a new benchmark in affordability and ease of use. QTest supports all Web, Web Service, J2EE, .Net, ASP, AJAX, CGI, and Mainframe Portal environments and, in particular, complex Web applications like Siebel, SAP, and Epiphany. With its non-protocol based Winload module, QTest also supports any non web application. For added capabilities, the Qtest console includes Qmonitor, a non-intrusive performance monitoring module (also available as a standalone product) with automated anomaly detection. Qmonitor collects and displays in real time the correlated performance metrics from the network, application servers, Web servers and databases.
QweryBuilder is a database development and query tool. Its purpose is to make accessing information from a database simple, quick, accurate and efficient. QweryBuilder implements innovative ideas to make this possible. An end user can extract and update data without writing a line of SQL. Database developers can create procedures, tables, views and triggers with fewer keystrokes. Best of all, you can do this with your SQL Server, ASE, SQL Anywhere and Oracle databases in one single application.
Schema Detective is an innovative tool for finding sensitive data and referential relations within the database. Simple to use, yet powerful, it enables the detection of data across the entire database instance (server), utilizing various search patterns. In addition, it allows the identification of application referential relations - even in the lack of database foreign-keys.
SQL Compare Suite simplifies database development, maintenance, and hot-fixing. Its database version control makes it possible to MS SQL Server developers to compare and synchronize database structures between development and production systems without affecting existing data. The new SQL compare tool analyzes changes in the database structure, creates a hot-fix, and applies the changes on the production server while preserving data stored in the database. Compatible with Microsoft SQL Server 7.0, 2000, 2005, and 2008, SQL Compare Suite supports all types of objects supported by SQL Server.
SQL Data Examiner 2008 compares and synchronizes data of Microsoft SQL Server databases. It is an easy-to-use tool that makes any data migration process a simple operation. The tool handles the routine manual tasks itself and thus simplifies your work as a DBA or a developer. It saves you precious time and enables you to avoid tedious manual work. The tool provides support for all the main innovations introduced in MS SQL Server 2008, so now you can work with all SQL Server versions from 7.0 to 2008. It also supports Oracle and MS Access and allows a cross-platform comparison, when the databases you are comparing are stored in servers of different types.
SQL Digger is a very simple tsql search tool designed for Microsoft SQL Server. It enables you to search through all your SQL server database objects for any word in your TSQL statements.
SQL Enlight is an advanced code analysis, refactoring and productivity tool for Microsoft SQL Server. The tool is designed to facilitate and improve database development, administration, and maintenance. It can help development teams and database administrators to enforce common coding standards and best practices, identify problems early in the project lifecycle, implement automatic code reviews and improve their overall productivity. Using SQL Enlight analysis features, SQL Server developers and administrators can early find potential performance and design defects over SQL Server databases and T-SQL code.
Supporting SQL Server, MySQL and Oracle, SQL Examiner Suiteis the ultimate solution for SQL compare and synchronization of both data and schema in your databases. SQL Examiner Suite 2010 is a combination of two important and highly useful tools. These tools are SQL Examiner 2010 and SQL Data Examiner 2010. The tools run efficiently on any database supported. They also work with database creation scripts and SQL Server database backup files as well. Full automation of processes is also supported with the built-in command line comparison and synchronization feature. Source control systems including SourceSafe, Perforce, SVN and TFS are also supported which helps to keep databases under version control.
SQL Partition Manager provides you with a wizard-driven interface to partition tables in a large database and manage partitioned tables with ease. Partitioning lets you achieve optimal database performance without costly hardware upgrades. SQL Partition Manager also helps you to do some other operations, such as delete, split and merge partitions.
SQL Schema Sync API is extremely easy-to-use. The Intuitive visual tool allows the snapshotting of DB structure, and comparison of databases and their synchronization. The work of the visual tool in the wizard mode provides a user-friendly interface which allows quick saving of DB snapshots and synchronization. Thus, you save money on the licenses for your end users, staff training and obtain a powerful component with a set of advanced features. The SQL Schema Sync API allows you to compare database structures, to easily update them, use data refactoring and specify exact objects to be synchronized.
SQL Server Data Access Components (SDAC) is a VCL/VCL.NET/CLX component library for fast direct access to Microsoft SQL Server from Delphi and C++Builder. SDAC is heavily performance- and stress-tested to provide the fastest available native connectivity to SQL Server. SDAC features advanced local data handling, full support of all server data types, and comprehensive SQL Server functionality coverage, including MARS, bulk copy operations and reliable messaging.
SQL Sets allows you to quickly capture and organize snapshots of your SQL Server data into a single, self-contained file called a Portable Data Document. In conjunction with the free SQL Sets Reader, these files allow for easy sharing of and collaboration on relational data with team members and business partners, or simple saving and archiving for other purposes - with no need for a database connection or concerns about export formats.
SQL.CLR is designed to run inside SQL Server Management Studio as well as Microsoft Visual Studio. SQL.CLR allows for the following functionality: Generate CLR Stored Procedures, Generate CLR User Defined Functions, Custom class and project naming, Supports all CRUD operations, Compile Assemblies, Create Visual Studio Projects, Supports C# and VB.net
SQLWays is a database and application migration product capable of converting stored procedures, functions, triggers, database schema (DDL), data, SQL queries, scripts and applications. SQLWays guarantees migration process optimization to reduce your project costs. Support team offers individual comprehensive product customization in order to meet all your individual and specific requirements. SQLWays offers up to 100 percent automation of the entire migration process with reasonable pricing strategy.
Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database data access components for Delphi, Delphi for .NET, and C++Builder. We combined experience of long-term successful development into one great product, which provides unified access to popular databases such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, SQLite, InterBase, and Firebird.
ActiveX which Loads data into Oracle ,SQL Server, ODBC Databases from flat files, cross tables or ODBC datasources. Very fast and reliable. Uses naitive API (OCI API,BCP API,ODBC API) Capable of performing calculation during import, may also execute SQL statemts before and after import. Integrated expression builder, comprehensive error log, rejected records file.
Visual Importer loads data into any database from Text, Excel, MS Access, DBF files or any ODBC compliant database. It is easy to use and was designed especially for non-technical users. Very fast and reliable. Capable of performing calculation during import, may also execute SQL statements before and after import.
Visual Importer Enterprise automates the process of loading data into any database. It enables the user to design Import, Export and SQL scripts, add them to the package and schedule it for execution on regular basis. It stores all information in the repository. Supported repository types include MS Access (default repository), Oracle, MS SQL Server, Interbase, MySQL, and PostgreSQL. Typically Visual Importer Enterprise is used to download files from an FTP server, load them into the database, run stored procedure or SQL script and send email to the admin, once the package is completed.
Visual Importer Professional automates the process of loading data into any database. It enables the user to design Import, Export and SQL scripts, add them to the package and schedule it for execution on regular basis. All objects are stored in the repository. Supported repository types include MS Access (default repository), Oracle, MS SQL Server, Interbase, MySQL, and PostgreSQL.
Comprehensive, uniform, and easily navigable database documentation for all your applications. Generates documentation in HTML and CHM format; supports all major database management systems: SQL Server, Oracle, DB2, MySQL, Informix IDS, Sybase ASE, PostgreSQL, Access, VistaDB, ENEA Polyhedra; can run as a console application; documentation can be branded; supports XML comments added to your objects and a lot more.
xSQL Profiler is an easy to install, easy to use, agent-less SQL Server monitoring tool that can be utilized for performance, auditing and compliance related tasks. Its simple yet powerful interface allows the user to define custom events by combining low level SQL Server events and applying filters to get exactly what the user wants. The user can then define traces by selecting the events, the servers and/or databases to be monitored and applying additional filters to fine tune the results. The xSQL Profilers scheduling capability allow the user to schedule the traces to run at certain intervals every day, every week or every month on all the selected servers. Finally, xSQL Profilers automatically collects the trace data into a central repository and provides a flexible reporting interface that allows the user to quickly zero in on the data of interest.