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 |
kotsas
Yak Posting Veteran
65 Posts |
Posted - 2002-10-30 : 05:00:25
|
Has somebody know where I can find concepts about shadow database. I like to merge some information from oracel and sql 2000 database in this shadow database |
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-10-31 : 13:22:33
|
It sounds to me like what is being requested is incompatible in concept.I take it that a "shadow" database means a database which has the same contents as the database it is shadowing. This could be accomplished by replication or log shipping. Of course with either of these methods there would be a delay before the synchronization occurred.Now when one says that they want to merge some data in from two other sources (into the "shadow" database), this mean by definition that the "shadow" database is no longer a "shadow".So, I am at a loss as to what you are trying to accomplish.Maybe you could provide more definition on your original request.Thanks solart |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-10-31 : 13:24:19
|
Please explain your definition of "Shadow".--HTH,Vyashttp://vyaskn.tripod.com |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-11-01 : 06:00:41
|
By shadow do you perhaps mean you want to set up a mirrored database ?certain RAID arrays can accomplish this i believe===========Paul |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
|
|
|
|