Post reply

how do I move stored procedures and functions only from development to production

  • October 3, 2006 at 10:36 pm

    #68957

    I have two servers, each with a copy of my database on it. One I use to develop on and the other is the production database.

    So I developed a bunch of new stored procedures and functions and now I need to move these objects to production but I can't figure out how.

    I also need a nightly copy of the production data to the test database tables, but it would probably be best if it did not copy all the objects since I could be working on a stored procedure and I wouldn't want to lose it midway through development!

    Anyone have any advice? I am using Yukon.

  • October 5, 2006 at 12:55 am

    #664223

    Hi,

    With Integration Services. You can make some objects tranfers and copy. In fact Integration Services is the same thing (in best) than DTS in SQL2K.

     

     

  • October 5, 2006 at 2:17 am

    #664243

    To do a one-off copy of new SPs and functions to another database, just script them from Management Studio into a new query window, connect to the target database and execute the script there.  But for regular transfers of objects and data, Integration Services is definitely the way to go.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply