StrataFrame Forum » StrataFrame Application Framework - V1 » WebForms (How do I?) » deploying to production server

deploying to production server

Keith Chisarik — Mon, 29 Jan 2007 10:00:00 GMT

Is there a way I can deploy my web app to a new SQL Server without having to recompile Global.asax with the new IP?

Can I code it to read web.config or some other easier way, so I don't have to recompile or maintain two sets of compiled code, one for my test server and one for production and one for my test server.

RE: deploying to production server

Trent L. Taylor — Mon, 29 Jan 2007 10:00:00 GMT

Great! :D

RE: deploying to production server

Keith Chisarik — Mon, 29 Jan 2007 09:54:01 GMT

Exactly what I wanted. Thanks.

RE: deploying to production server

Trent L. Taylor — Mon, 29 Jan 2007 09:52:45 GMT

All of this is entirely up to you as to how you would like to pull the connection string. Since the connection has to be manually specified anyway, it is really easy to have it pull from a config file or some other file. You can also place a test to determine which server you are on. If you host names will be different then you could just use the host name and test on that within the global.asax when defining the connection string.

For example, the following code would look to see if the subdomain was different and create a connection based on that:

[codesnippet]Dim lcHost As String = Request.Url.Host
Dim lcSubDomain As String = lcHost.Split(New Char() {"."c})(0)

'-- Set the session type
If lcSubDomain.Equals("www", StringComparison.OrdinalIgnoreCase) Then
    DataBasics.DataSources.Add(New MicroFour.StrataFrame.Data.SqlDataSourceItem("", "connectionstring1"))
ElseIf lcSubDomain.Equals("support", StringComparison.OrdinalIgnoreCase) Then
    DataBasics.DataSources.Add(New MicroFour.StrataFrame.Data.SqlDataSourceItem("", "connectionstring2"))
End If[/codesnippet]

RE: deploying to production server

Keith Chisarik — Mon, 29 Jan 2007 09:26:04 GMT

Actually what would be nice os if the code was smart enough to know if it was running an server A or server B and execute the correct DataLayer.DataSources.Add command against the correct SQL Server.

Any idea how to accomplish this?

Can I write some code to query the server name or other identifier to evaluate against?
I am sure you can I just don't know how.