You are here: Re: How do you conditionally fire a trigger (mimic replication) « MsSQL Server « IT news, forums, messages
Re: How do you conditionally fire a trigger (mimic replication)

Posted by Damien on 10/20/06 04:41

samh wrote:
> Alex,
> Thanks for suggestion. Replication is not possible, the client this is
> being developed for is insisting on not using it so I don't have much
> choice.
>
> The problem I have is that the example I gave is a basic version. I
> have 1 central server and 6 local servers so giving odd/even isn't
> possible. All the local servers are replicating their changes to the
> central server and it's in turn replicating back down to the local
> server which sent the data. The problem that I described above is
> still essentially the problem I need to solve.
>
> I thought there would of been a very easy way to turn of triggers but
> this seems not the case?
>
> Cheers,
> Steve.

Hi Steve,

It sounds like your client needs a talking to! There is a technological
solution (replication) which has been extensively developed and tested,
and yet they want you to produce something which (not trying to be
nasty) won't be as thoroughly tested and validated?

I know that sometimes people come back with statements such as "I've
already said I can't do X", but can you tell us the reasons why the
clients have ruled out replication? Sometimes this helps in being able
to suggest alternatives (e.g. there may be alternate solutions which
would encounter exactly the same objections, so knowing the objections
helps us to frame suggestions that might be acceptable).

Damien

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация