conflicts: insert on 2 systems
- From: jens@xxxxxxxxxxxxx
- Date: 5 Jun 2005 09:22:17 -0700
Hello NG,
today i have a question referring to the implementation
of a replication solution:
in our company we use an ERP system which contains an ecommerce
module (a webshop) based on data in this erp system.
The webshop is programmed in ASP and uses dlls of the ERP system
for accessing and manipulating data in the ERP database (creaing orders
And new customers).
The data is stored in a MS SQL Server 2000 database.
Location of the firm: Egypt
Server location (database, application server, www server): USA
The employees use a RDP connection to work directly with client
programs
on the server which is slow, unreliable (internet connection is very
instable in Egypt)
and insecure.
So our idea was to split the system into a main productive system and
an ecommerce
System (for providing data for the shop and storing new orders/new
customers):
1. productive system with own database in Egypt
= main system for purchasing, accounting, creating phone orders
2. ecommerce system (website + own db) in USA
= system for providing data for the shop and storing new web orders/new
customers
=> musst be in USA because there is no hosting company in Egypt with
reliable connection and a sure availability of the web shop
so the aim is:
to store new web orders in the database of the websystem in US but
transfer them as soon
as possible (immediately) to the main system (Egypt)...if the
connection is broken
then at the next possibly point of time.
At the end of the day the state of the main database should be
transferred to the web system.
Problem1:
we cannot change something at the ERP system or at the webshop itself ,
so we only can work with the possibilities of the sql server.
(replication, trigger, stored proc., dts,..) and we have no adequate
documentation
(e.g. data model,...)
Problem 2:
- for implementation of a replication in SQL Server we will need an
additional
column GUID for each tableà could this affect the functionality of the
ERP system?
and would it make the system much slower?
PROBLEM 3:
- there can be created orders in both systems (phone orders in main
system and web orders
from the websystem) but they will get a order number at the point of
their creation
...and this number must not be changed ..NEVER !!!
=> but if both systems have for some time no connection (because the
internet connection in Egypt is not working) then it could be that a
web order is created with number 171 and
in the main system a phone order is created with 171....and that is not
allowed!!!!
= = = > this is the biggest problem, how can we avoid this?
Is it only possible to implement a replication for an application which
is prepared by the
programming for this purpose?
Thanks for your help!
JENS
.
- Prev by Date: Re: Strange problem while investigating
- Next by Date: Foreign Keys and Replication
- Previous by thread: caveats for synchronous hardware based replication?
- Next by thread: Foreign Keys and Replication
- Index(es):
Relevant Pages
|
