Deploying Visual Foxpro Solutions

by ; ;
Edition: 2nd
Format: Paperback
Pub. Date: 2004-06-01
Publisher(s): Hentzenwerke Pub Inc
  • Free Shipping Icon

    Free Shipping On Orders Over $35

    Your order must be $35 or more to qualify for free economy shipping. Marketplace items, eBooks and apparel do not qualify towards the $35 purchase minimum.

List Price: $49.95

Buy New

Usually Ships in 2-3 Business Days
$49.90

Rent Textbook

Select for Price
There was a problem. Please try again later.

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Ship it! Music to your ears or words that cause a cold sweat as you realize you now need to deploy the solution you have worked on for so long? Have you planned the deployment? Do you have the proper language in your contract with your customer? Do you have the proper install package? What media is the package going to be shipped on to the client? How will it be distributed? What happens after Setup.exe finishes? Do you have the support infrastructure in place? How are you going to handle updates and changes? There's a lot to think about, and deploying a solution requires careful planning. These questions and many more are answered based on real world experience within the pages of this book.

Author Biography

Rick Schummer is the president and lead geek at his company White Light Computing, Inc., which is headquartered in southeast Michigan, USA. He prides himself in guiding his customers' Information Technology investment toward success. He enjoys working with top-notch developers; has a passion for developing software using best practices, and for surpassing customer expectations, not just meeting them. After hours he writes developer tools that improve productivity and occasionally pens articles for FoxTalk, FoxPro Advisor, and several user group newsletters.

Rick co-authored Hentzenwerke Publishing's MegaFox: 1002 Things You Wanted To Know About Extending Visual FoxPro and the award-winning 1001 Things You Wanted To Know About Visual FoxPro (KiloFox) with Marcia Akins and Andy Kramek.

Rick is a Microsoft Most Valuable Professional (VFP) and a Microsoft Certified Professional. He is founding member and Secretary of the Detroit Area Fox User Group (DAFUG), and he presents at user groups across North America, and at the GLGDW 2000-2003, EssentialFox 2002-2004, Southwest Fox 2004, and VFE DevCon 2K2 conferences. He spends his free time with his family, cheers the kids as they play soccer and compete in robotics competitions, has a volunteer role with the Boy Scouts, and loves spending time camping, cycling, coin collecting, reading, and cooking breakfast on Sunday mornings.

Rick Borup is owner and president of Information Technology Associates, a professional software development, computer services, and information systems consulting firm he founded in 1993. Rick earned BS and MBA degrees from the University of Illinois at Urbana-Champaign and spent several years developing software applications for mainframe computers before turning to microcomputer database development tools in the late 1980's. He began working with FoxPro in 1991, and has worked full time in FoxPro and Visual FoxPro since 1993. Rick is a Microsoft Certified Solution Developer (MCSD) and a Microsoft Certified Professional (MCP) in Visual FoxPro. When he's not sitting in front of the computer earning a living, he likes to spend time with his family traveling across the U.S. and abroad.

Jacci Adams is an independent consultant doing business as Lindsay-Adams Consulting in Louisville, Ohio for the past twelve years. Jacci holds a BE in Electrical Engineering from Youngstown State University. She has been developing systems with xBase languages since 1986 (yes, she even did a stint developing with FoxBase+ and FoxPro 2.x on Macs) and specializes in developing custom scientific, engineering, and medical database applications with Visual FoxPro. She is currently working with one of her long term clients to create an ASP.NET stock tracking tool.

She has been very involved with the Greater Cleveland PC User's Group (GCPCUG) for the past 10 years. She recently "retired" from an eight year stint as the Consulting SIG facilitator and main speaker and started a new .NET Web Development SIG. She co-facilitated the VFP SIG for 5 years, is still involved with them, but not as often as she would like. She is involved in the networking and marketing initiative of the Northeastern Ohio Software Association's (NEOSA) Business and Technology Group. She's also spoken at Tech Talks 2003, GLGDW 2002, DAFUG in 2001, CPVFUG in 2002, and various local user groups in the NE Ohio area. She has written a few articles for the GCPCUG PC Chronicles newsletter.

Table of Contents

Dedications iii
Our Contract with You, The Reader v
Acknowledgements xxi
About the Author xxv
How to Download the Files xxvii
Introduction xxix
Deployment Fundamentals
1(22)
What is deployment?
1(3)
Installation is only part of deployment
4(1)
Pre-implementation
4(1)
Implementation
5(1)
Post-implementation
5(1)
Why you should care (why it is so important to get it right!)
5(1)
Do I need a Setup?
6(1)
A basic checklist for deploying Visual FoxPro apps
7(5)
VFP Source Code issues
7(3)
Customer environment
10(1)
Application specific testing
10(1)
Network and Operating System issues
11(1)
General hardware requirements: What do you need physically besides VFP to deploy a solution?
12(2)
Can't avoid this: What you must include for deployment
14(2)
Can't touch this, or can you?
16(6)
Conclusion
22(1)
Planning for Success
23(32)
Computing Environment
23(17)
Workstation inventory
23(4)
OS Platforms
27(6)
Networking
33(2)
Database platforms
35(1)
Integration with other applications and technologies
36(3)
Internet connectivity
39(1)
Physical office layout
39(1)
Need to order new equipment
40(1)
Dealing with the unexpected
40(1)
Clients
40(6)
Dealing with customers
41(3)
Working with subject matter experts
44(1)
Talking to the real or end users
44(1)
Handling those ``special case'' customers
45(1)
Preparation
46(5)
Images
46(3)
EXE version details
49(1)
Training materials for end users
49(1)
Training materials for support staff
50(1)
Duplication
50(1)
User communication
50(1)
Determining ship readiness
51(3)
Requirements
51(1)
Feature sets
52(1)
Prototypes
52(1)
Preparing customers for testing
53(1)
Delivery dates
53(1)
Sign-on
54(1)
Conclusion
54(1)
Packaging the Installation
55(28)
When is it ready?
55(1)
Getting ready for delivery
55(9)
Testing
56(1)
Executable components
57(2)
Help
59(1)
Data conversion
59(1)
Visual FoxPro runtimes and dependencies
60(3)
Third party controls and libraries
63(1)
Organizing the setup
64(9)
Directories
65(2)
Installation schemes/feature sets
67(2)
How do you package the install?
69(1)
OS and third party components
69(1)
Utilities to consider shipping
70(3)
Delivery mechanisms
73(9)
Diskettes
74(1)
Zip/Jaz/SuperDisk disks
75(1)
Memory sticks
75(1)
CD-ROM and DVDs
75(3)
E-mail
78(1)
FTP
78(1)
Web site downloads
78(1)
Symantec's pcAnywhere
79(2)
Terminal Services and Citrix
81(1)
Conclusion
82(1)
Setup Tool Roundup
83(20)
What is a setup
83(1)
What features are available?
84(1)
What tools are available?
85(11)
ActiveDelivery
85(1)
Ghost Installer Studio
86(2)
Inno Setup
88(1)
InstaFox
89(1)
InstallShield
90(2)
Setup Factory
92(1)
Tarma Installer
93(2)
Wise Solutions
95(1)
Why are the current installer tools better than the VFP Setup Wizard?
96(1)
Deployment Tool Selection Process
97(5)
Products Considered
99(1)
Making the choice
99(3)
Conclusion
102(1)
Windows Installer Inside and Out
103(52)
Overview of Windows Installer
104(8)
The evolution of software installation
104(1)
The arrival of Windows Installer
105(1)
Windows Installer Design Objectives
106(3)
Working with Windows Installer
109(3)
Structure of a Windows Installer setup package
112(21)
Features and components
113(2)
Merge Modules
115(1)
Inside an MSI file
116(13)
GUIDs, GUIDs, everywhere a GUID
129(4)
Updates, upgrades, and patches
133(9)
New bits for old
133(1)
Small updates
134(2)
Minor upgrades
136(1)
Major upgrades
137(4)
Patches
141(1)
What happens when I run setup.exe?
142(7)
The setup launcher program
142(1)
MSIEXEC -- the Windows Installer executable program
142(4)
Install sequence
146(1)
Caching the MSI file
147(1)
Versioning rules during installs
147(2)
Some common problems and what to do about them
149(4)
Another version of this product is already installed
149(1)
The feature you are trying to use is unavailable
150(2)
I want my application to be available to all users
152(1)
The Windows Installer Clean Up Utility
153(1)
Conclusion
153(2)
Workstation and Traditional LAN Applications Step-By-Step
155(48)
Single workstation---Single-user
155(1)
Single workstation with multiple-users
156(3)
Local Area Network---multiple-user
159(1)
Stories
159(2)
General implementation issues
161(15)
Security
161(1)
Executables
162(3)
Data
165(1)
Configuration file (FPW)
166(1)
Temporary files
167(1)
Other configuration settings and Registry
168(1)
Runtimes
169(1)
Shortcuts
169(2)
ActiveX controls and COM objects
171(2)
Automation
173(1)
ODBC DSN
173(2)
FoxTools and other FLLs
175(1)
Help files
176(1)
Reports
176(8)
Native Visual FoxPro (FRX)
176(2)
Crystal Reports
178(6)
Generating a setup, step-by-step
184(14)
Step 1---Organizing your setup
185(2)
Step 2---Specifying files deployed
187(4)
Step 3---Configuring the target computer
191(1)
Step 4---Customizing the setup steps
192(3)
Step 5---Defining setup requirements and actions
195(1)
Step 6---Building the install package
196(2)
What can go wrong during a deployment?
198(3)
Implementation
199(1)
Application
199(1)
Environment
200(1)
Conclusion
201(2)
Client/Server Applications Step-By-Step
203(30)
Stories
204(2)
Performance is king
204(1)
Indexes still matter
205(1)
Security fundamentals from school of black and blue
205(1)
General implementation issues
206(1)
Installing a new backend database
206(9)
Restoring a backup
207(1)
Running a script to create the database and database objects
208(2)
Using SQL-DMO
210(2)
Data Transformation Services (DTS)
212(3)
MSDE vs. SQL Server
215(6)
Installing MSDE
221(2)
Database Administrators and security
223(1)
Generating a setup, step-by-step
223(7)
Step 1---Organizing your setup
224(1)
Step 2---Specifying files deployed
225(3)
Step 3---Configuring the target computer
228(1)
The rest of the story
229(1)
What can go wrong during a deployment?
230(1)
Implementation
230(1)
Application
230(1)
Environment
231(1)
Conclusion
231(2)
Release and Post-Release Tips
233(20)
Checklist/Instructions
233(1)
Test area
234(1)
Backups
235(1)
Runtimes
235(1)
Configuration files & registry
236(1)
Update structures and indexes
236(1)
Data conversion
236(1)
Test
237(1)
Notify the customer
237(2)
Technical support
239(3)
Communication mechanisms
240(1)
Frequently Asked Questions (FAQ)
240(1)
Help file
240(1)
Training
241(1)
Web site
241(1)
Considerations for small shops
242(1)
Post implementation
243(8)
Post-mortem review
243(2)
Customer follow-up
245(1)
Bug tracking
246(3)
Developer review
249(1)
Post release party
249(1)
Bonus pool
250(1)
Conclusion
251(2)
Support and Ch-Ch-Changes
253(20)
Support
253(11)
Recovering corrupt or lost data
253(3)
Visual FoxPro database structures and maintenance
256(2)
SQL database structures and maintenance
258(4)
Runtime command window
262(2)
Ch-Ch-Changes
264(8)
What needs to be updated?
264(2)
Update architecture
266(1)
Version numbers
267(1)
Upgrade installs
268(3)
Uninstalling
271(1)
Conclusion
272(1)
Security
273(14)
Data security
273(1)
Application security
274(1)
Source code security and decompilers
275(10)
How we tested the decompilers
277(1)
ReFox MMII
278(2)
yRecover
280(2)
Others
282(1)
HTML Help files
283(2)
Conclusion
285(2)
The What and Why of `Wares
287(12)
What is shareware?
287(2)
What is freeware?
289(1)
Demoware
290(1)
Crippleware
291(1)
Nagware
292(1)
What is vertical market?
292(1)
What is custom?
293(1)
Prototype---friend or foe?
294(1)
What is limited licensing?
295(1)
Deployment and support considerations
296(1)
Conclusion
297(2)
Legalese
299(30)
Computer Law Terminology 101
301(1)
Intellectual property
301(1)
Copyright
301(1)
Creative/Original work
301(1)
Derivative work
302(1)
Work for hire
302(1)
Exclusive rights
302(1)
Copyrights for software developers
302(6)
Securing copyright
302(1)
Length of protection
303(1)
Transfer of copyright
303(1)
Exclusive rights
304(1)
Fair Use
305(1)
Digital Millennium Copyright Act of 1998
306(1)
Display the copyright in the software and during installation
306(2)
The contract
308(3)
What is a contract?
308(1)
Why do we need a contract?
308(1)
Who should supply the contract?
309(2)
What could go wrong with a handshake?
311(1)
Contract clauses
311(1)
The static contract clauses
312(9)
Parties
312(1)
Ongoing support
312(2)
Ownership--who owns what?
314(1)
The five types of program code
314(1)
Source code options
315(1)
What are my licensing options?
315(2)
Confidentiality
317(1)
Non-Compete
317(1)
Guarantees
318(1)
Client responsibilities
319(1)
Acceptance clause
320(1)
Contract termination methods
320(1)
Settling disputes
320(1)
Severability
320(1)
Extension conditions
321(1)
Governing law
321(1)
The dynamic contract clauses
321(2)
Definition of services
321(1)
Project scope
321(1)
Payment schedule
321(1)
Exceptional expenses
322(1)
Support clause
322(1)
Licensing issues
323(2)
Licensing your product
323(1)
Per user license
324(1)
Per machine license
324(1)
Volume licensing
324(1)
License enforcement
324(1)
Licensing third party products
325(1)
Summary
325(1)
Top 5 lessons learned
325(1)
Links
326(1)
Conclusion
326(3)
Appendix A: How To: InstallShield Express
329(40)
What is InstallShield Express?
329(1)
How do I install InstallShield Express?
329(3)
Installing ISX VFP LE
330(1)
Installing the VFP runtime redistributable files
331(1)
Upgrading from ISX VFP7 LE to ISX VFP8 LE
331(1)
InstallShield Express---Visual FoxPro Limited Editions
332(2)
VFP 7 Edition
332(1)
VFP 8 Edition
333(1)
InstallShield Express---Full Version
334(1)
Creating a setup package with InstallShield Express
335(25)
The Sample Application
335(1)
Creating a new InstallShield Express project
335(7)
Using the InstallShield Express IDE
342(14)
Building the setup package
356(2)
Deploying the application
358(2)
Creating a patch with InstallShield Express 4.0
360(6)
Overview
360(1)
The QuickPatch project wizard
361(1)
The QuickPatch IDE
362(4)
Deploying the patch
366(1)
Conclusion
366(3)
Appendix B: How To: Wise for Windows Installer
369(36)
What is Wise for Windows Installer?
369(1)
Creating a setup package with Wise for Windows Installer
369(25)
The Sample Application
370(1)
Creating a new Wise for Windows Installer project
370(1)
Using the Installation Expert
371(1)
Project Definition group
372(4)
Feature Details group
376(14)
Release Definition group
390(4)
Building the deployment package
394(3)
Compiling the project
394(1)
Testing the setup
395(1)
Running the setup
395(1)
Distributing the setup
395(2)
Upgrades and patches
397(6)
Creating an upgrade
397(3)
Creating a patch
400(3)
Conclusion
403(2)
Appendix C: How To: InstaFox
405(24)
About InstaFox
405(1)
What is the InstaFox Wizard?
406(1)
What is the InstaFox Installer?
407(1)
Creating a software installation process with InstaFox
407(1)
Installation Folder Setup
407(2)
The InstaFox Wizard
409(10)
The InstaFox Wizard Table Structures
419(2)
Installing the Application
421(4)
Welcome screen
422(1)
License Agreement
422(1)
Destination Directory
423(1)
Application Shortcuts
424(1)
Additional Tasks
424(1)
Selected Installation Options
424(1)
Cancelled Installation
425(1)
Post Installation Information
425(1)
Customizing InstaFox
425(3)
Customizing the InstaFox Installer
425(2)
Customizing the InstaFox Wizard
427(1)
The InstaFox copy file behavior
428(1)
Resources
428(1)
Conclusion
428(1)
Appendix D: How To: Inno Setup
429(26)
About Inno Setup
429(1)
Creating a new Inno Setup script
430(6)
Structure of an Inno Setup script
436(5)
Setup section
438(1)
Tasks section
438(1)
Files section
439(1)
Icons section
439(1)
Run section
440(1)
Other sections
440(1)
Adding the VFP runtime libraries and other dependencies
441(2)
Completing the script
443(2)
Compiling the script
445(1)
Installing the application
446(7)
Welcome screen
446(1)
License agreement
446(1)
Information before install
446(2)
Destination directory
448(1)
Start menu folder
448(1)
Additional tasks
448(2)
Ready to install
450(1)
Information after install
451(1)
Setup completed
451(1)
Silent installs
452(1)
Pascal scripting
453(1)
Resources
453(1)
Conclusion
453(2)
Appendix E: Third Party Tools
455(8)
FoxBox
455(1)
HTML Help Builder
456(1)
Icon Editors
456(1)
Axialis IconWorkshop
456(1)
IconStudio
456(1)
Image Editor
456(1)
Microangelo
457(1)
Image Editors
457(1)
Corel Draw
457(1)
Digital Image Pro
457(1)
Image Composer
457(1)
Image Composer
457(1)
Paint Shop Pro
457(1)
Photoshop
457(1)
Windows Paint
458(1)
Partition Imagers
458(1)
Drivelmage
458(1)
Ghost
458(1)
MSDE Admin
458(1)
PcAnywhere
459(1)
Recover
459(1)
Screen Capturing
459(1)
HyperSnap-DX
459(1)
PrintKey-Pro
460(1)
Snaglt
460(1)
Stonefield Database Toolkit
460(1)
Text Editors
460(1)
EditPlus
461(1)
TextPad
461(1)
Time Zone Clocks
461(1)
ClockRack
461(1)
ZoneTrekker
461(1)
Windows Installer SDK
462(1)
WinZip
462(1)
VMware Workstation
462(1)
Conclusion
462(1)
Appendix F: Support Forums
463(4)
CodeBook
463(1)
Codemine
463(1)
CompuServe's MSDevApps Forum
463(1)
dFPUG Portal
463(1)
Fawcette Technical Publishing (DevX)
463(1)
FoxForum.com
464(1)
Fox and SQL Server Wiki
464(1)
Foxite
464(1)
Inno Setup
464(1)
InstaFox
464(1)
InstallShield Support Forums
464(1)
InstallSite
464(1)
Mere Mortals
464(1)
Microsoft Newsgroups
464(1)
Microsoft Knowledgebase
464(1)
Microsoft VFP Site
465(1)
OpenTech
465(1)
PortalFox
465(1)
ProFox List Server
465(1)
Tarma Support
465(1)
Tek-Tips
465(1)
UniversalThread (UT)
465(1)
Visual Extend
465(1)
Virtual Fox User Group (VFUG)
465(1)
Visual FoxExpress
465(1)
Visual MaxFrame Professional
466(1)
Visual ProMatrix
466(1)
West Wind Technologies
466(1)
Wise Solutions
466(1)
Conclusion
466(1)
Appendix G: How to Copyright Code
467
Why Register
467
Step 1
467
Step 2
468
Step 3
468
What form do I use?
468
Deposit requirements
468

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.