I got into a mini-argument with my boss recently regarding "project failure." After three years, our project to migrate a codebase to a new platform (a project I was on for 1.5 years, but my team lead was on for only a few months) went live. He, along with senior management of both my company and the client (I'm one of those god-awful co...
My organization's main project went live on Monday. That was my third day here. Now that I've been here almost a week, I'm tasked with creating a change management plan for the maintenance of the application and preparation for phase 2, which will commence "someday." We're a Microsoft shop but open-minded. I'm looking for some suggestio...
One of my projects use the MyISAM engine in MySQL, but I'm considering changing it to InnoDB as I need transaction support here and there. What should I look at or consider before doing this? Can I just change the engine, or should the data be prepared for it? ...
I have been tasked with developing a solution that tracks changes to a database. For updates I need to capture: date of update old value new value field effected person doing change record id table record is in For deletes: date of delete person doing delete The title/description/id of record deleted. The tables I am tracking cha...
In Clearcase I can generate a "label" for a given set of files and always go back to that label to regenerate all the files as they were when I generated the label. How do I do this in Subversion? I'm using the Tortoise front end [Windows] to SVN and I'm not sure how to accomplish this functionality. ...
I am about to try and automate a daily build, which will involve database changes, code generation, and of course a build, commit, and later on a deployment. At the moment, each developer on the team includes their structure and data changes for the DB in two files respectively, e.g. 6.029_Brady_Data.sql. Each structure and data file i...
Hello, We have a large ASP.NET project consisting of several hundred reports. We are in the process of moving all the SQL Queries (running against an Oracle Database) into three web services. The web services are categorized by command, selections and report queries. We have to deploy a sub-set of our project using a SQL*Server backe...
We enable "Tools ==> Options ==> Designers ==> Table and Database Designers ==> Auto Generate Change Scripts" in our SQL Server Management Studio (SSMS). When changing our database schema, we save the script and, thanks to DB migration tools we've got installed on all the machines running our applications, we can synchronize the schema d...
Steve Yegge's wisdom notwithstanding, most developers are faced with requirements which were gathered from non-technical customers. Sometimes there are project managers who deal with the customers and translate their requirements, other times not. In any event, the fact that the requirements will change is an inevitability. Most of wh...
It's been few weeks I'm trying to find a more detailed explanation with examples how to manage my database change on software patch. Situation: I deploy wpf application release to user. App uses MSSQL data file for storing app's data (Deploying with Client Profile and SqlServer Compact 3.5 prerequisites) In further development databas...
Hi, I am using subversion as an RCS and Bugzilla for issue tracking. And i just ask myself how to create automatic change logs for the users? I already tried the "svn2cl" tool. But the change logs it creates are to technical for me (e.g. no user want's to know that developer XY changed 20 files yesterday to fix a memory leak). A user w...
We maintain a set of change scripts that must be run on the DB when our web application is released. We waste a lot of time and experience some difficultly keeping these updated however, our DBA likes to (rightly) tweak stored procedures and schemas on the live system to maintain system performance. Every so often we have to rebase our...
Let me pose a bit of background information before asking my question: I recently joined a new software development group that uses Rational tools for configuration management, including a source control and change management system. In addition to these tools, the team has a standard practice of noting any code changes as a comment in ...
Hi Guys, I am currently working on company which has several products with the same release cycle. The problem that i got is i will need to create release file which include all files released and what the change for. And there are number of occasions where clients pullback from the change close to the release date. The difficulty ...
What do you do when your (external) client's users don't have the time/will to actively participate in iterative development? How do you "force" them to get implicated? Remember that often they must do this while still completing all their regular duties and that the IT department, who sponsors the software project, doesn't have the pow...
Hi Lets say I have a lists of entities (for example, a list of TODO items) that more than one user can change, delete from and add to at the same time. So to maintane a synchronized listed between all the clients, I want each client (AJAX based) to ask for changes every xx seconds. Since the list can get veeery long, I do not want to d...
Is it possible to add a column to a table at a specific ordinal position in SQL Server? For instance, our tables always have CreatedOn, CreatedBy, LastModifiedOn, LastModifiedBy columns at the "end" of each table definition? I'd like the new column to show up in SSMS above these columns. If I am scripting all my database changes, is t...
We are developing an application with components on multiple physical tiers, sharing many assemblies as well as having some exclusive to each tier. I am wanting to know what the typical versioning strategy is for release hot-fixes, or only a few components of the application. Our issue tracking software contains a version number for ...
Say, I made many changes to my code and only need to commit a few of those changes. Is there a way to do it in mercurial? I know that darcs has a feature like this one. I know "hg transplant" can do this between branches, but I need something like this for committing code in the present branch and not when adding change sets from some o...
A programmer on your team is great at maintaining the old legacy system. But the company has switched to a new technology/platform. What do you do with the no-longer-effective developer? ...