Click here to Skip to main content
15,893,487 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: myProfile.myDomain.com or myDomain.com/myProfile Pin
Gerben Jongerius15-May-11 6:30
Gerben Jongerius15-May-11 6:30 
AnswerRe: myProfile.myDomain.com or myDomain.com/myProfile Pin
Gregory Gadow18-May-11 6:37
Gregory Gadow18-May-11 6:37 
Questionoff topics: search by number of characters Pin
Jassim Rahma15-May-11 2:03
Jassim Rahma15-May-11 2:03 
AnswerRe: off topics: search by number of characters Pin
DaveAuld15-May-11 2:31
professionalDaveAuld15-May-11 2:31 
Answeruse this link Pin
sathya.spidy3-May-11 20:25
sathya.spidy3-May-11 20:25 
GeneralRe: use this link Pin
GenJerDan4-May-11 3:38
GenJerDan4-May-11 3:38 
GeneralRe: use this link Pin
Ravi Sant5-May-11 0:19
Ravi Sant5-May-11 0:19 
QuestionCustom CMS Tools and Load Balanced Web Servers Pin
Member 39880243-May-11 7:54
Member 39880243-May-11 7:54 
Greetings,

I’m uncertain of the right forum for this question, so apologies if it is misplaced.

My organization has been working with a series of small, custom built “CMS” tools to manage some of the content on our site. These tools save database information as well as images to the file system of the web server. Example: we have an actor bios section that lists the roles and plays of the performers (stored in SQL Server) and includes an image of the performer (saved to the file system with a varchar pointer to the image in the database). This worked well for us in past years, but we have recently moved to a load balanced environment and it has introduced some complexity. The two web servers are using a shared database, so that part is easy. However, they have separate file systems which are both synced to a third box (a staging environment). The staging server has it’s own database. This causes a couple problems: it means that anything uploaded to one server through the tools will be missing the image in the file system on the second server, and more importantly it means that unless the staging server also has the data entered along with the image that when we do a sync from staging to live it obliterates the images on the live environments. For the time being, we are entering everything on the staging environment and syncing all of the files and database content at once (I’m using SQLBulkCopy to move the relevant tables from staging to live). This creates undesirable limitations for our Marketing department, however, who are accustomed (and rightfully) to being able to make on-the-fly changes to low-risk content in the live environment without ITS intervention.

Whew.

So my question finally is how do I reconcile the staging database/live shared database and the file system issues such that my Marketing group can make content changes easily in the live, load-balanced, environments. Ideally, I wanted to be able to have them enter all the data as well as images on the staging site and “make them live”, copying both the data and relevant images to the file systems of both web servers. I have not found a way to be on one web server and, using a CMS-like web tool, copy an image to a different web server (perhaps with good reason…).

I am using ASP.NET 3.5, Visual Studio 2010, and SQL Server 2008. The site runs in IIS7. We code in C#.

Thanks in advance for any guidance you can provide.

Matt Belanger
Web Developer
Questionsubmit buttons and image buttons Pin
Ali Al Omairi(Abu AlHassan)21-Apr-11 15:42
professionalAli Al Omairi(Abu AlHassan)21-Apr-11 15:42 
AnswerRe: submit buttons and image buttons Pin
Gerben Jongerius21-Apr-11 19:29
Gerben Jongerius21-Apr-11 19:29 
GeneralRe: submit buttons and image buttons Pin
Ali Al Omairi(Abu AlHassan)22-Apr-11 3:31
professionalAli Al Omairi(Abu AlHassan)22-Apr-11 3:31 
GeneralRe: submit buttons and image buttons Pin
Gerben Jongerius22-Apr-11 3:56
Gerben Jongerius22-Apr-11 3:56 
GeneralRe: submit buttons and image buttons Pin
Ali Al Omairi(Abu AlHassan)22-Apr-11 4:38
professionalAli Al Omairi(Abu AlHassan)22-Apr-11 4:38 
GeneralRe: submit buttons and image buttons Pin
AspDotNetDev3-May-11 8:14
protectorAspDotNetDev3-May-11 8:14 
GeneralRe: submit buttons and image buttons Pin
smithymoon4-May-11 23:33
smithymoon4-May-11 23:33 
QuestionSession Import from IE to Firefox [Solved] Pin
Ravi Sant19-Apr-11 5:11
Ravi Sant19-Apr-11 5:11 
AnswerRe: Session Import from IE to Firefox Pin
Gerben Jongerius21-Apr-11 19:35
Gerben Jongerius21-Apr-11 19:35 
Questionwhy soap serializaiton take much time Pin
Eric Vonjacson18-Apr-11 0:36
Eric Vonjacson18-Apr-11 0:36 
QuestionHow to get Excel and Word documents to open without the Open,Save,SaveAs box opening in IE9 Pin
TClarke14-Apr-11 3:19
TClarke14-Apr-11 3:19 
AnswerWorked it out myself Pin
TClarke14-Apr-11 5:24
TClarke14-Apr-11 5:24 
AnswerRe: How to get Excel and Word documents to open without the Open,Save,SaveAs box opening in IE9 Pin
Prasanta_Prince19-Apr-11 23:40
Prasanta_Prince19-Apr-11 23:40 
AnswerRe: How to get Excel and Word documents to open without the Open,Save,SaveAs box opening in IE9 Pin
Peter_in_278020-Apr-11 14:38
professionalPeter_in_278020-Apr-11 14:38 
Answername server settings - Solved [modified] Pin
Andy_L_J13-Apr-11 22:52
Andy_L_J13-Apr-11 22:52 
QuestionNested Row Grouping in Matrix Layout in SQL reporting services 2005 Pin
Jyothsna Vedam12-Apr-11 18:06
Jyothsna Vedam12-Apr-11 18:06 
AnswerCrosspost Pin
thatraja12-Apr-11 18:55
professionalthatraja12-Apr-11 18:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.