>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.