May 6, 2004 at 9:49 am
I need to put together a chnage control system for a vb application using 2 sql server 2000 databases, which uses crystal templates for reports. I am not too concerned with the vb side of things as the app is maintained by a third party.
I want something that will hold new/edited stored procedures for example and enable me to run them in bulk through a front end rather than running each one individually. I would also like to update data between identical tables. Additionally, I want a change control system that can identify newer/new crsytal reports and copy these over as well.
A big ask, I think, but any help would be appreciated.
May 6, 2004 at 12:35 pm
Any VCS system will do this, but will require some manual work and administrative enforcement. Not sure if any tools integrate with Crystal, but some 3rd party tools, XMSSQL, embarkadero tools, etc. integrate with SQL stuff. Hard part is teaching people not to use EM.
May 7, 2004 at 3:13 am
Thanks, Steve. Luckily I will be the only person working with the stored procedures. Unfortunately, the bar was raised late on yesterday when the system functionality requested was expanded to include some system parameter changes as well. I will put a proper spec together for the business so that I can find out the exact requirements and then take a look at some of the solutions you have identified.
May 7, 2004 at 8:00 am
I've found that mssqlexpress http://www.xpressapps.com/Home.shtm provides our team with the integration into vss . As mentioned keeping users out of EM is not easy but good integration into VS helps ..
May 10, 2004 at 3:25 am
Thanks for all the ideas. I found that I will have to split the job into two applications. The embarcadero tool is great for the sql side. On the application side I came across a greate system from a company called Aim. Link: http://www.change-management-expert.com/. This application is super basic and holds attachments, which are useful for holding sql scripts if need be. Hence, I get the best of both worlds.
June 2, 2004 at 6:14 pm
check out Apex SQL Edit - VSS integration and soon Vault
http://www.apexsql.com/sql_tools_edit.htm
Brian Lockwood
President
ApexSQL - SQL Developer Essentials
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply