Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: pratap adhikary
  Where is pratap adhikary?
 jabbalpur
 India
 pratap adhikary
 Tags
Subject: RE: DBF record transfer over to intranet SQL
Thread ID: 416304 Message ID: 416310 # Views: 70 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: ODBC, ADO and OLEDB
Date: Friday, December 26, 2014 4:04:07 PM         
   


> Hi Experts,
>
> What is the best approach to transfer DBF data to SQL server(single instance) remote location,
> I'm also concerned with data security .
>
there are 400 customers and their data to be transfer to SQL server separate DB(but single instance)
>
> if any one could give some light on this topic, would be great help.
>
> Regards
> Pratap



Hi Pratap,

Prior to answering your question is the data being transferred to the SQL Server in real-time?
That is during records being update, added or deleted at the remote sites.

or

Is this more like a day end process where the data needs to be sent up as a batch process all
at once and processed?

Pete "the IceMan", from the Great White North of Canada.
www.marathongriffincomputers.com

ENTIRE THREAD

DBF record transfer over to intranet SQL Posted by pratap adhikary @ 12/26/2014 2:52:09 PM
RE: DBF record transfer over to intranet SQL Posted by Pete Sass @ 12/26/2014 4:04:07 PM
RE: DBF record transfer over to intranet SQL Posted by pratap adhikary @ 12/28/2014 6:51:44 AM