SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database table Change


Database table Change

Author
Message
Lucky9
Lucky9
SSC-Addicted
SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)

Group: General Forum Members
Points: 490 Visits: 297
Please could someone help with the Immediate decision..

we have an application and there are 500/600 Users who access the application.

There are around 30 to 40 main tables exists for the application.
some tables have 5 million,some have 10 million and some tables have more then 40 million records....

my manager would like to know if any change happened in any of the row/column in any of the table...if yes then she wants to have the old record saved some where.....

for example: we have a Customer table...which has 40 columns in the table....
if any one of the column/row value has been changed by any user then i have to keep track of the old record...


Below are my Ideas...


I can write trigger on 30 to 40 tables...

but below are the problems...

It makes the application slow...and some records are updated by import process from the web services ...so they cannot
handle by the trigger....

i thought of mainting the history tables were i will be loading the records which been updated daily...but some of the tables do not have the modified date...so i do not know what record has been updated in that table....and if i keep on inserting the records into the history tables...then the table might keep on increasing the volume...


In the meeting team had couple ideas...they want to remove the update button on all the modules on the application...
and to remove the web services option for the users ...which will not have the update option ...If the user wants to update anything on the application..they will not be able tooo...they can only add new records...

But they did asked me instead of removing the update option on all the modules on the application...Is there any other way
that i can do from database side...that i can keep track of any column/row changes in any of the table in that database...


Could someone please help me with some suggestions...i have to update the team as soon as possible...
GSquared
GSquared
SSC Guru
SSC Guru (105K reputation)SSC Guru (105K reputation)SSC Guru (105K reputation)SSC Guru (105K reputation)SSC Guru (105K reputation)SSC Guru (105K reputation)SSC Guru (105K reputation)SSC Guru (105K reputation)

Group: General Forum Members
Points: 105237 Visits: 9730
Please don't double-post.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Lucky9
Lucky9
SSC-Addicted
SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)SSC-Addicted (490 reputation)

Group: General Forum Members
Points: 490 Visits: 297
I am sorry...

I was confused and posted at both places....
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search