>I've developed an VFP7 application using MS-SQL-Server database.. This software has more than 200 installations. Now there is a very tedious taks to give an update of the software to all clients because it needs some structure changes in the database.
>
>So, is there any provision to automate the task of structure comparision from within the application itself. keeping in mind, I have the complete SQL script of the basic data. Is there any provision to create an SQL script of the differences and the like..You could write a setup pogram using
ALINES()
and
ALTER TABLE
to insect and modify table structures on site. Or you could do yourself a favor and use Stonefield Database Dictionary (SDT) that does it for you plus many other things.