About Endpoints

When I constructed my endpoint:

CREATE ENDPOINT MyNewEndPoint
STATE = STARTED
AS HTTP
(
PATH = '/MyEndpoint',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = 'arkansas'
)
FOR SOAP
(
WEBMETHOD 'GetSession'
(NAME='MyDB.dbo.spGetSession'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'MyDB',
NAMESPACE = 'http://MyDB/MyEndpoint'
)

the site is hardcoded. But, when I'm getting ready to deploy I'll need the site to be my production site. Is there an easier way to accomplish this then to edit the script each time before delpoyment?

TIA,
Dave C.

Hi Dave,

I assume you have some kind of a setup script or procedure? If that's the case, you could do this:

(a) Create the endpoint always with the hardcoded script above

(b) Bootstrap a small script execution with an ALTER ENDPOINT statement. For instance use SQLCMD.EXE like this:

SQLCMD.EXE -E -S. -Q"ALTER ENDPOINT MyNewEndPoint..."

or -of course- you could simply create the endpoint this way.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.