Steven,

I'm using sqlCompare (http://www.red-gate.com/sql_tools.htm) for these kind of tasks. As the name indicates, the tool compares two databases and allows you to generate a script that synchronizes the databases. Very handy tool that has saved me many hours.

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