Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "E:TestDeploymentTest.proj" (UpgradeDatabase target) (1) ->(dbDeploy target) ->
- E:TestDeploymentTest.proj(212,5): error : Unexpected System.IO.FileNotFoundException
- error executing SQL command: -- BEGINNING TRANSACTIONr
- E:TestDeploymentTest.proj(212,5): error : PRINT 'Beginning transaction'r
- E:TestDeploymentTest.proj(212,5): error : BEGIN TRANSACTION r
- E:TestDeploymentTest.proj(212,5): error : GOr
- E:TestDeploymentTest.proj(212,5): error : r
- E:TestDeploymentTest.proj(212,5): error : -- Drop Table ChangeLogr
- E:TestDeploymentTest.proj(212,5): error : Print 'Checking for Table ChangeLog'r
- E:TestDeploymentTest.proj(212,5): error : IF (NOT EXISTS(SELECT * FROM sys.objects WHER
- E [object_id] = OBJECT_ID(N'[dbo].ChangeLog') AND [type]='U'))r
- E:TestDeploymentTest.proj(212,5): error : BEGINr
- E:TestDeploymentTest.proj(212,5): error : CREATE TABLE dbo.ChangeLog r
- E:TestDeploymentTest.proj(212,5): error : (r
- E:TestDeploymentTest.proj(212,5): error : change_number INTEGER NOT NUL
- ,r
- E:TestDeploymentTest.proj(212,5): error : delta_set VARCHAR(10) NOT NUL
- ,r
- E:TestDeploymentTest.proj(212,5): error : start_dt DATETIME NOT NULL,r
- E:TestDeploymentTest.proj(212,5): error : complete_dt DATETIME NULL,r
- E:TestDeploymentTest.proj(212,5): error : applied_by VARCHAR(100) NOT N
- LL,r
- E:TestDeploymentTest.proj(212,5): error : description VARCHAR(500) NOT
- ULLr
- E:TestDeploymentTest.proj(212,5): error : )r
- E:TestDeploymentTest.proj(212,5): error : r
- E:TestDeploymentTest.proj(212,5): error : IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
- IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON ENDr
- E:TestDeploymentTest.proj(212,5): error : r
- E:TestDeploymentTest.proj(212,5): error : ALTER TABLE ChangeLog ADD CONSTRAINT
- PK_ChangeLog PRIMARY KEY (change_number, delta_set)r
- E:TestDeploymentTest.proj(212,5): error : IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
- IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON ENDr
- E:TestDeploymentTest.proj(212,5): error : ENDr
- E:TestDeploymentTest.proj(212,5): error : GOr
- E:TestDeploymentTest.proj(212,5): error : IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRA
- NCOUNT>0 ROLLBACK SET NOEXEC ON ENDr
- E:TestDeploymentTest.proj(212,5): error : GOr
- E:TestDeploymentTest.proj(212,5): error : r
- E:TestDeploymentTest.proj(212,5): error : UPDATE dbo.ChangeLog SET complete_dt = getdat
- e() WHERE complete_dt IS NULLr
- E:TestDeploymentTest.proj(212,5): error : GOr
- E:TestDeploymentTest.proj(212,5): error : r
- E:TestDeploymentTest.proj(212,5): error : IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRA
- NCOUNT>0 ROLLBACK SET NOEXEC ON ENDr
- E:TestDeploymentTest.proj(212,5): error : GOr
- E:TestDeploymentTest.proj(212,5): error : r
- E:TestDeploymentTest.proj(212,5): error : -- COMMITTING TRANSACTIONr
- E:TestDeploymentTest.proj(212,5): error : IF @@TRANCOUNT>0r
- E:TestDeploymentTest.proj(212,5): error : BEGINr
- E:TestDeploymentTest.proj(212,5): error : PRINT 'Committing transaction'r
- E:TestDeploymentTest.proj(212,5): error : COMMIT TRANSACTION r
- E:TestDeploymentTest.proj(212,5): error : ENDr
- E:TestDeploymentTest.proj(212,5): error : GOr
- E:TestDeploymentTest.proj(212,5): error : r
- E:TestDeploymentTest.proj(212,5): error : SET NOEXEC OFFr
- E:TestDeploymentTest.proj(212,5): error : GOr
- E:TestDeploymentTest.proj(212,5): error :
- E:TestDeploymentTest.proj(212,5): error : Could not load file or assembly 'Microsoft.Sq
- lServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
- The above script is working fine in my Dev box and also on a box (Windows Server 2008 R2) where SQL SERVER 2008 R2 is installed. Issues started once I tried to test it on a new box where SQL SERVER 2012 is installed.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement