Copying data from one table to another (differents servers)

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
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
|||and ....
"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...
>
>
|||I would suggest using DTS/SSIS (depending upon your version) to do this.
While replication sounds tempting, there are a variety of situations which
happen in development environment which would create problems with the
replication engine. That introduces errors into your production environment
that you wouldn't otherwise have. You are much better off to simply leave
them decoupled and use DTS/SSIS to extact and load the data on demand.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"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