Glen, Good thoughts here as always, thanks. Right now, the UV db is not fully replicated to the MSSQL tables, rather the other way around (for the most part). The ISAM WCS tables also update UV. Therefore, at present, the UV db comes closest to being the reference, and it still runs the business. The main thing, as mentioned, is trying to bring some batch processes into real time, especially those that hinder global commerce. Some of this will have to be resolved with code, others may be helped by some of the good contributions to this thread.
thanks much, -Baker <snip> OK. So use the existing MS SQL server as your reference point. You don't _have_ to put another data store in the mix. I'm definately no SQL expert, but can't SQL views and stored procedures be used to blend tables and provide the proper updating and reference paths/points for the UV and the ISAM DB by themselves? The suggestion of the additional MySQL/MS SQL server was to serve as a live multi-point data store, but now that I think about it you would be able to get the same results with what you have. </snip> ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
