?
Solved

Replication to SQL7 Client or Access DB

Posted on 1998-09-16
6
Medium Priority
?
282 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 1

Accepted Solution

by:
achopra earned 200 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

743 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