Database Reference
In-Depth Information
The official representation of DAC is represented by Microsoft as follows:
For the ease of understanding the Production deployment and Development extract process,
it is represented with numbers—P1 for production and D1 for Development.
The build process of the DAC package can be accomplished using Data-Tier application
project system in Visual Studio application. The data management process of the DAC
package can be accomplished by using SQL Server Management Studio (SSMS).The DAC
deployment installs a new database on the instance, creates the database objects, and
creates the logins associated with the users of the database. If a previous version of the DAC
is already available, then the DAC package can be used to upgrade the existing DAC instance
to a newer version.
The following are few of the best practice items provided for DAC package deployment and
extraction that are directed for Independent Software Vendors (ISV) and Internet (Web
hosting) Service Providers (ISP):
F The database should contain up to a few gigabytes of data (for example, up
to 10 GB).
F There are certain limitations and support restrictions for data-tier applications, such
as the common database objects. They are:
Objects marked for deprecation, including defaults, rules, and numbered
stored procedures
Search WWH ::




Custom Search