Post reply

Copy filtered data from one table to other.

  • March 22, 2013 at 6:04 am

    #100510

    Hi,

    I have two database one is live and other dead.

    In both of the database there are same tables and columns.

    Now i have to migrate all tables data from one database to other with several condition and delete those datas from live DB.Later in future i should be able to retrieve the data from dead database to live.

    Any help will be appreciable.

    Thanks in Advance

    Priyanka Rao

  • March 22, 2013 at 6:20 am

    #1599734

    May i know what is the reason why you need data from Secondary database to live database again?

    http://www.sqlstairways.com

  • March 22, 2013 at 6:23 am

    #1599737

    Actually there are many dead clients in my database , which are to be moved from live in order to reduce space.So in future if the client goes live then i should be able to retrieve those dead clients data from that database.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply