Eric Barro
ebarro at afsweb.com
Mon Sep 13 09:10:48 CDT 2004
Michael, M$ replication is a resource hog. You might want to consider log shipping instead. If each site has less than 20 users you might consider an Access db at each location with a VB front end talking to the central SQL server via the web. This way each site owns their data. The VB front end writes data to the local Access MDB and to the remote SQL server. --- Eric Barro Senior Systems Analyst Advanced Field Services (208) 772-7060 http://www.afsweb.com -----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