How does redo/undo work for sql server

Question

0.00/5 (No votes)

See more:

, +

In my app,I want to implement the undo/redo for the database like MS office does.
I wonder if there is a mechanism to do this for sql server 2008.
Thank~ :)
even if user shut down the app,next time he still can redo/undo what he did before.

Posted 24-Jul-11 16:09pm

eric881027

Updated 24-Jul-11 19:53pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

walterhevedeich · Answer 1 · 2011-07-24T16:28:00

Solution 1

Not that I know of. For undo, the only efficient way you can implement it is by restoring your backup. You can, however, implement a history mechanism on your code record what is happening to your records. The drawback, on the other hand, is an additional space and processing on your database. It might be applicable for small applications, but not for large systems.

[Update]

This might be a helpful resource when you want to learn about SQL Triggers.
http://www.sqlteam.com/article/an-introduction-to-triggers-part-i[^]

Posted 24-Jul-11 16:28pm

walterhevedeich

Updated 24-Jul-11 19:39pm

v2

Comments

eric881027 25-Jul-11 1:12am

if can I record all the actions in a table or a log?

walterhevedeich 25-Jul-11 1:19am

Exactly. I did a small project before where I used triggers to record the activities made to a record. You might want to explore about that one. Basically, what I did was to use it to insert a log into a table whenever an insert/update/delete is made to the record.

eric881027 25-Jul-11 1:32am

Yeah,this is what I am thinking about.Do you have any experience about that,what need be paid attention to?

walterhevedeich 25-Jul-11 1:40am

Read more about SQL Triggers. I have updated my answer and included a URL where it might help for your learning.

eric881027 25-Jul-11 1:51am

But I have to use the SQL CE,it does not support trigger.

walterhevedeich 25-Jul-11 1:58am

If it doesn't support it, then can modify your stored procedures to insert a record on the logs table after executing the original statement on the SP. If you are not using Stored Procedures, then you can do it on the code. Its pretty straightforward since the logic on how you insert records from your app to your database will be the same with what you are going to do with the logging functionality.

eric881027 25-Jul-11 2:04am

Yeah,I am working by this way.

walterhevedeich 25-Jul-11 2:18am

You mean you are using stored procedures? Then it would be pretty straightforward to implement a logging functionality. Just add a script to insert a record on your logs table. It might be a pain in the a** if you have many SPs. :)

eric881027 25-Jul-11 2:33am

No,I do it all on the code,as the SQL CE does not support the stored procedures

walterhevedeich 25-Jul-11 2:46am

See my previous comment. Just pattern the logic of how you are inserting your records to the database to the logging functionality.