SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 DB objects deployments		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gangadhara.ms
Constraint Violating Yak Guru

India
497 Posts
Posted - 01/28/2013 :  02:07:36  Show Profile  Visit gangadhara.ms's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

1481 Posts
Posted - 01/28/2013 :  07:40:39  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3821 Posts
Posted - 01/28/2013 :  13:10:40  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000