Stephen Russell wrote: > The problem: Corporate doesn't want to expose a database on the web. > They'd rather I use a web service and have that be the public-facing > object. I don't know DotNet but am very good with VFP9, and I need this > to come up quick (within 2 months), > > Other: Target/Backend database here at Corporate can be a SQL Server > 2005 database or VFP9 (most likely free tables). > -------------------- > > Seems like there is no direction on what the storage is going to be at > this point. Target is going to be SQL Server? Will they need to > have a separate db for each retail location? Will it have a single db > and everything identified by a column of ownership? No biggie here. > It will need a lot of code as a guess. > > This is what Web Services was designed to do. Exposing corporate data > to whomever they want. Corp is now in control of WHAT is going in and > out and they can control GIGO at the onset. > > Just passing tables is well pretty lame especially when PKeys may be > duplicated. That becomes the real show stopper for why the just pass > a table is a potential for real problems. > > Could this functionality be done in VFP in making a WS ? I am sure it > could. Can it be secured? Somehow I am sure it can, how it is done > hmmm???? > > Why would you want to send duplicate data time and again? > > I know that a former boss did this all in WestWind back in the 98-99 > on all transactions hitting the local tables were also sent to > corporate. >
Steve, It's a one-way send from centers to Corporate. It's a new data feed going every time, so we're not sending duplicate data. No need to make this harder than necessary. It's a simple one-way flow of new data. I don't want some interim steps requiring unzipped and/or further processing. I just want the data sent from the center app to the Corporate db. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
