SQL Server Performance

Using DTS for restoring deleted data

Discussion in 'SQL Server DTS-Related Questions' started by miles60, Jun 29, 2005.

  1. miles60 New Member

    I am a newbie to DTS and working on cleaning up several tables in a database. I am looking at a process where I can use delete rows from each table, store them as text files, and then, if necessary, reinsert the data if errors in the program occur as a result of the deletion.

    It appears to me that DTS would be a good tool to use for this procedure. Does this sound like a feasable concept?
    miles60, Jun 29, 2005
    #2

  2. satya Moderator

    Yes you can use DTS or OSQL to export the data out to text/csv files.

    But I suggest rather than exporting to a text file externally, it is better to transfer the data between 2 databases where one can used as source and another as contingency. This way you can easily rely on SQL internal process.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Jun 29, 2005
    #2

  3. ranjitjain New Member

    I'll go with satya.
    I feel creating another DB in SQL would be more adaptable.
    It will be faster and more safer.
    But Why do u need this kind of deletion and again restoring.
    ranjitjain, Jun 30, 2005
    #2

  4. silicon_master New Member

    quote:Originally posted by miles60

    I am a newbie to DTS and working on cleaning up several tables in a database. I am looking at a process where I can use delete rows from each table, store them as text files, and then, if necessary, reinsert the data if errors in the program occur as a result of the deletion.

    It appears to me that DTS would be a good tool to use for this procedure. Does this sound like a feasable concept?


    Hi i think can't you do this work by bcp which will much faster and you can call its command from the front end also.

    Silicon Master
    silicon_master, Jul 1, 2005
    #2

Share This Page