Post reply

Database objects deployment

  • November 5, 2009 at 4:27 am

    #211927

    Hi,

    Iam a junior DBA, i want to know how to deploy database objects from development server to production server.

    Thanks

    Koteswar Rao

  • November 6, 2009 at 7:55 am

    #1075908

    Check VCDBCMD tool

  • November 6, 2009 at 8:03 am

    #1075914

    Did you not read your own thread on this same topic from the other day with many excellent replies ?

    http://www.sqlservercentral.com/Forums/Topic813414-146-1.aspx

    I would suggest you read them, then post specific questions in that thread instead of starting a 3rd thread with the same generic question.

  • November 6, 2009 at 8:04 am

    #1075917

    Red Gate SQL Compare is a pretty good tool for this.

    Visual Studio Team System Database Professional Edition is a great tool for all aspects of managing database projects, including deployment.

    There are other tools that can do the job, those are just the first two that come to mind.

    You can also just script the objects manually and run the scripts on the target server.

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

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