Software

Ask something
Question Locked

SQL table data restore

0 helpful
4 replies

by gordinho

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

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.

cheers

G

4 replies

by gordinho

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

G

by shellbot

let us know..

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

by gordinho

Hi,

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.

This discussion is closed to new replies.