Rod,

xCase is similar to SDT (but different) in that it will generate a change script for your database from your old version to your new version. You can then deploy this script on your customers database. Of course, if you are stupid, like my team is, your application allows users to modify the database (add fields/tables) so the above won't work.

BOb


>>>I'm still in the process of prototyping an application with several clients and have found that I need an easy way to:
>>>1) build a distribution
>>>2) build an update for an existing installation
>>>
>>>What are people currently doing that are using the framework?
>>>
>>>TIA,
>>>
>>>Rod Lewis
>>For both, we're using Wise InstallBuilder. It's especially good for taking care of the smaller updates;"SmartPatch," I think, is Wise's term.
>>
>>As far as the DBCs, we use separate ones for each client and a "common" one for most MM tables. We're up to 7 distinct dbcs, and soon to go over 10. Stonefield is invaluable for keeping them in sync!
>>
>>Good luck with the prototyping...
>>---J
>
>Thanks for the reply. I'm placing an order for Stonefield SDT on Monday. Have you done any work with SQL Server, and if so, what do you recommend on that side? We are preparing this particular project for SQL Server, so we haven't had much experience with what, if any, sort of tools are built into it.
>
>Rod Lewis