Moving of Stored Procedures

Need a little advice,
I am creating an application, created two databases, one for building
the app. And the other is for when it is running. Is there a simple way
of copying the stored procedures to the one that i will be running the
app on? All the tables and columns are named the same in both.
Tom
*** Sent via Developersdex http://www.codecomments.com ***We migrate the sp with custom made table and sp.
We have table with 'from server', 'To Server', 'sp_name' and' permission'
information, which I populate for any sp migration using bcp. This table and
script can differ depending on your needs.
We also use a script that is built around sp_helptext, which can create the
drop sp statement, and script and permission. This is only useful if you do
extensive version control. Please let me know if you found and easier way t
o
deal with this.
Sam|||You can simply script out the stored procedures using Enterprise Manager by
right clicking on the db, going to all tasks then generate scripts. Take
that script(s) and run it on the other database via query analyzer. You can
also invest a few dollars into a tool from www.red-gate.com that will
compare the two db's and tell you want is different. It will also generate
the scripts to make them both the same. It's really worth the few hundred
dollars if you do this often.
Andrew J. Kelly SQL MVP
"Thomas Beyerlein" <tbxml@.yahoo.com> wrote in message
news:%23C7dnX%23NGHA.1676@.TK2MSFTNGP09.phx.gbl...
> Need a little advice,
> I am creating an application, created two databases, one for building
> the app. And the other is for when it is running. Is there a simple way
> of copying the stored procedures to the one that i will be running the
> app on? All the tables and columns are named the same in both.
> Tom
>
> *** Sent via Developersdex http://www.codecomments.com ***