Database Reference
In-Depth Information
CLR objects and data types (such as Spatial, Geography, Geometry, Hierarchy
ID data types, SQL assemblies, CLR stored procedures, and functions)
User-defined aggregates and user-defined CLR types
Partition schemes and partition functions
XML schema collections, XML indexes, and spatial indexes
Service broker objects
FileStream columns
Symmetric keys, asymmetric keys, and certificates
DDL triggers
Application roles
Full-text catalog objects
Extended stored procedures
Encrypted objects (for example, encrypted stored procedures, views,
functions, and triggers)
Objects containing cross-database dependencies and linked server
references
Extended properties
Linked Servers
Synonyms
F The Data-Tier Application is wrapped with schema and metadata.
The schema consists of tables, views, constraints, stored procedures, users,
logins, and file group
The metadata consists of management policies and failover policies that
map a database having a direct relationship with the relevant . dacpac
definition file
F There are no specific hardware or software requirements for data-tier applications.
However, to manage the data-tier applications through the SQL Server Utility, users
must consider the limitations imposed by the utility and managed instances.
F Though the data-tier applications can be used to work with existing databases,
or implement them as new releases, we need to know how to create data-tier
applications in existing systems to register each database as a data-tier application.
 
Search WWH ::




Custom Search