ApexSQL Universal 20170222 » Developer.Team

ApexSQL Universal 20170222

ApexSQL Universal 20170222
ApexSQL Universal 20170222 | 538 Mb


85 meaningful predefined data generators. Meaningful distribution across columns by default. Generate data in one column based on the data in another. Inter-column dependency support. Choose the file containing the value list. Set the percentage of each value being used in result. Create, save and use custom user-defined generators. Share user defined generators by setting the share folder. Populate rows based on percentage of other table's row count. Populate rows by setting the execution time. Disabling DELETE triggers. View the action plan before starting generation. GUI warnings. Command Line Interface full support. Choose additional script to be executed before generation. Choose additional script to be executed after generation. View the database table creation script. Sentence generator. Text shuffler. Lorem ipsum generator. Import values from SQL view. Include dependent database objects. Post-generation summary. SQL Server 2016 CTP2 support. SQL Server Management Studio integration. Usability improvements. Improved quality.

Working folder as a repository for both database development models. Check in/Commit individual object changes through Object Explorer. Exclude/Include single object from/to source control through Object Explorer. Ability to filter objects that are only on source control repository. Improved usability when working with static data. Possibility to add directory to repository root for Git and Mercurial source control systems. Usability improvements. Improved quality.

The built-in Query execution plan viewer. Reporting. Ability to define users and their privileges. AlwaysOn Availability Groups performance metrics and the dashboard. Improved performance. Usability improvements. Improved quality.

Parenthesis placement option for Arithmetic operation, Comparison operation, Logical operation, and Column list. Data types alignment option. CamelCase capitalization option. BEGIN and END blocks indent options. Place JOIN keyword in new line option. Insert empty line before each statement option. Align SELECT with INSERT option. New formatting profiles: Compact, Extended, MSDN SQL BOL. Usability improvements. Improved quality.

Comparison options: Ignore computed column, Treat empty strings as null, Ignore underscores in names, Round floating types. Synchronization option: Drop unique indexes. Re-enable constraints with CHECK synchronization option. Find feature for the Data difference pane. Data comparison results included in HTML reports. Microsoft Office Excel XML export format. Improved help output for the CLI. Integration with ApexSQL Diff. Usability improvements. Improved quality.

Support for Azure SQL database V12. Unlimited data generation. It has the ability to instantly populate an entire database at once, or to fill each column separately with the use of its built-in generators. Live preview of generated data. Exporting to SQL, CSV, and XML files. Customizable filtering options. Top-down level settings for database, tables, and columns.

Support for Mercurial source control system. Support for Azure SQL Database V12. Comparison options: Ignore change tracking, Ignore database properties, Ignore authorization, Ignore database and server name in synonyms, Ignore WITH NOCHECK, and Ignore next filegroups in SQL partition scheme. Ability to compare database properties (extended properties, etc.). Synchronization option: Use DROP/CREATE instead of ALTER for tables. Improved help output for the CLI. Integration with ApexSQL Data Diff.

Support for Perforce. Support for Git and Mercurial source control systems, communication with source control repository using the Action center tab, edit objects from SQL Server Management Studio, "Work offline" feature (Shared development database model). The "Multiselect" feature is added in the Action center tab. Prevent objects from being edited if locked\checked out. View detailed history of the source control project including commit information, changeset and individual object differences. Development policies. Exclude objects from monitoring by type, schema and name. Logging of changes made to the database schema. Improved quality.

Set of SQL tools including

ApexSQL Comply // Fault tolerant auditing, centralized storage and reporting
ApexSQL Log // Audit, undo or replay SQL database changes
ApexSQL Monitor // Monitor and view system performance metrics
ApexSQL Recover // Recover deleted, dropped, corrupted or lost data
ApexSQL Restore // Work with backups just like with live databases
ApexSQL Audit // Track data changes to SQL databases
ApexSQL Build // Build, update and deploy SQL databases
ApexSQL Clean // Analyze dependencies and remove unused objects
ApexSQL Data Diff Pro // Compare and synchronize SQL database data
ApexSQL Diff Pro // Compare and synchronize SQL database objects
ApexSQL Doc // Document SQL instances, databases and SSIS packages
ApexSQL Script // Script and package SQL databases
ApexSQL Complete // Auto-complete and coding productivity features
ApexSQL Refactor // Format and refactor SQL code
ApexSQL Search // Search SQL objects and data and visualize dependencies
ApexSQL Version // Database version control integration

Only for V.I.P
Warning! You are not allowed to view this text.