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 |
|
karuna
Aged Yak Warrior
582 Posts |
 Posted - 2006-02-03 : 01:29:58
|
| Hi All,I'm trying to find out a feasible solution for this. I'll try to explain the scenario as much as I can, if any one feels its not adequate, please let me know...Its more of theory..Scenario: I have a database which is used by many applications. There are some 300+ tables in this Database.Many of these tables are used /shared by some applications. For Eg: Table1 can be used by App1 and can also be used by App2, which also use Table2.We are rewriting these applications on a different platform, so we are also restructring the existing database, so that we can reduce the number of tables and bring in proper relationships and constraints. At the end we might end up with around 100 tables.The applications which are getting re-written will be rolled out in a phased manner, which will also use the restructred DB. This restructure DB will have data migrated from the existing db. Problem: When my new applications use new db, my old applications will use old db. So when a new record is inserted / updated / deleted using old application in old database, I want that data to get inserted / updated / deleted in my new database and Vice versa.Solutions:Triggers, DTSComplexity: The two databases will be on a different server in different locations on a WAN. There will also be some applications which might insert / update / delete in a batch mode, say some 1000s of records. There are some tables records, which has to availble to other database within shorter timelag if any changes are there...Any suggestions?ThanksKarunakaran |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2006-02-08 : 22:45:29
|
| Is triggers a right solution for this?ThanksKarunakaran |
 |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2006-02-08 : 23:41:13
|
| Hi,if you use triggers it will cause a problem to you , refer below thread :http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10995http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9644if you need to merge the records then why don't you use merge replication !?:-)RegardsAndy DavisSql Shield Team--------------------------------------------SQL Server Encryption Softwarehttp://www.sql-shield.com |
|
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2006-02-09 : 07:18:49
|
| The problem for me is that both databases will be of different structre.. So I'm not sure how much merge replication will help.. And there will be some batch process intra day and night how will merge replication behave there.. Will it go into any deadlock scenariosThanksKarunakaran |
|
|
|
|
|
|
|
|
Data Migration And Replication...