de ApexSQL
ApexSQL Developer Studio (Lite) by ApexSQL
Suite of SQL Developer Tools for comparison/sync, scripting, auditing and documentation. ApexSQL Developer Studio Lite includes tools for database comparison and synchronization, scripting, auditing, documentation, Dependency Analysis and Code Generation. These tools all provide specific features that SQL Developers use on a frequent basis. All ApexSQL Developer Studio Lite tools are included in a single download and installation. All tools in ApexSQL Developer Studio Lite are licensed per Developer making it easy to procure a license of ApexSQL Developer Studio for each member of your SQL Developer team.
The tools in ApexSQL Developer Studio Lite 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 - A 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 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 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 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.
PartNumbers: PC-518254-147885 518254-147885 PC-518254-147887 518254-147887 PC-518254-147889 518254-147889 PC-518254-147891 518254-147891 PC-518254-147892 518254-147892 PC-518254-147921 518254-147921 PC-518254-147894 518254-147894 PC-518254-147896 518254-147896 PC-518254-147898 518254-147898 PC-518254-147900 518254-147900 PC-518254-147901 518254-147901 PC-518254-147922 518254-147922 PC-518254-147903 518254-147903 PC-518254-147905 518254-147905 PC-518254-147907 518254-147907 PC-518254-147909 518254-147909 PC-518254-147910 518254-147910 PC-518254-147923 518254-147923 PC-518254-147912 518254-147912 PC-518254-147914 518254-147914 PC-518254-147916 518254-147916 PC-518254-147918 518254-147918 PC-518254-147919 518254-147919 PC-518254-147924 518254-147924
Publisher PartNumbers: 300235435 300235436 300235437
PurchaseOptions: ApexSQL Developer Studio (Lite) without Support 1 Developer License , ApexSQL Developer Studio (Lite) without Support 1 Developer License per license from 3 to 4 Licenses , ApexSQL Developer Studio (Lite) without Support 1 Developer License per license from 5 to 9 Licenses , ApexSQL Developer Studio (Lite) without Support 1 Developer License per license from 10 to 15 Licenses , ApexSQL Developer Studio (Lite) without Support 1 Developer License per license from 16 Licenses , ApexSQL Developer Studio (Lite) without Support 1 Site License (Allows Unlimited Developers at a Single Physical Address) , ApexSQL Developer Studio (Lite) with 1 yr Support & Upgrades 1 Developer License , ApexSQL Developer Studio (Lite) with 1 yr Support & Upgrades 1 Developer License per license from 3 to 4 Licenses , ApexSQL Developer Studio (Lite) with 1 yr Support & Upgrades 1 Developer License per license from 5 to 9 Licenses , ApexSQL Developer Studio (Lite) with 1 yr Support & Upgrades 1 Developer License per license from 10 to 15 Licenses , ApexSQL Developer Studio (Lite) with 1 yr Support & Upgrades 1 Developer License per license from 16 Licenses , ApexSQL Developer Studio (Lite) with 1 yr Support & Upgrades 1 Site License (Allows Unlimited Developers at a Single Physical Address) , ApexSQL Developer Studio (Lite) with 2 yr Support & Upgrades 1 Developer License , ApexSQL Developer Studio (Lite) with 2 yr Support & Upgrades 1 Developer License per license from 3 to 4 Licenses , ApexSQL Developer Studio (Lite) with 2 yr Support & Upgrades 1 Developer License per license from 5 to 9 Licenses , ApexSQL Developer Studio (Lite) with 2 yr Support & Upgrades 1 Developer License per license from 10 to 15 Licenses , ApexSQL Developer Studio (Lite) with 2 yr Support & Upgrades 1 Developer License per license from 16 Licenses , ApexSQL Developer Studio (Lite) with 2 yr Support & Upgrades 1 Site License (Allows Unlimited Developers at a Single Physical Address) , ApexSQL Developer Studio (Lite) with 3 yr Support & Upgrades 1 Developer License , ApexSQL Developer Studio (Lite) with 3 yr Support & Upgrades 1 Developer License per license from 3 to 4 Licenses , ApexSQL Developer Studio (Lite) with 3 yr Support & Upgrades 1 Developer License per license from 5 to 9 Licenses , ApexSQL Developer Studio (Lite) with 3 yr Support & Upgrades 1 Developer License per license from 10 to 15 Licenses , ApexSQL Developer Studio (Lite) with 3 yr Support & Upgrades 1 Developer License per license from 16 Licenses , ApexSQL Developer Studio (Lite) with 3 yr Support & Upgrades 1 Site License (Allows Unlimited Developers at a Single Physical Address)
Resources: Read the ApexSQL Audit help file, Read the ApexSQL Clean help file, Read the ApexSQL Code help file, Read the ApexSQL Code Object Model help file, Read the ApexSQL Diff help file, Read the Compare It! help file, Read the ApexSQL Doc help file, Read the ApexSQL Doc Datasheet, Read the ApexSQL Script help file, Read the ApexSQL End User License Agreement, Download the ApexSQL Developer Studio Lite evaluation on to your computer - Expires after 30 days
Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000
Architecture of Product: 32Bit
Compatible Containers: Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft SQL Server 7.0
Keywords: ApexSQL Apex SQL Database DB Reporting Report reports SQL query language Product Suites Suite bundles bundle Database DB Management Professional Partner ApexSQL Developer Studio (Lite)