Have a look at http://www.red-gate.com/sql_compare.htm

>Hi,
>
>I'm somewhat new to SQL2000. I deployed my app from my SQL2000 to my clients site via BACKUP and RESTORE commands. That seemed to work great. I now have made a bunch of table modifications, added/changed/delete fields from my development SQL2000. When using Foxpro I've always used SDT to update my clients data structions. How can I update my clients data structures with SQL2000?
>
>
>Thanks for your help.
>
>Steve