Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Replication to SQL7 Client or Access DB

Posted on 1998-09-16
6
Medium Priority
?
284 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

618 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