Standard methods for remote users syncronizing data at night. 
Author Message
 Standard methods for remote users syncronizing data at night.

I would like to know what direction is "Standard" for the below
requirements.

Application VB and SQL Server 7.0
Local and Remote users

The remote users need to login to the server each night to syncronize /
update the server with any new changes, and to get new projects and other
database information Contacts, etc...

We would like the Remote user who connects by modem to have the ability to
select a subset of data to work with for the day ie choose the clients for
the day between 10 and 30 so that the process if short when syncronizing.
Each table (and there are many) has a primary key counter id.

In short need to replicate and syncronize for raoming users (10 - 20) on the
road.

Need to know if this is functionality I need to custome code myself in vb,
or does MSDE and SQL Srever 7.0 provide the tools to get the job started?
Keeping in mind each table has a primary key.

If more details are needed do not hesitate...

Maybe I am not searching the right places but can not seem to find much info
on this type of implimentation.

Any links etc.. welcome

Thanks all

Jason...



Tue, 28 Oct 2003 15:45:22 GMT
 Standard methods for remote users syncronizing data at night.

Jason,

have you looked at replication? I suppose specially the merge replication
could be considered as the solution for your problem.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com


Quote:
> I would like to know what direction is "Standard" for the below
> requirements.

> Application VB and SQL Server 7.0
> Local and Remote users

> The remote users need to login to the server each night to syncronize /
> update the server with any new changes, and to get new projects and other
> database information Contacts, etc...

> We would like the Remote user who connects by modem to have the ability to
> select a subset of data to work with for the day ie choose the clients for
> the day between 10 and 30 so that the process if short when syncronizing.
> Each table (and there are many) has a primary key counter id.

> In short need to replicate and syncronize for raoming users (10 - 20) on
the
> road.

> Need to know if this is functionality I need to custome code myself in vb,
> or does MSDE and SQL Srever 7.0 provide the tools to get the job started?
> Keeping in mind each table has a primary key.

> If more details are needed do not hesitate...

> Maybe I am not searching the right places but can not seem to find much
info
> on this type of implimentation.

> Any links etc.. welcome

> Thanks all

> Jason...



Tue, 28 Oct 2003 20:29:16 GMT
 Standard methods for remote users syncronizing data at night.
Will replication work even when used with primary key counters ? I will look
into it thanks



Quote:
> Jason,

> have you looked at replication? I suppose specially the merge replication
> could be considered as the solution for your problem.

> --
> Dejan Sarka, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com



> > I would like to know what direction is "Standard" for the below
> > requirements.

> > Application VB and SQL Server 7.0
> > Local and Remote users

> > The remote users need to login to the server each night to syncronize /
> > update the server with any new changes, and to get new projects and
other
> > database information Contacts, etc...

> > We would like the Remote user who connects by modem to have the ability
to
> > select a subset of data to work with for the day ie choose the clients
for
> > the day between 10 and 30 so that the process if short when
syncronizing.
> > Each table (and there are many) has a primary key counter id.

> > In short need to replicate and syncronize for raoming users (10 - 20) on
> the
> > road.

> > Need to know if this is functionality I need to custome code myself in
vb,
> > or does MSDE and SQL Srever 7.0 provide the tools to get the job
started?
> > Keeping in mind each table has a primary key.

> > If more details are needed do not hesitate...

> > Maybe I am not searching the right places but can not seem to find much
> info
> > on this type of implimentation.

> > Any links etc.. welcome

> > Thanks all

> > Jason...



Tue, 28 Oct 2003 21:37:12 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Standard methods for remote users syncronizing data at night.

2. Standard methods for remote users syncronizing data at night.

3. US-VA: Oracle DBA Looking for Remote or Night Shift Work

4. Oracle DBA Looking for Remote or Night Shift Work

5. Remote Data Control's Validate method

6. Remote Data Control's Validate method

7. Best method for remote data of Oracle database

8. Remote Data Methods

9. Best way to syncronize two users

10. Silicon Valley Paradox Users Group Meeting Tuesday Night

11. Utility for syncronizing data to modified schema (Access to SQL Server)

12. How to use UNC path to syncronize data


 
Powered by phpBB® Forum Software