expert69
asked on
Replication to SQL7 Client or Access DB
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?
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.
ASKER
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.
It's possible only between SQL servers. In your case you must write own application for syncronization.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
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
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