SQL Server 2012 Support

SQL Server 2012 Support

Aqua Data Studio 11.0 now supports SQL Server 2012 designed by Microsoft, a high performance analytic database with cloud-ready information platform. With Aqua Data Studio version 11.0, you can register  a SQL Server 2012 Server and use the different features available such as Query Analyzer Window, Visual Editors, Table Data Editor, Import/ Export Tools, ER Modeler and Schema Script Generator. DBA Tools, Visual Editing tools to manage the SQL Server 2012 Users and Groups as well as Create Databases,  Schemas, Tables, Views and Functions are also available.

Native support has been added for SQL Server 2012

Vendor: Microsoft
Website: http://www.microsoft.com/sqlserver/en/us/future-editions.aspx
Database Product: SQL Server 2012
Description: SQL Server 2012 is a cloud-ready information platform to build solutions and extend data across on-premises and public cloud backed by mission critical confidence.

CREATE Sequence	Snapshots Node	Script Generator Linked & Remote Servers	CREATE User	CREATE Server Role
Server Triggers	CREATE Database

The major enhancement for SQL Server 2012 in Aqua Data Studio 11.0 is the way in which database objects are scripted. Instead of scripting objects using the system procedures and functions we have strictly followed the available DDL which supports Create, Alter and Drop.

Create Database GUI in Aqua Data Studio 11.0 has been modified to support the following create database properties:

     CONTAINMENT
     DEFAULT_FULLTEXT_LANGUAGE
     DEFAULT_LANGUAGE
     TWO_DIGIT_YEAR_CUTOFF
     NESTED_TRIGGERS
     TRANSFORM_NOISE_WORDS
     FILESTREAM NON_TRANSACTED_ACCESS
     FILESTREAM DIRECTORY_NAME
     CROSS DATBASE OWNERSHIP CHAINING
     TRUSTWORTHY

Create Table extraction and scripting now supports FileTable option. The sampe DDL for a file table generated in SQL Server 2012:

     CREATE TABLE
          [ AS FileTable ]
          [ WITH ( <table_option> [ ,...n ] ) ]
 
          <table_option> ::=
            {
               [DATA_COMPRESSION = { NONE | ROW | PAGE }
               [ ON PARTITIONS ( { <partition_number_expression> | <range> }
               [ , ...n ] ) ]]
               [ FILETABLE_DIRECTORY = <directory_name> ]
               [ FILETABLE_COLLATE_FILENAME = { <collation_name> | database_default } ]
             }

Create Sequence is now supported in Aqua Data Studio 11.0. Sequences have been requested by the SQL Server community for years, and it's included in this release. Sequence is a user defined object that generates a sequence of a number.
     Here is an example sequence generated using the GUI in Aqua Data Studio v 11 for SQL Server 2012

    CREATE SEQUENCE [dbo].[ID_Generated_Sequence]
       AS int
       START WITH 1
       INCREMENT BY 1
       MINVALUE 1
       MAXVALUE 10000
       CYCLE
   GO

SQL Server 2012 now has a Snapshot Database node which is featured in the Server Tree in Aqua Data Studio.

In SQL Server 2012, there is a new feature called Contained Databases, which intends to reduce or eliminate the dependencies that a database has on the SQL Server instance, making it easier to migrate a database to a new instance with less of the work involved in reproducing and validating these dependencies. Contained Databases has the ability to define a user with a password at the database level (a “contained database user”). By authenticating at the database level, you can move the database to a  new server, and applications can change their connection string without having to create new SQL Server logins – a common problem we see today is orphaned users and/or mismatched security identifiers (SIDs).

Aqua Data Studio v 11.0 displays the user created Contained Databases in the Server Tree node.

Create User GUI has new options supported - Certificate, Asymmetric Key, Default Language and Default Schema can now be specified.

Create Server Role GUI is now supported in Aqua Data Studio 11.0 for SQL Server 2012.

The latest version of Aqua Data Server now supports displaying and scripting of Server Triggers.

Script Generator is now enhanced with scripting of Linked Servers, Remote Servers and Server roles.

Features supported in SQL Server 2012

• DBA Tools - Instance Manager, Storage Manager, Security Manager, Session Manager and SQL Server Agent.
• Query Analyzer - Connect to SQL Server 2012 and execute SQL Queries. Auto Completion, Syntax Coloring, Grid, Pivot Grid Results and Charting toolkit.
• Visual Editing GUI - Create Database, Create Schema, Create Table, Create View, Create Function.
• Table Data Editor - Excel like editor of data in tables and query results.
• Import Tool - Import delimited data files, SQL scripts or INSERT statements to database tables.
• Export Tool - Export table data as delimited data, Excel Worksheets or SQL Script of INSERT statements.
• Schema Script Generator - Script a complete database to file, including CREATE, DROP DDL and INSERT DML.
• Server Script Generator - Allows a user to generate SQL scripts for server objects such as users and roles.
• ER Modeler - Fully functional entity relationship modeler.
• Schema Compare Tool - Allows comparison of Schema Objects and Databases, including functions, packages and more.
• Results Compare Tool - Allows comparison of SQL Query results.
• Object Search Tool - Assists in finding Schema and Database Objects within a Database Server.
• Visual Query Builder - Visually design queries.
• Schema Browser, DDL Scripting, Visual Editing - Tables, Views, Indexes, Users and Roles.
• SQL History/Archive - Provides a history of all SQL statements and scripts that have been executed within the Query Analyzer, Query Builder and Table Data Editor.
• SQL Server Debugger  -The MS SQL Server Debugger has been designed to help with testing and debugging of SQL functions and procedures for MS SQL Server 2005 and above.