Msg 3728 and 3727

Question

Hi, I have this error when executing the command

D:\ROP\EPM.Aguas.ROP\EPM.Aguas.ROP.DatabaseComparison\Database3\sql\debug>sqlcmd
  -S localhost -d EPM_ROP_JUNIO_25_CONCAMBIOSDESDEDESARROLLO -i Database3.sql


Changed database context to 'master'.
Changed database context to 'EPM_ROP_JUNIO_25_CONCAMBIOSDESDEDESARROLLO'.
Dropping ROP.FK_CaudalesLodoPrimario_CaudalesLodoPrimarioEncabezados...
Msg 3728, Level 16, State 1, Server C-LVALENCIA1, Line 1
'FK_CaudalesLodoPrimario_CaudalesLodoPrimarioEncabezados' is not a constraint.
Msg 3727, Level 16, State 1, Server C-LVALENCIA1, Line 1
Could not drop constraint. See previous errors.


The error is on these lines of the script

PRINT N'Dropping ROP.FK_CaudalesLodoPrimario_CaudalesLodoPrimarioEncabezados...';


GO
ALTER TABLE [ROP].[CaudalesLodoPrimario] DROP CONSTRAINT [FK_CaudalesLodoPrimario_CaudalesLodoPrimarioEncabezados];

---

MCPD ENTERPRISE APPLICATIONS DEVELOPER http://wantmvp.blogspot.com/

Answer 1

These error messages are coming from SQL server. Looks like you were executing the deployment scripts by using sqlcmd against your local Sql instance. 

If you want to deploy your database project to a target server, you can try using Deploy menu in the project (with deployment settings in the properties page). Or you can go thru the command line tool VSDBCMD.

--Joyce

Answer 2

where can I find that command tool?

---

MCPD ENTERPRISE APPLICATIONS DEVELOPER http://wantmvp.blogspot.com/

Answer 3

If you are using GDR or GDR R2, you should be able to find it at <VS installation path>\VSTSDB\Deploy\