473,322 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Synchronizing Local and Web Data

I am not sure if these are the correct groups to post this, so please
redirect me if there are better ones.

Client has a SQL Server db of organizations and member info that is in
pretty much constant use at his location.
He would like to make the maintenance of adding/editing member info
available on the web.
Since the data contains personal info the web app (built in ASP.NET) will
use SSL.
The unique identifier for a member is the combination of the organization
and a user supplied value. This can't be changed as the local front end is
already in use and built by another party.

My thought is to place a copy of the db with relevent tables on the
webserver (commercial host) and synchronize it with the local db.

Client's current internet connection is DSL, but he would be willing to get
fractional T1 if needed.

I would appreciate any thoughts, comments, suggestions on synchronizing the
data.

TIA

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us

Nov 18 '05 #1
7 1104
Alphonse,
as you are editing data at both sites, my recommendation would be merge
replication. Merge will allow autonomy (disconnected access between the 2
SQL Server databases) and latency. It will also solve and log conflicts if
your client edits a member's info while someone else does on the aspx page.
There is a good section on merge replication in BOL.
For the replication setup over DSL/T1 you'll need to arrange things a little
differently as presumably it'll be a VPN or non-trusted domain. Here is a
reference to help set it up: http://support.microsoft.com/?id=321822
HTH,
Paul Ibison
Nov 18 '05 #2
Paul,

Thanks for the info and link.
What would be the feasability of just keeping the db at the client site and
having the web server accessing the data (read/write) directly from client's
SQL Server via a vpn?
Of course, upgrading from the DSL.

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"Paul Ibison" <Pa*********@Pygmalion.Com> wrote in message
news:u6**************@TK2MSFTNGP11.phx.gbl...
Alphonse,
as you are editing data at both sites, my recommendation would be merge
replication. Merge will allow autonomy (disconnected access between the 2
SQL Server databases) and latency. It will also solve and log conflicts if
your client edits a member's info while someone else does on the aspx page. There is a good section on merge replication in BOL.
For the replication setup over DSL/T1 you'll need to arrange things a little differently as presumably it'll be a VPN or non-trusted domain. Here is a
reference to help set it up: http://support.microsoft.com/?id=321822
HTH,
Paul Ibison

Nov 18 '05 #3
Hi Alphonse,

I also agree on Paul's suggestion on using SQLSERVER's replication
function. And as for the accessing the db via a vpn problem you mentioned,
I think maybe the main problem will focus on the connection between the two
machine since the VPN may have a firewall which will possibly prevent the
externel connection to the db server. Here is a kb article discussing on
this, you may have a look:

#INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default...b;EN-US;287932

In addition, if the client machine(have the sqlserver db installed) can
host a webservice application(have iis and dotnet framework), I suggest
that you can consider building a webservice and expose all the sqlserver db
data manipulation and synchronizing via this webservice. Thanks.

Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Nov 18 '05 #4
Thanks Steven,

A web service is also a possibility. Clients server is SBS 2000 and if it
does not already have IIS/dotnet, he would get it installed (I assume SBS
will support it).

A couple of questions though:

Since the data is personal, how would I protect it from prying eyes if using
a web service?

Which method would provide noticably better performance:
Replication,
connection to client's server via vpn,
web service,
other suggestions?

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"Steven Cheng[MSFT]" <v-******@online.microsoft.com> wrote in message
news:MS**************@cpmsftngxa06.phx.gbl...
Hi Alphonse,

I also agree on Paul's suggestion on using SQLSERVER's replication
function. And as for the accessing the db via a vpn problem you mentioned,
I think maybe the main problem will focus on the connection between the two machine since the VPN may have a firewall which will possibly prevent the
externel connection to the db server. Here is a kb article discussing on
this, you may have a look:

#INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/default...b;EN-US;287932

In addition, if the client machine(have the sqlserver db installed) can
host a webservice application(have iis and dotnet framework), I suggest
that you can consider building a webservice and expose all the sqlserver db data manipulation and synchronizing via this webservice. Thanks.

Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Nov 18 '05 #5
Alphonse,
I always prefer to get the data nearer the application; it avoids problems
of network connectivity issues, is generally faster and also offloads
processing work from the production server.
Regards,
Paul Ibison
Nov 18 '05 #6
Hi Alphonse,

