Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Copy filtered data from one table to other. Expand / Collapse
Author
Message
Posted Friday, March 22, 2013 6:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 22, 2013 7:10 AM
Points: 2, Visits: 3
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
Post #1434216
Posted Friday, March 22, 2013 6:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:13 AM
Points: 1,255, Visits: 703
May i know what is the reason why you need data from Secondary database to live database again?

http://www.sqlstairways.com
Post #1434223
Posted Friday, March 22, 2013 6:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 22, 2013 7:10 AM
Points: 2, Visits: 3
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.
Post #1434226
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse