Remove VS DB deployment script dependency on server name

Question

When I deploy dbproj to SQL script and try to run it on another computer I get an error:

The server name in the build script SOMENAME does not match the name of the target server ANOTHERNAME. Verify whether your database project settings are correct and whether your build script is up to date.

There are such lines generated in the script:

IF (@@servername != 'MYNAME')
BEGIN
    RAISERROR(N'The server name in the build script %s does not match the name of the target server %s. Verify whether your database project settings are correct and whether your build script is up to date.', 16, 127,N'MYNAME',@@servername) WITH NOWAIT
    RETURN
END

Is there any way to allow SQL deployment script to run on any server?

Dmitry Fedorkov · Accepted Answer · 2012-08-17 09:59:41Z

3

I found a solution: I just have to go to Project Properties -> Deploy -> Edit Deployment Configuration File and uncheck GenerateDeployStateChecks checkbox. After that any mention of my server name disappear in deployment script.

answered Aug 17, 2012 at 9:59

Dmitry Fedorkov

4,4351 gold badge26 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rob Bowman Over a year ago

I have the same problem but I don't see and option for "GenerateDeployStateChecks" to uncheck. I am using VS2010 Ultimate.

Dmitry Fedorkov Over a year ago

@Rob, strange, I use the same version... You can find this option in Properties\Database.sqldeployment.

Collectives™ on Stack Overflow

Remove VS DB deployment script dependency on server name

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related