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.
| Author |
Topic |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2008-04-10 : 11:01:58
|
| I'm looking for a tool that fulfils the following tasks. So far, I've looked at embarcadero, Red Gate, SQL Farms Combine, MS Team Edition for Database Professionals. But no one tool caters for 50% of the tasks. Can you recommend anything that you use or have used in the past?Business Area RequirementDatabase Development Ability to create and modify templates for all object types Auto generate simple CRUD procedure scripts for defined tables with standards integrated Auto amend dependent object scripts when updating an object Auto complete/telesnesis Ability to package DB's from source control to deploy to dev servers Ability to track dependencies through objects and identify impact of a change Track changes and restore DB to its previous state (what changes made by whom, when, etc) Ability to step through code to debug logical errors Ability to step through/analyse code for performance Test procedures and expected outputs/inputs (unit tests?)Rollback Auto generate rollback scripts for all objectsStandards Ability to define our development standards in templates/policies Auto check object scripts for standards adherence (reference a standards checklist?) - replace manual peer review processReview Process Ability to manage review lifecycle through tool: Method to manually comment against an area of code/against an object script (particular revision) as a reviewer or developer Ability to generate report/historical view of comments against objects for view or printing - including object revision Ability to build report of all comments assigned for a specific review by a developer and/or reviewer Ability to build report of comments assigned to a specific object by a developer and/or reviewerSource Control Ability to plug into source control (Dimensions, Team Foundation, etc) Ability to build releases from source controlRelease Management A mechanism to build deployment scripts (e.g. concatenating objects together to create a script for each object type) Ability to deploy scripts to multiple servers and environments through a single interface Automate deployments to different servers/databases (DBT/INT/OPS). Ability to schedule them to occur during the evening and generate/email a deployment report to detail status and any errors/issues Permanently record any deployment issues Ability to generate quick and compressed backupsDeployment tracking Permanently record all objects released in a deployment, to which servers, which versions, by whom, which baseline, date deployed, etc Ability to generate reports on previous deployments: Search for what was included in a specific release, search on specific dates, search on specific objects/object types, etc Ability to archive/keep several version of deployment scripts/packagesTest Data Ability to generate test dataSchema comparisons Ability to compare database schemas and synchronize Ability to compare database data and synchroniseHearty head pats |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-10 : 11:09:06
|
apex has some tools that might provide you maybe 50% of that  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2008-04-10 : 12:02:32
|
| Great, thanks Spirit. I have contacted the company and am eagerly awaiting their reply!! :)Hearty head pats |
|
|
|
|
|
|
|
|
Database developer tools