About ApexSQL Developer

Suite of SQL Developer Tools for comparison/sync, scripting, auditing, Documentation.

ApexSQL Developer includes all of ApexSQL's SQL developer tools including ApexSQL Analyze, ApexSQL Build, ApexSQL Compare, ApexSQL Complete, ApexSQL Data Diff, ApexSQL Decrypt, ApexSQL DevOps toolkit, ApexSQL Diff, ApexSQL Doc, ApexSQL Enforce, ApexSQL Generate, ApexSQL Mask, ApexSQL Model, ApexSQL Pump, ApexSQL Refactor, ApexSQL Script, ApexSQL Search, ApexSQL Source Control, ApexSQL Trigger and ApexSQL Unit Test. All tools in ApexSQL Developer Studio are licensed per Developer making it easy to procure a license of ApexSQL Developer for each member of your SQL Developer team.

Benefits of ApexSQL Developer

  • All ApexSQL developer tools
  • 1 year priority product support
  • A combined 75% savings
  • 1 year free product upgrades
  • Product support for free tools
  • All new developer tools added for free

Products included with ApexSQL Developer Studio

  • ApexSQL Build
    • Run scripts on multiple databases at once
    • Create C# executables / .NET deployment packages
    • Deploy databases directly from SQL source control
    • Consolidate multiple SQL scripts
    • Build databases from scripts, source control, etc
    • Ensure error free deployments
    • Preview the script impact by action or SQL object
    • Execute scripts on saved list of servers/databases
  • ApexSQL Clean
    • View and analyze SQL and client code dependencies
    • Perform impact analysis on potential changes
    • Remove unwanted objects risk free
    • Map dependencies down to the column level
    • Analyze external databases for dependencies
    • View object dependencies graphically
    • Design the appearance of the dependency diagram
    • Create and export reports from object dependencies
  • ApexSQL Complete
    • Automatically complete SQL statements
    • Review an object's script and description
    • Improve productivity with snippets
    • Identify the structure of complex SQL queries
    • Keep track of all your tabs
    • Log every executed query
    • Easily navigate to SQL objects
    • Check queries in test mode
  • ApexSQL Data Diff Professional
    • Compare data in live databases and backups
    • Perform row level recovery without restoring
    • Community, Standard, and Professional editions
    • Compare huge databases quickly and without errors
    • Automate and schedule data migrations
    • Initiate database compares directly from SSMS
    • Export results to HTML, XML and Excel
    • Create executable .NET packages
  • ApexSQL Decrypt
    • Decrypt SQL procedures, functions, triggers and views
    • Initiate decryption directly from SSMS
    • Decrypt objects with a single click
    • Filter encrypted objects
    • View original DDL script
    • Export encrypted objects into a SQL script
    • Decrypt databases from multiple servers
    • Decrypt wizard with built-in IDE
  • ApexSQL Diff Professional
    • Compare live DBs, backups, scripts and SC projects
    • Deploy a database directly from source control
    • Community, Standard, and Professional editions
    • Integrate with all popular SC systems e.g. Git, SVN
    • Automate and schedule database synchronizations
    • Initiate database compares directly from SSMS
    • Report results to HTML, XML and Excel
    • Create executable .NET packages
  • ApexSQL Doc Professional
    • Document SQL Server databases and SSIS packages
    • Generate documentation in CHM, HTML, Word, and PDF
    • Automate and schedule the documenting process
    • Display graphical relationship diagrams
    • Document SSAS Multidimensional and Tabular models
    • Document SSIS Control flow and Data flow diagrams
    • Fully customize the documentation output
    • Include Data model diagrams
  • ApexSQL Generate
    • Generate SQL test data for specified tables
    • Export test data to SQL, XML, CSV, JSON, Excel
    • Generate millions of rows quickly
    • Customize test data plan with detailed options
    • Support a full range of SQL data types
    • Choose from multiple generators (Random, List, etc)
    • Retain data consistency with foreign key support
    • Emulate real-world test data
  • ApexSQL Mask
    • Automate sensitive data classification
    • Create and edit data classification filters
    • Mask data at column and/or row level
    • Choose from substitution or redaction masks
    • View full database masking job summary
    • Visualize database-level data masking profile
    • View before-and-after masked data
    • Sensitive data masking
    • Create and edit sensitive data masks
    • Leverage 220+ pre-defined data masks
    • Import and export masks and filters
    • Utilize 55+ built in data classification filters
  • ApexSQL Refactor
    • SQL formatter with over 160 options
    • Qualify objects and expand wildcards
    • Encapsulate SQL into procedures
    • Add surrogate keys
    • Replace one-to-many relationships
    • Change procedure parameters
    • Safely rename SQL objects
    • Locate & highlight unused variables
    • Format SQL objects
    • Obfuscation
  • ApexSQL Script Professional
    • Script both SQL database objects and data
    • Create executable .NET packages
    • Script objects directly to Source Control
    • Automate SQL database scripting and migrations
    • Integrate with popular source control systems
    • Script an entire server down to individual columns
    • Save customized scripting profiles as projects
    • Easily decrypt some/all encrypted database objects
  • ApexSQL Search
    • Search for SQL objects
    • Quickly find data in SQL tables
    • Visualize relationships between objects
    • Edit extended properties
    • Easily navigate to result objects
    • Rename SQL objects safely
  • ApexSQL Source Control
    • Integrate SQL source control directly into SSMS
    • Use dedicated or shared development models
    • View conflicts and resolve directly in the UI
    • View a detailed history of changes
    • Lock objects to prevent overwrites
    • Set team policies for check outs and locks
    • Apply changes with dependency aware scripts
    • Create and apply label from source control
  • ApexSQL Trigger
    • Track data / DML changes in SQL Server databases
    • Integrate royalty free auditing into your apps
    • Translate data into information with lookups
    • Create reports and exports from audited data
    • Customize trigger templates with a built-in IDE
    • Add additional data to audit trail with watches
    • Track schema / DDL changes in audited database
    • Audit who, what, and when for all changes
  • ApexSQL Unit Test
    • Integrate SQL unit testing directly into SSMS
    • Install and manage tSQLt from multiple sources
    • Create and organize test classes
    • Automate test execution using the CLI
    • Create and organize unit tests
    • Write tests using T-SQL
    • Run tests with a single click
    • Manage all tests with a single form