George,
>DD,
>
>I wanted to jump in here with a note about scripting. As usual, my friend Ed, has probably given you what you wanted to know. I felt, however, that it might be helpful, if not to you, then to perhaps some lurkers, if I gave an example of the power of scripting. The power comes from its ability to manipulate OLE Automation servers.
Righto..
My issue is more one of consistent deployment and am I able to do this without having to resport to limiting our software to >= W98 O/S's. Personally I don't have one whit of problem with this but it is still something that affects the business decision process here and probably will for some time.
>
>Recently, I was given the task of seeing if I could automate the creation of SQL server scripts that could recreate a database and all its objects. This is a feature that's provided in the SQL Server Enterprise Manager, and is basically used for protecting the database against a catasprohic event. While it's a fairly simple process within the Enterprise Manager, it is time consuming and requires that a strict schedule be maintained. Certainly, it would be far easier to use the task scheduler to handle this chore automatically.
>
>I started work (from within VFP, BTW, Intellisense really helps< s >) and figured out basically how to create a script that could generate one object, and also figured out how to manipulate each of the objects to accomplish the task. It was a bit more complex than I had hoped, in that I would end up with a script for each object rather than a single one. Before RTFMing, I decided to privately ask a couple of folks on this forum if it were possible, and Larry Miller (thanks again, Larry) not only said it was, but showed me how as well.
>
>The number of actual lines of code? Ten. To me, that's both powerful and cool.
What are some good books/sources to get one's self up to speed here? Thanks!!!!!
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.