• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

SQL Script File Organizer

I would like a utility that prints the history of actions taken on entries in a SQL script file.  

Say, an entry is added with an INSERT INTO.  Subsequently, the name is UPDATEd.  Later, the code for the entry is UPDATEd.  Similar actions are present in the script file, which is created from an accumulation over time of INSERT INTOs and UPDATEs.

I want a utility that will accumulate all actions on each entry together, giving the event by event action.  I want to avoid having to manually review the entire file, manually aggregating the information for each entry.

Does such a utility exist?
3 Solutions
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
You are looking at something that may handle your code versionning.  You may see Visual Source Safe (included in some edition of Visual Studio)...

Hope this helps...
Dear LarryAndro

I have never seen anything of a sort as far as I know
Code Safe if you are using SQL Server 2005 I don't know if this applies for 2000

Also I am not sure if its Code Source what he is looking for
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

LarryAndroAuthor Commented:
Thanks for help.  chiraqkhabaria, I haven't digested everything that I found in your link.  But, I think it will bring me to the product I want.
Well, its the protocols which many people follow to maintain the database related updatess..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now