March 7, 2006 at 5:50 am
Dear All,
I have one database and i purged my database once now i have the purged data on my backup machine and the current data is on my main server now what i need is i will take one backup of my main server database and i want to combine both the data into one. for example i have started operation on april 2004 and i purged my data on 31 may 2005 to till now i am running with data from april 2005 i need to combine the both the data in to one backup so that if i restore the data on my backup server i should be able to see the data form april 2004 to till now. is this possible if so please help me
Regards
Anoop
March 7, 2006 at 7:22 am
Instead of restoring the main database to the current one, try to export all the data from the main to current one. So that you can have the both databases
March 7, 2006 at 8:08 am
You need to merge two databases. You cannot do this with backups, so restore to two different spots and then merge them.
March 7, 2006 at 9:46 am
Dear All,
Thank you for your valuable replay please can tell some more detail about merging of two databases i.e steps please because i delibaratly need this otherwise this will be a very big problem you know
Regards
Anoop
March 7, 2006 at 12:50 pm
generate the sql script for the main database and run that script in current database query analyzer. So , you can create the all table structures of main under the current database. Then using Dts export the data from main to current one. so that you can have two databases
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply