Sunday, February 19, 2012

how to copy only the stored procedures to another server/database

Hi all,
I am just getting my feet wet with SQL server, and need
to only copy the stored procedures from one db to another. I tried the
export tool, but even though it allows me to select the objects I want, it
also tries to copy other objects (such as user names), and it fails because
they already exist in the other db.
Thanks in advance,
Carlos.Don=B4t know what you mean by "export tool", But either in the Script
generator of the Enterprise manager as well as in the DTS wizard you
can define if you want to script out / export the depended objects. If
you don=B4t want them just change the tab, deselct the options and
script out / export the objects to the other database.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
--

No comments:

Post a Comment