wrote in message news:F5C16F54-6F6C-413B-B991-3EC8353872CA@microsoft.com...
> Hi,
>
> I'm Roby Eisenbraun Martins. I'm a C++,VB and C# developer.
> I need to work with an offline database. This database will have a
> table, just like the server, Where I need to copy a filtered group of
> data.
> The ideia is to keep my local table synchronized with the filtered
> group
> of data, so each time I have to delete all data from the table and copy it
> all again.
> Should I use snapshot?
> Or can I copy the data from one server to another without
> linkedservers?
>
> Thank you,
> Roby Eisenbraun Martins

"Hilary Cotter" wrote:

> there are a multitude of ways to do this. Transactional replication,
> snapshot, bcp, dts (SSIS in SQL 2005).
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Roby Eisenbraun Martins" <RobyEisenbraunMartins@discussions.microsoft.com>
> wrote in message news:F5C16F54-6F6C-413B-B991-3EC8353872CA@microsoft.com...
> > Hi,
> >
> > I'm Roby Eisenbraun Martins. I'm a C++,VB and C# developer.
> > I need to work with an offline database. This database will have a
> > table, just like the server, Where I need to copy a filtered group of
> > data.
> > The ideia is to keep my local table synchronized with the filtered
> > group
> > of data, so each time I have to delete all data from the table and copy it
> > all again.
> > Should I use snapshot?
> > Or can I copy the data from one server to another without
> > linkedservers?
> >
> > Thank you,
> > Roby Eisenbraun Martins
>
>