Walter Meester
HoogkarspelNetherlands
I can tell you what we do. We've got an application that runs both on VFP and SQL. We make the changes in the dev VFP database, run a routine that puts the database structure into a table, which will be compiled into the EXE. Once run on the SQL server, it will update the SQL database according to that.
>I can tell you what happens at one of the projects I do now, Java/SQL. Whenver a developer makes a schema change to the database, they add to a script in Sourcesafe that contains any necessary changes.
>
>This script becomes part of the upgrade process. It will contain any alter statements necessary. For example, the last upgrade we did I needed to add a field to the state table that contained a code for IRS 1099 processing. So I created added to the script the alter statement to add the column, as well as the update statements to populate the column according the IRS 1099 document.
>
>>What process do you follow and how painless is it to update a client's sql express database (new fields, new tables, ...) as new versions of the app are released, similar to what Doug's Stonefield product does for VFP databases?
>>
>>>My point was (and is), that on a new project, I would not chose VFP tables as my backend DB, even for a small app. I'd use sql express. I used it twice last year and was happy with it. I'm disappointed with the provider for VFP, and I miss out on the t-sql '05 constructs that yield additional productivity.
>>>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only