Is there an easy way to update a stored procedure, without using the development environment?

I'm adding a table to the database. I have a stored procedure which opens and relates the tables. I want to update that procedure to open the new table. This operation may be required at 12+ locations, each with the same database structure containing unique data.

Is is possible to make the change on the development copy of the database, and copy the new database (.dbc,.dct,.dcx) files over the old ones at each location? (I am hoping to get some feedback before possibly destroying the installed data and having to start over)