ApexSQL Universal Studio - Application

概要 | 価格及びライセンス | 試用版とそのダウンロード | 互換性 | 開発元詳細 | 結果

この商品については、日本語の説明書きはございません。
A complete package of SQL Tools with 1 year Free Maintenance and all New Products for a Year. ApexSQL Universal Studio is a suite of SQL Tools and includes tools for Editing/IDE, to comparison/sync, scripting, auditing (both Passive and Active), Reporting, Documentation, Dependency Analysis, Code Generation and more. All of the tools work on both SQL Server 2000 and 2005. ApexSQL Universal Studio includes a full years Support and Major Upgrades for free.

一般向け価格については下記に表示されています。お客様用の割引価格をご覧になるには、ログインしてください。

ApexSQL Universal Studio with 1 yr Support & Upgrades

ApexSQL Universal Studio with 2 yr Support & Upgrades

ApexSQL Universal Studio with 3 yr Support & Upgrades

ApexSQL Universal Studio Renewals

すべてのご注文にて弊社標準の 契約条件および返品条件の内容が適用されます。 

一般向け価格については上記に表示されています。お客様用の割引価格をご覧になるには、ログインしてください。

The tools in ApexSQL Universal Studio include :

• ApexSQL Audit - Active data auditing for SQL Server. Includes multiple modules for reporting, data management, trigger management and more
• ApexSQL Clean - Search and Destroy for unreferenced SQL Objects in both the database and client code. Includes visual dependency viewer.
• ApexSQL Code - the ultimate code generation tool, perfectly streamlined for SQL Server Database developers
• ApexSQL Diff - Compare and Synchronize Databases. Includes Command Line Interface
• ApexSQL Doc - Database documentation (.chm and .html)
• ApexSQL Edit - the Ultimate Editor/IDE for SQL Server. Includes snippets, object browser, intelliprompt and more.
• ApexSQL Log - A general purpose log auditing (trigger free) and recovery tool. Supports SQL 2005.
• ApexSQL Report - Instantly convert your Stored Procedure Data Access Layer into HTML Reports and Graphs
• ApexSQL Script - Convert Database Structures and Data into scripts, exe's, packages etc for versioning, deployment and more

More information about each tool can be found below and on the individual product pages on this site.

ApexSQL Audit

Add instant audit trails to any SQL Database

• Track Inserts, Updates, Deletes by user, machine, date, application and more integrating the logic directly into your application
• Fully customizable and extensible architecture. Change trigger templates rom directly within the built in IDE, modify architectures (fast reporting, distributed audit log tables, etc
• Reporting module as well as exports to Excel, CSV.
• Per Client licensing - audit unlimited servers.

Whether you are relatively new to SQL Server and just need an easy to use utility or you are an advanced user who is comfortable creating your own Audit architecture from scratch - ApexSQL Audit is a great SQL Server auditing solution.

ApexSQL Clean

Risk free delete, Impact Analysis and Graphical Dependency Viewer for SQL Server

• Ever wonder how many objects in your database were really referenced/used by other database objects or client applications?
• Want to view database dependencies visually even across databases and servers and/or export to xml/html for additional analysis
• Are you interested in column level dependencies for pre-impact analysis?
• Concerned about the unreliability of native sql server dependency tracking (i.e. sysdepends table still unfixed in SQL 2005)?

ApexSQL Clean looks for unreferenced and unused database objects like tables and procedures and displays all relationship in a graphical, dependency viewer, using a proprietary dependency viewer that doesn't rely on SQL Server sysdepends table. Dynamically browse your object dependencies using visual components like Overview and Hierarchical Dependency Treeview. Print and/or save your target diagram in a variety of graphical formats.

ApexSQL Code

Increase productivity - Reduce Errors - Standardize your Code Base - Automate repetitive coding tasks with Template Based Code Generation

• Do you spend a lot of time manually writing Data Access Layer code, stored procedures or even forms for CrUD (Create, Update Delete)?
• Have you ever "fat fingered" names of parameters, datatypes or made other common errors in blocks of rote, repetitive code leading to annoying errors?
• Would you rather spend time designing software than typing code?
• Would you like to ensure you code base is more standardized with each class and function written the exact same way?

ApexSQL Code is a Rapid Application Development (RAD) Code Generation tool, streamlined specifically for Microsoft SQL Server, that enables you to automatically generate thousands of lines of perfect C#, VB.NET, ASP.NET, SQL (and more) in just seconds solving these problems and making good coders even better.

ApexSQL Diff

Compare your SQL Databases in seconds - including both Data and Structure.

• Automate Database comparisons with a Command Line Interface
• Synchronize your database
• Integrate seamlessly into your build process

ApexSQL Diff is a sophisticated database comparison tool that will analyze the differences in tables, procedures, views, users etc. between two SQL Server databases.

ApexSQL Diff implements a state of the Art solution to the most complex database comparison scenarios including many unique features like Diff codes, RegEx object filters, Project Wizards and much more.

ApexSQL Doc

Comprehensive and richly detailed Database documentation

• Document multiple databases at once but still be able to include or exclude individual objects
• Extensive Command Line Interface
• Include Dependency diagrams in your documentation
• Custom tags, embedded customizable, text blocks and literally scores of customizable options
• Support for both HTML and CHM output
• VS2005 style, Collapsible regions and HTML 2.0 (hxs) support

ApexSQL Doc is a tool to document your SQL Server Database into Compiled Help or HTML documentation. ApexSQL Doc offers extensive, comprehensive and thoroughly detailed SQL Database Documentation products.

ApexSQL Edit

Improve your productivity with an SQL IDE designed by SQL Developers!

ApexSQL Edit is an IDE especially designed for advanced SQL Server developers including integration with source control, Intelliprompt, sql formatting, data editing and advanced features not found in other SQL IDEs like procedure/column Intelliprompt, Collapsing Regions, Snippet Editors and more.

ApexSQL Edit has been modified to provide many new features, including support for Microsoft SQL Server 2005, centralized mapping, Object Explorer, code snippets, object notes, context sensitive options while editing such as What Is.

Scripts can now be run in "Test mode" which will automatically roll back scripts immediately after execution.

ApexSQL Log

Audit SQL Server and Recover Lost Data in one incredibly versatile tool!

• ApexSQL Log is a Microsoft SQL Server log auditing and recovery tool that analyzes SQL Server's own transaction log to display information on data changes, including user (nt user), computer and application where the change originated
• Since ApexSQL Log reads the transaction log, no database overhead or the use of database triggers is required, and audits can be done on changes made even before the tool was installed
• Ooops - wish you could UNDO that Update statement without a where clause? ApexSQL Log is a recovery option for SQL Server 2005. ApexSQL has helped customers recover single statements to 350 GB databases. No backups required
• 64 bit support

ApexSQL Log has the ability to read online logs, detached logs and log backups. It allows users to recover dropped/truncated tables, tracks individual row history, and can generate UNDO and REDO scripts on the fly. Log also features filtering abilities to help users locate and isolate specific transactions quickly and easily.

ApexSQL Report

Add reporting to your database in minutes with no HTML Coding, SQL Reporting Services etc.

Apex SQL Report is a data driven, web reporting solution for Microsoft SQL Server. Imagine the ability to leverage off an existing database and begin offering your users literally hundreds of web-based, HTML reports in a few minutes rather than weeks or even months.

Apex SQL Report is the first and only reporting solution designed specifically for SQL database developers.

If you have a SQL Server database you can be generating sophisticated HTML reports, graphs and Microsoft Excel spreadsheets without complicated server component installations, steep learning curves or expensive software. Apex SQL Report works with your existing stored procedure base to extend their output directly to your user's desktops.

ApexSQL Script

Process SQL Server Data and Objects into T-SQL Scripts, Executables and Deployment Packages

• Apex SQL Script is a SQL tool that converts Databases into scripts, .net EXE's, deployment packages or into source control
• Scripts are ordered based on proprietary dependency algorithms to ensure proper order of generated scripts
• Scripts can be created from Databases or Source control labels (all SCC compliant source control systems are supported)
• Includes Command Line Interface

ApexSQL Script allows a rich array of value added scripting attributes to embed customizable text, tags, dates, comments etc into your scripts to transform your output into a richly tailored output, that comes in a variety of formats.

サポート

What support options are available?
ApexSQL take support seriously they offer support via their Support Forums as well as Phone Support for customers who have purchased a Maintenance Contract for Support and Upgrades.