Very Computer

I'm working on a SQL Server 7 project.

There's a development box with dummy data and a production box with
real data.

When I make a change in a table ( such as changing an int to a
smallint ) on the develoment box I would like to be able to make that
change happen on the production box also.

I tried to use the "export Wizard" from the devt to the production box
but weither all data on the destination box are erased or replaced by
the data which where on the source box.

My question is: is there a way to export the changes from a develoment
box to a production box without altering the data on the production
box ?

Thanks a lot ...