Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davidpardoe
Constraint Violating Yak Guru
324 Posts |
 Posted - 2001-07-18 : 11:15:23
|
| We have a VPN set up between offices in the USA and UK that allows us to link the SQL Servers at each end. If there is a table on the UK server which we wish to transfer to the US server (via DTS or whatever) is there any way of compressing the data as it travels across the VPN. Pre VPN the files were FTP'ed as compressed ASCII files (the files compress to about 20% of uncompressed size.The uncompressed files can be 200+ Mb (and even up to 3Gb). I know the statistical analysis package SAS (does more than stats now!) can handle this concept of compressing "working" files. It just means processes against the data can take longer.Any thoughts out there? |
|
|
|
|
|
Compression of data files?