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 |
|
Delinda
Constraint Violating Yak Guru
315 Posts |
 Posted - 2010-12-15 : 22:34:31
|
| Hi,Currently, my database logical view as follow1. ERP database server on 192.168.1.22. WMS database server on 192.168.1.33. TMS database server on 192.168.1.4How ERP, WMS and TMS communicate each other?1. ERP will insert the data into IntegratedDB on ERP database server2. Then, WMS database server and TMS database server will do the pickup from IntegratedDB and inserting/updating IntegratedDB respectively3. Finally, ERP will query back from IntegratedDB and updating ERP database respectively*IntegratedDB on 192.168.1.2*Looks like IntegratedDB is a middle databaseFYI, there's no integration tools such as MSMQ, SSIS, SQL Service Broker, AS2 and so on was used.Recently, this was happen1. The data appear in ERP Database2. The data appear in IntegratedDB3. The data appear in WMS Database4. But, the data not appear in TMS Database*At this level, looks like the data was imbalance*At this level also, there's no guaranteed deliveryOnce the problem was rectified, looks like TMS Integration Component was corrupted. I saw, this database integration architecture have no rollback capability.My humble opinion, if any of the database partner in this database integration architecture have a problem, all the database should fallback as a usual.My question as follow1. Did this database integration architecture is acceptable?I hope someone can give the comment. As a result, I can plan to fixing the current weaknesses in a proper manner. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-16 : 00:37:00
|
| How does the data get from one to the other?How do your components know when to do their thing?It's a bad idea to put your servers on 192.168.1.xxx |
 |
|
|
Delinda
Constraint Violating Yak Guru
315 Posts |
Posted - 2010-12-16 : 05:24:15
|
| Sir,All the data get from IntegratedDB. The integration component will picked up the data from IntegratedDB periodically. Let's say, 2 sec. This integrated component always runningI'll take a note It's a bad idea to put your servers on 192.168.1.xxx |
|
|
|
Delinda
Constraint Violating Yak Guru
315 Posts |
Posted - 2010-12-18 : 06:40:22
|
| Really need the comment |
|
|
|
|
|
|
|
|
Send and Receive Data across Instances and Servers