Re: Data Transfer Question

So, anyway even without a VPN you'll need to collect the data and that's still step 1. I might consider storing the data in a local SQL Server Compact database and simply sync with a remote host. If you can't connect to the host, then building a structure to send to an XML web service is probably not a bad idea. I would try to figure out how to serialize the data in something other than XML to make the performance a bit more tolerable.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Guy" <Guy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:4F8BFEBE-FCE5-4F75-9D7B-D82BFF711E7B@xxxxxxxxxxxxxxxx
thanks for the info.

i understand a VPN connection would be necessary when security is a vital
aspect. but, the solution i'm developing is in the sportssector atmosphere
where the data to be transfered is not really "sensitive" information.
Besides that it would be not possible sending the is data by using a VPN
connection, because the data is hosted with an normal ISP. So, integration
services would be no option either (since an ISP normally doesn't provide
these options with most service-plans). Maybe afterwards when setting up my
own environment (=server, etc.) VPN and integration services would be a
possible option.

regards,

Guy

"William Vaughn" wrote:

Over the Internet? Without a VPN? I assume you're not concerned with data
security. I would concentrate on this in phases. First, I would get the
data transported to the server in a form that's packaged as an atomic unit
(as a single file) that either gets transferred or not. Next, I would focus
on importing the data into the local SQL Server database using SSIS, BCP or
SqlBulkCopy. Next, I would run one (or more) stored procedures to process
the incoming rows. This would include validation as well as posting the data
to appropriate tables.

If you were using a VPN connection, it would be a lot easier. You could use
ADO.NET 3.5 Sync Services to import the data and keep both ends in
sync--even to a MySQL database. This would deal with most (if not all) of
the unstable network issues for you.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Guy" <Guy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4E14802B-C513-42AE-BDC4-245330290F37@xxxxxxxxxxxxxxxx
> I need to transfer on a frequent base (e.g. every 10 minutes or so will > be
> a
> parameter that can be set) for reporting purposes a subset (subset of
> records
> of a subset of tables) of data from a MySql db (on a laptop/pc) to a > Sql
> Server db (on a server) via te Internet. The number of records (or the
> size
> of the data) is not that much (maybe 5-10MB each time). During every > data
> transfer the new records must be added, modified records chnaged and
> deleted
> records deleted on the server db. I thought using a web service to > achieve
> this, is this a good solution or are there better alternative solutions
> (integration services on the laptop/PC would be no option, since I have > to
> minimize the the software to be installed on the pc/laptop)? I suppose
> lost
> Internet connections or other errors that might happen can be tackled > by
> using transaction?
>
> Thanks.


.

Relevant Pages

  • Re: TS vs VPN
    ... Using TS, w/o VPN ... The remote client connects to your local TS via Remote Desktop. ... "Foo" accesses the SQL server, which is nearby in a protected part of the network. ...
    (microsoft.public.windows.terminal_services)
  • Re: remote server
    ... client/server. ... Unfortunately, I can't use VPN. ... > when it comes to working with a SQL server. ... >>> what is the best way connect to remote SQL server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access to SQL over web
    ... >> technology that allows for VPN connections). ... >> connection and Windows 2000 pro/server Windows XP at the client end. ... >> authentication or RADUIS (what all the DSL providers use to authenticate ... >> One of the major problems of exposing a SQL server directly on the web is ...
    (microsoft.public.access.formscoding)
  • Re: remote server
    ... Thank you for your reply William. ... Unfortunately, I can't use VPN. ... >> a remote sql server over the internet and would like to find out what ... >> what is the best way connect to remote SQL server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Query Analyzer vulnerable thru Firewall?
    ... If the VPN isn't an option, ... >> Joe, ... >>> remote administration of SQL Server from my house via the internet. ... >>> on the firewall side. ...
    (microsoft.public.sqlserver.security)