>>>>I posted something similar not too long ago, but this has become an issue for me again.
>>>>
>>>>I'm the sole VFP developer a my company. No one else here has eny experience in VFP.
>>>>
>>>>In my DB there are views for almost every table. When I need to make a change in the DB, I write a small
>>>>PRG that can be run at the client site.
>>>>
>>>>The problem is the views. As soon as I change a table, the views are wrong. I need to come up with some way of updating the view that is simple enough for a non-VFPer to handle without my assisntance.
>>>
>>>Stonefield Database Toolkit does this really nicely.
>>
>
>So, are they going to be making structural changes? Or, you are changing the table and they need to sync the views? Can't you ship them the database container w/the views as well? Sorry, I'm a bit confused as to the usage here.

I am doing the changes to the DB as I make changes to the app.

The problem is how to update the database on the client site without me. Our QA department will be publishing the changes to the client site, including the database changes.

You mentioned copying the DBC. If I create a scipt to alter the table, then if I change the view, can I just copy the DBC over to the client site?