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 |
|
toothkiller
Starting Member
1 Post |
 Posted - 2011-02-24 : 17:01:11
|
So I am new to MS SQL 2008. In fact, I was hired as a c/c++ programmer and have been using SQL since I got here  . What doesn't make sense to me is that the company I work for uses SQL 2008 and has a program it sells that uses sql internally but when updating data to the client there is no direct connect.Heres what we do:Take a file from our database, upload to ftp server, download it on clients machine, then bulk import from file.Heres what I think should work:Since we have access to both the client machine (via logmein or an equivalent), shouldn't we be able to connect to their database and our database with MS SQL 2008 and just run a single insert?Maybe I'm thinking of it wrong but it just seems that we should be able to link up to both. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-02-24 : 17:43:41
|
| It's probably a security issue, like a firewall setting. LogMeIn works through a proxy, not a direct connection. SQL Server would not be able to work through that proxy, and even if it could, moving a lot of data over a linked server can be very inefficient, especially compared to a text file and bcp.There are a number of audit and certification requirements (PCI, SAS70, HIPAA) that restrict network exposure, especially to off-site locations. They require either zero access, or strict VPN-only, encryption, etc., and can revoke such certification if violated. Losing certification could open a company up to legal action, above and beyond any actual security breach. Even using a proxy like LogMeIn may violate it.Spend a few minutes on Google for things like HBGary, ChoicePoint, TJ Maxx, SQL Injection, and you'll understand why convenient network access is not always a good thing. |
 |
|
|
|
|
|
|
|
Info on remote server