Data synchronization ? - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Data synchronization ?

Author

Topic

betterdays
Starting Member

1 Post

Posted - 2009-05-28 : 14:57:01

I hope this is the correct forum to ask...and I hope I can ask it clearly.
Ok, here is the weird predicament my team is in. We have two applications with sql server 2005 backends. The two sql server databases have different structures but pretty much has the same data being stored. The second application was developed to replace the first legacy application. The second application has additional data and most of the data is stored differently but we can massage the like data to map.
So here is the big issue, the customer is making us run both applications concurrently and sync the databases on changes. So if a user inserts a record on the legacy system that record would have to somehow be inserted on the new system and vice versa. Any change would have to transfered to the other database. Is there any way to handle this situation?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-28 : 15:13:18

yup...assuming that most of involved tables are same, you can configure replication between the old and new databse. more details in below link

http://www.cryer.co.uk/brian/sqlserver/howtoreplication.htm

http://www.databasejournal.com/features/mssql/article.php/1438231/Setting-Up-Merge-Replication-A-Step-by-step-Guide.htm

http://www.databasejournal.com/features/mssql/article.php/1438201/Setting-Up-Transactional-Replication-A-Step-by-step-Guide.htm

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-05-28 : 15:54:53

But I would really try hard to get rid of that kind of mixed system!!! i.e. displace the legacy system ASAP.

No, you're never too old to Yak'n'Roll if you're too young to die.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-06-14 : 12:13:36

You need 2-way replications.

SQLRatankalwa
Starting Member

42 Posts

Posted - 2009-06-16 : 09:10:19

If you find difficulty in replicating the data across using replication. Please let me know how many tables are involved, there is a quick and easy solution to handle your problem.

If the number of tables are less and If you are ready to put an additional column in all the tables in both the databases then I can assist you with a solution.

Ratan Kalwa
SQL Server Professionals User Group

http://www.revalsys.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources