SQL table data restore

By Gordinho ·

I need to restore specific lines of an SQL 2000 db table from backup to live db. I can't use DTS import as this will only append lines in the live db table ? The table is not corrupt but a user has deleted some data in the table that I need to reconstruct from backup ideally without having to type the lines in manually (not that there are many of them). Anyone know of any simple table compare and insert into type scripting engine? I'm not really a SQL dba so if any SQL gurus can help I'd appreciate any pointers.



This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

sussed it

by Gordinho In reply to SQL table data restore

Ignore this question...found a red gate sql data compare and sync tool.


Collapse -

red gate work out ok for you?

by Shellbot In reply to sussed it

let us know..

never used it myself..know a guy who did once and it made a mess of things :)

Collapse -

Yeah all good

by Gordinho In reply to red gate work out ok for ...


Yeah just downloaded a 14 day (full functioning) trial of Red Gate SQL Data Compare (looks to be part of the "SQL ToolBelt" package). Did a quick simulation of what I wanted to achieve with a dummy db/table and then applied it to the live. Looks to have worked ok but tbf I only used that one particular function...can't comment on any of the other modules in the package.

Related Discussions

Related Forums