Friday, February 17, 2012

Design help needed

Hi, hoping someone cangive me a heads up on best sysyem to employ to manage thisscenario.Sorry if this is not the correct forum to post in.
Our primarysoftware is a standalone VB6 app used by some 50 clients, each withthier own MSDE backend. Their business basically is Packing anddistribution of fresh produce. Each of our clients have multiplesuppliers on which they have data stored.
I have decided to writea web app (VS2005) that will allow the supplier to enter criticalinformation about produce quality, testing etc. This data will be kepton our local webserver database.

My use case scenario is thatwhen a supplier enters a new record via web page I can somehow update the PackersSQL database via internet, http,tcp.Ideally I imagine a trigger on our server db can connect to their databaseover WAN. HOW??

The packer must also be able to addsuppliers to our server db. As they already have that data storedstored at their end I was hoping to have a web page with drop downlists that accesses their local db and, upon Save, updates ourwebserver ddb. Thereby saving them the need to manually enter thedata twice. I know this is a little long winded but I'm new to .Net andweb programming so have no idea on the simplest and best method to dothis.Any help greatly appreciated.Hi,

You can make replica of tables in ur system and supplier system and update or insert data in both server in a single move.
http://www.easerve.com/developer/tutorials/asp-net-tutorials-adding-records-database.aspx

Trigger is other option available to you.
For trigger help
http://www.sql-server-performance.com/nn_triggers.asp|||

There are loads of ways - depends also on how you want to manage enterprise wide transactions.

Suggestions :-

Synchronous(ish)

Web service at the packers end to manage updates to their database. You interact with this to update their system, then update yours if you get an OK return.

TCPIP. Connect your database to their MSDE via the internet. Suggest an encrypted pipe and decent router set up.

Asynchronous

Message Queues (MSMSQ).

No comments:

Post a Comment