Author |
Topic |
adnanans78
Starting Member
17 Posts |
Posted - 2007-08-22 : 02:27:55
|
Hi, i am facing the following problem a couple of days.The Problem is that i want some changes multiple times in my existing database and want that all changes are saved by sql server and when i need to get last recent change in database, would be available.i think row versiong can do this,But not sure.Is there any feature like snapshoting by which my changed data shoule be saved.Hope some will help .Thanx in advance.Ali |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-22 : 02:38:05
|
you can achieve this by auditing your changesor by adding a timestamp column to your table which is unique ever increasing valueor by proper use of full, differential and transaction log backups_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
adnanans78
Starting Member
17 Posts |
Posted - 2007-08-23 : 02:10:33
|
Thnx for reply,I don't wan to change our database structure.I solution just like visual source safe.It keeps ur data according to version.you may view and compare its database.any one have idea database in such senerio.Thnx in advance. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-23 : 04:18:45
|
you can keep the database schema (structure) inthe source control. but not it's data._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
adnanans78
Starting Member
17 Posts |
Posted - 2007-08-23 : 09:27:52
|
ThanxYes u r quite right.Is there any way to right data intead of schema.There are some third party tools which also work in schema writing senerio.Help me more... |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-23 : 12:09:44
|
help you with what exactly?it's not clear what you really want.please explain in more detail._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
adnanans78
Starting Member
17 Posts |
Posted - 2007-08-23 : 15:13:02
|
Thnx,As i mantioned in 1st post that i have a database and could not change its schema to get aim..My aim is that i modify (insert,delete,update) database multiple times in a week.I want the way by which i can get multiple or any changes made in the database.some third party tools are available which save schema instead of data.I hope u will get my point very well.Hope will help me... |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-23 : 15:25:50
|
yes what you need is auditing.for it you don't need to modify the existing schema you just have to add new schema.you can also achieve this by proper backup strategy.another option is to use sql server integrated C2 auditing. but this can slow dow a server which is under a heavy load.http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlc2.mspx_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-23 : 23:19:36
|
If looking for third party tools, check Lumigent's Audit DB. |
|
|
adnanans78
Starting Member
17 Posts |
Posted - 2007-08-24 : 05:32:31
|
Thnx for reply,let me explain my point.I have a database which cotain 100 tables.I make some changes in its time to time.One is limitation that i have not premission to make changes in its schema (struture).After a while some complain me that i made a mistake on some date in some tables(insert,update,delete).how i can get such data for verification and modification and if i want to see difference in multiple changes.even i do not know about schema.If you think that i can get that data by schema then how,even tables have not date attributes.ThnxAny way to handle such situation.or any component.Plz help me in this regard. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-24 : 05:35:00
|
well if you can't change your schema, the you're left with proper backup strategy or C2 auditing.Just how many times am i supposed to repeat that????_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-05 : 17:31:49
|
if you have no control on the database you are working on and you want to prove you didn't make any mistake... keep the changes you make in your local server instancehave your DBA or someone verify your work...i think the question is of trust... if they can't trust you to do your job properly you should start thinking of moving onthat's how i see your situation, don't stress yourself on thisbut like what Spirit mentioned, you need an audit trail... ask your DBA to create a new database where you store all the changes you make... and prove credibility, ask him to just give you insert permissions on that database audit tables--------------------keeping it simple... |
|
|
|