Solved

Replication to SQL7 Client or Access DB

Posted on 1998-09-16
6
263 Views
Last Modified: 2010-03-19
I'm trying to figure out if it's possible or desirable to use the sql server client as a client side database instead of access in a remote client server system. I'm developing a sales force automation system and we need to replicate partial copies of a sql database to client lap tops.  I know access can replicate with itself and sql server can replicate with another sql server or (subscribe/publish), but can an access database replicate with a sql server database, if so how?
0
Comment
Question by:expert69
6 Comments
 
LVL 4

Expert Comment

by:vvk
ID: 1090108
What you means by "replicate"? If you ask can databases syncrohize on-line you mast write application that can read access DB and put changes to SQL server.
0
 

Author Comment

by:expert69
ID: 1090109
By replication I'm referring to the synchronization feature that sql server 7.0 has for keeping several databases in synch, across several computers.  The documentation suggests that two servers can be kept in synch but I'm looking for a remote client server synchronization for traveling salesmen.
0
 
LVL 4

Expert Comment

by:vvk
ID: 1090110
It's possible only between SQL servers. In your case you must write own application for syncronization.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 1

Accepted Solution

by:
achopra earned 50 total points
ID: 1090111
Since you are developing for SQL 7, I would strongly reccomend that you stick to SQl rather than access.

The 7.0 desktop works a lot better than access specially in regard to the replication aspects. It is also a whole lot more robust, and will offer you some stuff that an access database cant. For exammple the ability to embedd English Query, be able to use aspects of OLAP, and DSS systems etc etc.

personally evene though I thing Access 97 is a powerful system, it is clearly going to be overshadowed by SQL Desktop.

0
 

Author Comment

by:expert69
ID: 1090112
Achopra,
Thanks for the response, How would I distribute the sql server desktop, with access I can add the mdb file to my distribution set. With sql server will I need to do a seperate install on each client machine? I'm developing one front end in VB and another in html/asp as a web based client system.
0
 
LVL 1

Expert Comment

by:Marke030399
ID: 2164876
To expert69

I am about to start facing the same issues as you talk about above. Did you run wuth SQL client replication, or Access (which does offer replication to SQL Server by the way).

What about the licensing issues of clients using SQL rather than Access.

Could you email me on me1@softools.co.uk
to discuss? I understand if you are too busy, but could you reply saying so, just so I know you got this message.

Thanks

Mark
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question