SQL 2000 Server with stand alone box

[dejamakan]

Hi all.

I am building a database using MS SQL 2000 Server. My users are require to keep a subset of the data on their local box and be able to upload any changes to the server as required. I'll need this data to creat monthly reports. I know SQL Server has this capability can someone point me to it?

Thanks

dejamakan

 

[SQLSister]

Look under replication.

You could also design DTS packages to do something simlar.

 

[NoCoolHandle]

Replication with either horizontal or vertical partitioning (or both) sounds like what you are looking for..

THe specific methods could be scheduled snapshot or replication....
THen all you need to do is build your articles and define what data you are going to share..

HTH

Rob

 

[dejamakan]

Thanks for your quick response guys. I'll look into it.

<trevor />

dejamakan