SCENARIO
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. ANALYSISThe 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. |