Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
murd
Starting Member
24 Posts |
 Posted - 2012-10-25 : 11:00:21
|
| -I have a back up 5 months old. -I would like to place this db live until i recover the newer database-I applied a two service packs (in the newer database that I need to recover) that might have some changes made since the 5 month old one. - Now I would like to merge the 5month old one to the recovered one (which will end up having the same structure after service packs) how could i go about merging to two? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 11:25:49
|
| you need to restore it as a new copy and then move schema objects across if you want to preserve the service packs------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
murd
Starting Member
24 Posts |
Posted - 2012-10-25 : 11:35:02
|
| -which db I would have to restore as a new copy-are there simple steps in moving schema objects? what I plan to do is restore the 5 month old db...service pack it so it will match the recovered mdf(because that one has the service pack). then merge the two? sorry for my slowness |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 11:39:36
|
quote:
Originally posted by murd
-which db I would have to restore as a new copy-are there simple steps in moving schema objects? what I plan to do is restore the 5 month old db...service pack it so it will match the recovered mdf(because that one has the service pack). then merge the two? sorry for my slowness
your backup db which is 5 months oldwhat all schema objects are you interested in? tables alone or all objects? do you need data as well?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
murd
Starting Member
24 Posts |
Posted - 2012-10-25 : 11:46:39
|
quote:
Originally posted by visakh16
your backup db which is 5 months oldwhat all schema objects are you interested in? tables alone or all objects? do you need data as well?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
if possible, all schema objects assuming its the same thanks for all your replies |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
murd
Starting Member
24 Posts |
Posted - 2012-10-25 : 13:10:30
|
| thanks alot this should guide me to my destination |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 15:03:52
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Database merging scenario (newbie)