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

Take a look at http://apexsql.com/sql_tools_diff.asp. you can download fully functional trial version.