Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 DB objects deployments

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2013-01-28 : 02:07:36
Hi Experts

I need to bring standard methods to bring the deployment process org wide,if somebody can share some templates which you are using will be helpful to adopt some of them in our org as well.

Any links will be helpful in this regard.


Thanks,
Gangadhara MS
SQL Developer and DBA

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-28 : 07:40:39
You may want to investigate Red Gate deployment tool. Not sure if there are other free tools that do similar thing: http://www.red-gate.com/products/sql-development/sql-packager/
Go to Top of Page

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2013-01-28 : 13:10:40
I'm not sure what resources you have access to, but if you do have Visual Studio, I'd recoment using Sql Server Data Tools (SSTD) add-in. It is a free download from MS and adds Sql Server Projects (different from the older Database Projects that come with VS). That provides a pretty rich tool set for doing schema comparisons and deployments.
Go to Top of Page
   

- Advertisement -