Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 deploy dacpac  [new]
deniskodua
Member

Откуда:
Сообщений: 61
В VS2010 создан dbproj, первый деплой БД проходит нормально, но не удаляя базу при повторном деплое возникают
ошибки. (Все таблицы, хранимки, триггеры в базе имеются)

------ Build started: Project: CCWP_DB, Configuration: Debug Any CPU ------
CCWP_DB -> C:\ccwp_dac\CCWP_DB.dacpac
------ Deploy started: Project: CCWP_DB, Configuration: Debug Any CPU ------

Pre-Deploy: Starting script execution…

Pre-Deploy: Finished script execution.

CCWP_DB.dacpac(0,0): Error :
-->Unable to upgrade DacInstance. Please see the inner exception for more details.
-->The requested operation cannot proceed because the database CCWP contains these unsupported objects or missing dependencies:
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[AfterStepsQuestions_log] (UnresolvedEntity)', which does not exist in this database.
Depends on object '[dbo].[ApprovalSchemeStage] (Table)', which is not supported.
Depends on object '[logs].[TU_ApprovalScheme_log] (UnresolvedEntity)', which does not exist in this database.
Depends on object '[dbo].[ApprovalScheme] (Table)', which is not supported.
Depends on object '[dbo].[Users] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[Users] (Table)', which is not supported.
Depends on object '[dbo].[AuditEvents] (Table)', which is not supported.
Depends on object '[dbo].[AuditEvents] (Table)', which is not supported.
Depends on object '[dbo].[AuditEventParams] (Table)', which is not supported.
Depends on object '[dbo].[Users] (Table)', which is not supported.
Depends on object '[dbo].[OrgStructure] (Table)', which is not supported.
Depends on object '[logs].[ClaimToSocialCategory_log] (UnresolvedEntity)', which does not exist in this database.
Depends on object '[dbo].[OrgStructure] (Table)', which is not supported.
Depends on object '[dbo].[Claims] (Table)', which is not supported.
Depends on object '[dbo].[Claims] (Table)', which is not supported.
Depends on object '[dbo].[Claims] (Table)', which is not supported.
Depends on object '[dbo].[OrgStructure] (Table)', which is not supported.
Depends on object '[dbo].[Claims] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[CoverLetters] (Table)', which is not supported.
Depends on object '[dbo].[CoverLetters] (Table)', which is not supported.
Depends on object '[dbo].[ClaimsToCitizens] (Table)', which is not supported.
Depends on object '[dbo].[ClaimsToCitizens] (Table)', which is not supported.
Depends on object '[dbo].[Users] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[ClaimToReportCategoryLink] (Table)', which is not supported.
Depends on object '[dbo].[CurrentMonthClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentMonthClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentMonthClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentMonthClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentMonthClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentMonthClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentYearClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentYearClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentYearClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentYearClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentYearClaims] (View)', which is not supported.
Depends on object '[dbo].[CurrentYearClaims] (View)', which is not supported.
Depends on object '[dbo].[Claims] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[ApprovalScheme] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[Claims] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[Users] (Table)', which is not supported.
Depends on object '[dbo].[RegCards] (Table)', which is not supported.
Depends on object '[dbo].[AfterStepsQuestions] (Table)', which is not supported.
Depends on object '[dbo].[OrgStructure] (Table)', which is not supported.
Depends on object '[dbo].[Users] (Table)', which is not supported..

Done executing task "DacDeployTask" -- FAILED.
Done building target "DspDeploy" in project "CCWP_DB.dbproj" -- FAILED.
Done executing task "CallTarget" -- FAILED.
Done building target "DBDeploy" in project "CCWP_DB.dbproj" -- FAILED.
Done building project "CCWP_DB.dbproj" -- FAILED.

Build FAILED.
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========
23 май 12, 13:47    [12600936]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить