Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best Way To Update A View
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01314489
Message ID:
01315422
Views:
16
>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?

This is exactly why I'm using SDT - you ship the client the DBC plus a few meta tables. SDT includes a simple (one method call) way of then synchronizing the local database with the shipped changes. It automatically adds any new fields, new indexes, new views, structural changes, etc. I don't need to write any code to do this.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform