>>You're the boss of course, but I thought that if your tables already existed in your sqlserver, then all this would take is a scan through your vfp table, a scatter memvar and an insert into sqlservertableview from memvar.
>>
>>You could even do that automatically by scanning through all you tables.
>>
>>Not sure what you and dragan mean by "maintenance" of views though, especially since this is a "on time" thing.
>
>Changes in table structure. You change the table, you need to recreate the view, set five or six properties for each added/changed field... maybe not as much work, but extremely easy to forget something somewhere and create a new, hard to track, bug.
Not really, each view has a function that creates that view
When I change a table that has one or more views on it - I recreate all my views in the order that they were created
Reason to recreate all views is that some views are using other views
Gregory