[dba-SQLServer] OT:DFSR db's

Thanks for the tip, quick question if I may before i start  research,
 
is this possible with the express or compact, or does it have to be Full Version of SQL, becuase I know  i dont have the funding for 8 sql licenses.
 
tia
 
> From: fhtapia at gmail.com
> Date: Wed, 22 Sep 2010 09:55:27 -0700
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [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
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>