| Author |
Topic |
|
clement.store
Starting Member
25 Posts |
 Posted - 2010-07-03 : 00:28:26
|
| Hello there,A - SQL server 2005 standard sp2 ( production for system A - preferably left intact)B - SQL server 2005/2008 R2 standard. ( for replicate /Mirror / .... from A )I have sql servers as the above. Here's my situation: My difficuluty is that I dont want to intefere with A but i need to syn data from A to B in order tocreate some dynamic views in B based on A for some reporting. ANd I need to keep A intact as much as possible except configuring for sync. Would u have any clue as for which means would be best for my scenario ?Thanks a lot!Clement |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
clement.store
Starting Member
25 Posts |
Posted - 2010-07-04 : 05:14:03
|
| I m actually having a business object server 3.1 on B. And I wilL create some dynamic views from A since A is having new tables anytime. I have learnt that mirroring is not a viable solution. And I wonder if I shud use oneway replication A->B since dynamic views only exist in B. I m still googling a way to find an easy way to implement transactional replication. I have some stored procdure for creating these views on B( executed when there is new table in A). There will also be some master data fed from SSIS. Pls hint me on an easy way to achieving it. Thank you. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
clement.store
Starting Member
25 Posts |
Posted - 2010-07-07 : 02:13:58
|
| The data can be like 15 minutes lag. Thank you very much for all your time. I have finally created another database in the same instance and access the source db using the db.owner.table notation. This way, i kept all the sp or views in the new DB. ANd I can keep the source DB intact. Yet I have learnt a lot about replication and mirroring in these forums. Thank you to SQLteam.com and sql server central that I have benefited so much from your experiences. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
clement.store
Starting Member
25 Posts |
Posted - 2010-07-07 : 21:35:50
|
| Thanks for the suggestion and I will probably use synonyms for coding. |
|
|
|
clement.store
Starting Member
25 Posts |
Posted - 2010-07-08 : 04:38:45
|
| But I wonder if there's any mechanism built inside SQL server that when I m reading data from a table while other programs are trying to write things on the same table at the same moment. Would there a conflict...? Cus the read and write applications are from different programs. So Does it mean i have to implement a table lock when executing reporting operation on A ..?thanks again. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
mirror , replicate or else...?