[dba-SQLServer] OT:DFSR db's

Because you are going to have two sites looking at the same data you will
want to look into "Merge" replication I think that makes the most sense.
the Database Mirroring is more for disaster recovery than independent
sites.  Merge replication will still have collisions if both sites work on
updating similar records and there will need to be someone in the middle
authorizing which collision of data is the winner...

Review SqlServerCentral.com for merge replication articles OR review the
books online to give you a base idea on how it works.  dbjournal.com also
has great articles as well...

-Francisco
http://bit.ly/sqlthis   | Tsql and More...




On Wed, Sep 22, 2010 at 4:27 AM, Jean-Paul natola <jnatola at hotmail.com>wrote:

>
> we have a field office with less than reliable connectivity, and it would
> be nice  if they can work locally on th DB  when the internet is down
>
>
>
>
>
>
>
>
>
>
>
> Jean-Paul Natola
>
>
>
>
>
> > From: fhtapia at gmail.com
> > To: dba-sqlserver at databaseadvisors.com
> > Date: Tue, 21 Sep 2010 19:08:07 -0700
> > CC: dba-sqlserver at databaseadvisors.com
> > Subject: Re: [dba-SQLServer] OT:DFSR db's
> >
> > Have not... I'm not sure what you are attempt to do, do you just want
> > high availability? If so SQL has built in tools for that such as
> > replication, transaction log shipping, and database mirroring to name
> > a few. You can also do a full blown clustered environment.
> >
> > Sent from my mobile
> >
> > On Sep 21, 2010, at 1:17 PM, Jean-Paul natola <jnatola at hotmail.com>
> > wrote:
> >
> > >
> > > Does anyone know , or has tried windows DFSR functionality with a
> > > sql db?
> > >
> > > TIA
> > >
> > > J
> > >
> > > _______________________________________________
> > > dba-SQLServer mailing list
> > > dba-SQLServer at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > http://www.databaseadvisors.com
> > >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>