sql server dts: Required bandwidth to DTS from VFP to an offsite SQL Server -- sql server dts

Required bandwidth to DTS from VFP to an offsite SQL Server

jim_sweeney NO[at]SPAM hotmail.com
3/28/2005 12:01:19 PM

sql server dts:

We have a DTS package that loads VFP data into a SQL Server on a
separate machine on the same network. This process takes ~12 minutes
and involves many of the records in many VFP tables (1.3GB). Our CIO
has expressed an interest in moving our SQL server to a remote location
and keeping our Visual FoxPro server onsite.

1) Does anyone know if there is a way to calculate the amount of
time/bandwidth required to transfer this amount of data if we move
offsite? We'll have the equivalent of four T1's of bandwidth
available to us.

2) Also, if this DTS approach would be impossible after the move, how
much faster would bcp'ing the data be?

3) Does MS have recommendations about this issue? I wasn't able to
find anything on the site.

If I don't hear from anyone, I'll just start testing. Thanks."

Re: Required bandwidth to DTS from VFP to an offsite SQL Server

Allan Mitchell
3/29/2005 8:01:53 PM

I would do your testing. Although you may have the equivalent of 4* T1 lines between sites, are they dedicate to your process? A
quick test would be to fire a smaller amount of VFP data down the wire and multiply the time taken as necessary.

Would BCP be faster? Maybe.

What about Exporting to text file - Zipping - sending - unpacking - bulk inserting

I think the name of the game would be to test.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

[quoted text, click to view]