SQL Server 2012 Support (Revision #56)

SQL Server 2012 Support

Aqua Data Studio 11.0 now supports SQL Server 2012, a high performance analytic database, designed by SQL Server 2012 from the ground up for speed. SQL Server 2012 has an extensible framework that imbeds 502 analytic functions and supports on-demand integration of a variety of data and analytic results, right at the point of execution. 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, Schema Script Generator and FluidShell. 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. Here is the DDL for a table generated using the Aqua Data Studio v 11 for 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

• 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.
• FluidShell - Connect to SQL Server 2012 and execute SQL Queries as well as Shell commands.
• 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.