Subject | How to pump data with criteria |
---|---|
Author | ettotev |
Post date | 2011-08-01T09:45:30Z |
Hi
I have a big corrupted database (> 1GB). With many trials and errors I was able to determine that the corruption only affects small number of records in one (large) table.
I want now to pump the good data from the corrupted database into a new one, skipping only the records I know are corrupt. Can anyone suggest a suitable tool that can use a 'where' clause when pumping data?
Thanks in advance
Emil
I have a big corrupted database (> 1GB). With many trials and errors I was able to determine that the corruption only affects small number of records in one (large) table.
I want now to pump the good data from the corrupted database into a new one, skipping only the records I know are corrupt. Can anyone suggest a suitable tool that can use a 'where' clause when pumping data?
Thanks in advance
Emil