[dba-SQLServer] Opinions welcome

Hi Michael:

I had a site that had three offices, a medium number of changes and
additions a day. The site was set to auto-sync three times a day, morning,
noon and late afternoon or when ever a new record was created...there was a
master invoice record/table so there could be no duplicates. There was also
a manual button, just in case.

In the seven years the site has been up, there has only been two or three
duplicates and those were a result of extenuating circumstances and nothing
to do with the sync process.

If you need any help with the deployment, it is straight-forward but it can
be lengthy or the coding...it is really very simple. Also, Arthur from the
group has had a good deal of background in the subject.

HTH
Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Michael
Maddison
Sent: Monday, September 13, 2004 4:49 AM
To: dba-SQLServer
Subject: [dba-SQLServer] Opinions welcome


I have a client who is contemplating installing an application in 28
sites over
an area of about 500 sq miles.  They initially consulted me to ask what
was
involved in doing the installs remotely...  At that stage they said to
me they
were going to install SQL in all 28 sites.  I asked for clarification
thinking they
surely only needed MSDE at each site otherwise the cost would have been
enormous (I know these people don't have that sort of money).

Anyway, I've just had a look at the db (installed @ my office) and
application
(you can tell its been upsized from Access, all those varchar(255)
fields).
They now want me to advise them on replicating the 28 db's back to their
central server!  I've had a look at the schema and there is no native
way to
split the data by site.

Do I
	1.  Run like hell  ;-)
	2.  Replicate back to 28 db's
	3.  Build a master db that can tell 1 site from another
	4.  Run the apps client/server

Can I
	1.  Append a site field to the replicated data?
	2.  Replicate the 28 --> 28 --> 1 (master)

I'm going to a meeting tomorrow and just wanted to see if I had missed
any
obvious options.

cheers

Michael M
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com