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 |
|
wkm1925
Posting Yak Master
207 Posts |
 Posted - 2010-11-08 : 20:14:53
|
| Hi,I've as follow1. ERP DB2. Warehouse Management DB3. Transport Management DB*All database using SQL Server 2005 Standard Edition (32 bit)All of this DB Server installed on their dedicated machine, and data in a SAN within LAN.How ERP DB push/pull data to/from Warehouse Management DB and instead?Answer: 1. ERP will generate XML files and place into a folder. Then, one special program (running continuosly using Task Schedule) will pickup this XML Files, process and insert/update/delete into Warehouse Management DB.2. Warehouse Management DB will generate XML files and place into folder. Then, one special program (running continuosly using Task Schedule) will pickup this XML Files, process and insert/update/delete into ERP DB.How ERP DB push/pull data to/from Transport DB and instead?Answer:Same technique as aboveMy most concern is, how if one or more my DB Server is offline? Based on my current Database Integration Architecture, I hope someone can comment. Right or wrong. |
|
|
|
|
|
Need comment on my Database Integration