Case Study: Porter Steak Company


SCENARIO

ESSENCE OF THE CASE

Here are the essential elements in this case:

  • Install SQL Server.

  • Move existing data.

  • Fix the user program and web site.

  • Write a query that can create XML to send to vendors .

The Porter Steak Company is a nationwide gourmet foods distributor with offices in Des Moines, Iowa. They ship frozen gourmet steaks, fish, and some side dishes across the country and around the world. Their business is booming thanks to their new web site, so they need to move up to something a little faster than the FoxPro application they are currently using. They'd also like to be able to send XML transaction streams to Super Parcel USA, their shipping vendor, and to other vendors.

ANALYSIS

The first step is to get SQL Server up and running, then use the Import/Export wizard in DTS to copy all the data over into SQL Server. Fix up the web site so it can talk to SQL Server via ODBC instead of using FoxPro via ODBC, and the user interface should be ready. Then schedule a query to run periodically to create an XML document that can be sent to vendors.



MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 228

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net