On Wed, Mar 10, 2010 at 10:56 AM, MB Software Solutions, LLC > 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. ----------------------------
How many tables and what volume of rows do you think that need to be sent? What level of frequency, daily to monthly? You need a loader app for the retail sites, and a webpage makes the most sense. They log in and that defines who they are. the web page can pull the local vfp data? mmmm I wonder how I would do that? I know that I can pull images so it is just a have to do it kind of thing. Maybe it might be better if this were a Winform app that does have good roots in getting local vfp data easier??? anyway the app will pick up the data and pass it to the WCF. The code in the wcf knows what the Data miners what to do and just does it. I bet that will be real dicey, because rules are rules! could yo ust insert into a loader SQL table and they write their own SSIS scripts to put into the DW? That woudl be the best bet from my limited knowledge so far. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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.
