I was very fond of using the sql 2000 DTS wizard to move stored
procedures from one db to another. It was dirt easy using the wizard.

I opened up sql 20005 management studio, right clicked on the db >
Import Data> and there is no longer the option "move objects between
db" anymore!

Where did it go? I would like a wizard to do this because i do it
often. I do not want to use the sql developer studio DTS/coding thing.
I don't have time for that nonsense every time I want to move procs
over.

Please help.

Hello tom.a.miller (AT) gmail (DOT) com,

Unfortunately then the IMP/EXP wizard no longer has this option in SQL Server
2005. I am afraid you will need to use BIDs to do this, if only to create
a package that will do the transfers. You can build the package so that
it drops the destination objects forst and then move the procs over.

Allan

Does anyone have a tutorial how to do this? I cannot find a tutorial
that explains how to do this. Please help, I have been googling for
awhile.

Hello tom.a.miller (AT) gmail (DOT) com,

You could use the transfer objects task to do this.

Allan