Hi,
Not sure I am in the right place here but thought I would ask an open
question. We have an IIS website, mainly ASP files, .NET 1 & 2, this
is located in our DMZ. It connects back into the LAN using using port
1433 to our SQL 2000 server.
As the Sysadmin I try to ensure our development team only work on the
development SQL & IIS boxes but this is becoming more difficult by the
day. Very soon I am moving the production servers to a data center so
obviously any problems would cause extensive downtiume due to
distances I have to travel..
How do you all deal with the developer idea that you must work on live
servers during working hours? My view is that any bugfixes or software
release's should be carried out out of business hours, but I seem to
be hiting a brick wall as I am on my own..
Cheers
9  1733 
You can setup a test site that will run a copy of the production code
connected to a copy of the production database. Once changes are tested
there, they can be deployed to production in after hours.
--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET] http://msmvps.com/blogs/egoldin http://usableasp.net
"gstar" <ga********@gma il.comwrote in message
news:11******** **************@ e9g2000prf.goog legroups.com...
Hi,
Not sure I am in the right place here but thought I would ask an open
question. We have an IIS website, mainly ASP files, .NET 1 & 2, this
is located in our DMZ. It connects back into the LAN using using port
1433 to our SQL 2000 server.
As the Sysadmin I try to ensure our development team only work on the
development SQL & IIS boxes but this is becoming more difficult by the
day. Very soon I am moving the production servers to a data center so
obviously any problems would cause extensive downtiume due to
distances I have to travel..
How do you all deal with the developer idea that you must work on live
servers during working hours? My view is that any bugfixes or software
release's should be carried out out of business hours, but I seem to
be hiting a brick wall as I am on my own..
Cheers
"gstar" <ga********@gma il.comwrote in message
news:11******** **************@ e9g2000prf.goog legroups.com...
How do you all deal with the developer idea that you must work on live
servers during working hours? My view is that any bugfixes or software
release's should be carried out out of business hours, but I seem to
be hiting a brick wall as I am on my own..
I have three environments: dev, test and live.
Developers don't need to work on live servers - they may, however, need to
work on real data, in which case synchronise the live database(s) with the
dev and/or test database(s) at the beginning of the working day.
--
Mark Rae
ASP.NET MVP http://www.markrae.net
I have three environments: dev, test and live.
Developers don't need to work on live servers - they may, however, need to
work on real data, in which case synchronise the live database(s) with the
dev and/or test database(s) at the beginning of the working day.
--
Mark Rae
ASP.NET MVPhttp://www.markrae.net
Thankyou for you replies.
I too have dev, staging & live enviroment, thats what makes it so
annoying! They say if the MD needs a report in the middle of the day
or a customer rings in with a bug, it needs fixing on live right then!
I like the idea of synchronising the live data to the staging server,
is it easy to achieve, is that possible over the WAN? As you can see
we dont have a DBA so I am trying to firefight here! I also dont want
to sync the structure, just the data?
Again thankyou for your time, I know you must have answered questions
like this before..
"gstar" <ga********@gma il.comwrote in message
news:11******** ************@y2 7g2000pre.googl egroups.com...
They say if the MD needs a report in the middle of the day
That's not a bug, though! Why can't the MD use the live system...?
or a customer rings in with a bug, it needs fixing on live right then!
No! Staging and live must be running the same code, right? Otherwise there's
no point.
You really need to stand your ground here, and say the following:
If a customer rings in with a bug, it needs fixing on dev, testing on
staging and then deploying to live. If you can't deploy to your live system
during business hours, then you most certainly can't bug fix on your live
system either...
If your management is unable to see the rationale for this, then I strongly
suggest you look for another job. Hacking about with live systems is a sure
recipe for disaster - and when the disaster inevitably happens, who do you
think will get the blame...?
I like the idea of synchronising the live data to the staging server,
is it easy to achieve, is that possible over the WAN?
Sure - why not? You just need a tool which can connect to both your live
database(s) and your staging database(s). I use this: http://www.teratrax.com/. This is also very popular: http://www.red-gate.com/index.htm?gc...FRoGEgodyUi6eg, but it's
a bit more expensive. You can even write your own tool in raw T-SQL if
you're really strapped for cash, but why reinvent the wheel...?
As you can see we dont have a DBA so I am trying to firefight here!
In the words of Tom Jones, it's not unusual... :-)
I also dont want to sync the structure, just the data?
Both the products I mention above will do that.
Again thankyou for your time, I know you must have answered questions
like this before..
All part of the service... :-)
--
Mark Rae
ASP.NET MVP http://www.markrae.net
As Mark indicated, I wish I had a dollar for every time a disaster happened
because some developer was "fixing" something on a production web site and
they blew it because their fix didn't go through a sane testing process.
-- Peter
Recursion: see Recursion
site: http://www.eggheadcafe.com
unBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder: http://www.blogmetafinder.com
"gstar" wrote:
Hi,
Not sure I am in the right place here but thought I would ask an open
question. We have an IIS website, mainly ASP files, .NET 1 & 2, this
is located in our DMZ. It connects back into the LAN using using port
1433 to our SQL 2000 server.
As the Sysadmin I try to ensure our development team only work on the
development SQL & IIS boxes but this is becoming more difficult by the
day. Very soon I am moving the production servers to a data center so
obviously any problems would cause extensive downtiume due to
distances I have to travel..
How do you all deal with the developer idea that you must work on live
servers during working hours? My view is that any bugfixes or software
release's should be carried out out of business hours, but I seem to
be hiting a brick wall as I am on my own..
Cheers
All comments taken on board and appreciated, it has helped me to
decide our approach and given me some much needed confidence that I am
doing the right thing!!
I really like the Teratrax product, have tested and it does the job
brilliantly. I cant see a method to automate this to occur each day at
a certain time and sync the servers without any input, will look
further into it later, but do you know if thats possible?
Ta
"gstar" <ga********@gma il.comwrote in message
news:11******** **************@ q5g2000prf.goog legroups.com...
I really like the Teratrax product, have tested and it does the job
brilliantly. I cant see a method to automate this to occur each day at
a certain time and sync the servers without any input, will look
further into it later, but do you know if thats possible?
Ah, no - I don't think so...
This type of tool really is really aimed at ad-hoc development tasks rather
than regular and scheduled production tasks.
Luckily, though, if you need regular replication between production and
staging, then SQL Server already has this built-in: http://www.google.co.uk/search?sourc...22+replication
--
Mark Rae
ASP.NET MVP http://www.markrae.net
Ah, no - I don't think so...
>
This type of tool really is really aimed at ad-hoc development tasks rather
than regular and scheduled production tasks.
Luckily, though, if you need regular replication between production and
staging, then SQL Server already has this built-in:http://www.google.co.uk/search?sourc...-GB&ie=UTF-8&r...
--
Mark Rae
ASP.NET MVPhttp://www.markrae.net
OK, I guess I could run it manually each week to uopdate the data
locally. I have however run into a few problems so I may also try Red-
Gate, on the first DB I attempted to synch it reported that out of 47
tables 23 had no primary key so could do anything with it!. I have
asked the dev team why, but they shrugged their shoulders.. Helpful
eh?
Cheers
Gary
"gstar" <ga********@gma il.comwrote in message
news:11******** **************@ i13g2000prf.goo glegroups.com.. .
OK, I guess I could run it manually each week to uopdate the data
locally.
As mentioned, these are very much tools for ad-hoc work. Once I've set up
the various tasks (TeraTrax calls them "projects") , I only ever run them on
a need basis... For regular synchronisation , I use replication - that's what
it's for...
I have however run into a few problems so I may also try Red-
Gate, on the first DB I attempted to synch it reported that out of 47
tables 23 had no primary key so could do anything with it!. I have
asked the dev team why, but they shrugged their shoulders.. Helpful
eh?
You're wasting your time with this company...
I suggest you show your boss this thread...
--
Mark Rae
ASP.NET MVP http://www.markrae.net This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Guy Hocking |
last post by:
Hi there,
I am having trouble with an ASP login that uses sessions to control access
to certain pages. However the sessions are not being carried accross upon
using response.redirect.
I realise that this is the case that DNS names and IP addresses vary upon
whether it works or not, however how can i get around using sessions live on
the internet? and make them work>?
Hope you guys can help
|
by: ifmusic |
last post by:
I have This Code.
Token.c:
typedef struct {
unsigned char orden;
char ciudad;
unsigned char ip; //que son del router Asociado a la ciudad
unsigned int puerto; // """
//int socket;
}Ciudad;
|
by: Tim Haughton |
last post by:
The F Keys have stopped working in Visual Studio 2005 after installing
SP1. Anyone else seen this? Any know of a resolution?
Cheers,
Tim
|
by: Asif |
last post by:
Hi all,
Can any one help me out about how to do live video streaming in
asp.net page similar to YouTube.com?
Thanks a lot
Asif
|
by: Vijay |
last post by:
Hi,
I am working on an Asp.net 2.0 web application that uses master pages,
according to our application architecture we should not use Viewstate. Is
there a work around to raise the events fired from the child controls of
repeater when viewstate is disabled?
The scenario is as follows
I have a web page with a repeater that has controls on it, The viewstate is
disabled. The repeater is data bound to an arraylist in the page_load
| | |
by: =?Utf-8?B?Qm9yaXM=?= |
last post by:
I am running Win 2003 Server with IIS 6.0. I have installed .Net Frameworks
1.1, 2.0 and 3.5. However, if I create a new ASP.Net Web App using Visual
Studio 2008 and specify Framework 3.5 to be used, it does not work. Also,
when i go to the properties of the site through IIS, under ASP.Net Tab, I
only have Frameworks 1.1 and 2.0 in the drop down where you specify which
version is to be used by the app. Framework 3.5 is not listed there at...
|
by: =?Utf-8?B?V2ViQnVpbGRlcjQ1MQ==?= |
last post by:
I'm unable to debug websites. For some reason my visual studio is not
stopping on break points. Has this happened to anyone else.
I'm on vista and vs2k5
--
(i''ll be asking a lot of these, but I find C# totally way cooler than vb
and there''s no go''n back!!!)
thanks (as always)
kes
|
by: Erik Lautier |
last post by:
I've got Page_Error emailing me the message and stack trace when a
server error is generated, but it doesn't always work. My Page_Error
code:
Sub Page_Error(ByVal src As Object, ByVal args As EventArgs) Handles
MyBase.Error
Dim e As System.Exception = Server.GetLastError()
Session("Erro")= "Error: " & e.Message.ToString() & "<p>Stack Trace: "
& e.StackTrace.ToString()
Context.ClearError()
|
by: =?Utf-8?B?c2lwcHl1Y29ubg==?= |
last post by:
Have a complex process where I need to Import a large amount of data
then run some transformations on this data then import into DataBase.
The transformation involves multiple fields and multiple process - so the
data needs to be read in 1 record at a time then run thru the transformation
that may create new data value then everything is imported into a db to store.
I have multiple questions
1)we used to have an internal data structure...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
