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 |
|
uberman
Posting Yak Master
159 Posts |
 Posted - 2004-07-16 : 05:33:04
|
| This has just landed on my plate and I am not sure where to start.2 DatabasesDB A. Internet facing, allows the updating of content pages; displays reports on access metricsDB B. Intranet machine, publishes the pages; logs access metricsI need to transfer content data from A -> B and access data from B -> ABUTThe machines will NOT be allowed to talk to each other, all transfers have to take place outside of SQL Server (I am pretty sure that I wont be able to use the FTP in DTS).My only mechanism is FTP (we will also be transfering/synch'ing image data but that is just a folder problem).Any ideas on where I start? I thought of having 2 Access MDBs, scheduling writes and reads to them from the sql boxes and then transfering the mdb's via ftp.This has to happen daily, althought it could be in a number of steps; and I **might** be able to use a specific software tool...Any ideas... (I've already tried sobbing uncontrollably, and have had a nice hot cup of tea). |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-07-16 : 06:59:48
|
| If you cannot FTP via DTS, would you be allowed to do xp_cmdshell of bat files to do the FTP ?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
uberman
Posting Yak Master
159 Posts |
Posted - 2004-07-19 : 10:29:59
|
| Probably not...At the moment I have been told that ftp will be automated to sync a couple of folders on each machine...SQL Server will have to drop to and read from those sync'd folders, hence my idea of using an .mdb as an intermediary?????? |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-07-19 : 10:32:21
|
| If the data will be synch'd then just schedule a sql job to read the folder...Corey |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-19 : 16:34:40
|
| I think (ok, only rarely) that you're looking for bcp....Brett8-) |
|
|
|
|
|
|
2 Way Data Transfer -- No Direct Connection