SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 row versioning
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

adnanans78
Starting Member

Pakistan
17 Posts

Posted - 08/22/2007 :  02:27:55  Show Profile  Reply with Quote
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

Slovenia
11751 Posts

Posted - 08/22/2007 :  02:38:05  Show Profile  Visit spirit1's Homepage  Reply with Quote
you can achieve this by auditing your changes
or by adding a timestamp column to your table which is unique ever increasing value
or by proper use of full, differential and transaction log backups


_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

adnanans78
Starting Member

Pakistan
17 Posts

Posted - 08/23/2007 :  02:10:33  Show Profile  Reply with Quote
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.
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 08/23/2007 :  04:18:45  Show Profile  Visit spirit1's Homepage  Reply with Quote
you can keep the database schema (structure) inthe source control. but not it's data.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

adnanans78
Starting Member

Pakistan
17 Posts

Posted - 08/23/2007 :  09:27:52  Show Profile  Reply with Quote
Thanx
Yes 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...
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 08/23/2007 :  12:09:44  Show Profile  Visit spirit1's Homepage  Reply with Quote
help you with what exactly?
it's not clear what you really want.
please explain in more detail.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

adnanans78
Starting Member

Pakistan
17 Posts

Posted - 08/23/2007 :  15:13:02  Show Profile  Reply with Quote
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...
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 08/23/2007 :  15:25:50  Show Profile  Visit spirit1's Homepage  Reply with Quote
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 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 08/23/2007 :  23:19:36  Show Profile  Reply with Quote
If looking for third party tools, check Lumigent's Audit DB.
Go to Top of Page

adnanans78
Starting Member

Pakistan
17 Posts

Posted - 08/24/2007 :  05:32:31  Show Profile  Reply with Quote
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.

Thnx


Any way to handle such situation.or any component.

Plz help me in this regard.
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 08/24/2007 :  05:35:00  Show Profile  Visit spirit1's Homepage  Reply with Quote
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 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 09/05/2007 :  17:31:49  Show Profile  Send jen a Yahoo! Message  Reply with Quote
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 instance

have 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 on

that's how i see your situation, don't stress yourself on this

but 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...
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000