Thanks for the followup. Yes, the webservice generally send data as plain
xml text, so if we want to transfer sensitive datas via webservice, we need
to apply some security mechanism. The SSL is one option, and there're also
some other approachs for security webservice such as custom encrypt on the
data,

#Encrypting SOAP Messages
http://msdn.microsoft.com/library/de...us/dnaspnet/ht
ml/asp09272001.asp

#SOAP Security: Encrypting SOAP messages
http://www.wimdows.net/articles/article.aspx?aid=17

As for the "which will provide noticably performance", I think the directly
acessing from DB server is generally more efficent. The XmlWebservice is
based on Xml SOAP message so the message parsing and processing will be the
performance concerns especially when transfering large quantity data.
However,
we should always think the webservie of a good means for transfering well
formatted interoperable data, that's its strengh.

Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Get Preview at ASP.NET whidbey
http://msdn.microsoft.com/asp.net/whidbey/default.aspx

Nov 18 '05 #7
Thanks for the info Steven.
I will check out the articles.
Once I get a look at the actual db structure, etc. I will be able to make my
decision.

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"Steven Cheng[MSFT]" <v-******@online.microsoft.com> wrote in message
news:qH*************@cpmsftngxa06.phx.gbl...
Hi Alphonse,

Thanks for the followup. Yes, the webservice generally send data as plain
xml text, so if we want to transfer sensitive datas via webservice, we need to apply some security mechanism. The SSL is one option, and there're also some other approachs for security webservice such as custom encrypt on the
data,

#Encrypting SOAP Messages
http://msdn.microsoft.com/library/de...us/dnaspnet/ht ml/asp09272001.asp

#SOAP Security: Encrypting SOAP messages
http://www.wimdows.net/articles/article.aspx?aid=17

As for the "which will provide noticably performance", I think the directly acessing from DB server is generally more efficent. The XmlWebservice is
based on Xml SOAP message so the message parsing and processing will be the performance concerns especially when transfering large quantity data.
However,
we should always think the webservie of a good means for transfering well
formatted interoperable data, that's its strengh.

Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Get Preview at ASP.NET whidbey
http://msdn.microsoft.com/asp.net/whidbey/default.aspx

Nov 18 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Keith Veleba | last post by:
Hello to all fellow c.l.p'ers! Long-time listener, first-time caller. Background: I'm working on a project where I have to do some serious multithreading. I've worked up a decorator in Python...
0
by: SQLServer007 | last post by:
25 more days until the "get it free" promotion runs out for xSQL Object (you can get it from http://www.x-sql.com) Here are just some of the great features packed in the product: - Compare SQL...
1
by: Phil Matish, MCSE | last post by:
I have an Access database that I use frequently. Often, I take it to a home PC, or laptop to work on at night. The next day, I overwrite the old one with the one I have been working on. The...
2
by: Christopher D. Wiederspan | last post by:
We are getting ready to move an ASP.NET application off of a single development machine and onto a "webfarm". Basically our webfarm is a bunch of identical servers with the load-balancing provided...
4
by: Chris Ochs | last post by:
We have a number of tables in a CRM that is written in MS access that I need to be able to provide a web interface to. I can export the tables just fine using pgadmin II, but I cant' think of a...
3
by: jodyblau | last post by:
I'm fairly new to access, so I hope this question isn't too elementary. I'm putting together a database for my office. I want the database to be accessible to 5 or 6 users on our network and so...
1
by: MAILTONRK | last post by:
Hi, I am a Mainframe guy. I am working with MS access(maintaining a application) for the last 2 weeks. I had one master database and four replicas. One of my replica had trouble in...
4
by: Veggis | last post by:
Hi We have this access application - which we use to register stuff into. Most of the time we're online, and that's all right, but now we need be able to register stuff offline, and then it...
8
by: colin | last post by:
Hi, this probaly isnt the most relevant place to ask this, but Im using a windows forms in c# timer to process user input and invalidate a window if its changed. Im having problems in that the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.